Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

  • JDBC driver not installed error for SQL Server 2008

    I'm using the following:
    1- smart client version: v8.2p_2012-11-12/EVAL Development Only
    2- Browser Google Chrome Version 23.0.1271.64 m
    --------------------------

    The problem is:
    ----------------
    I opened the Admin Console in order to create a new data source on sql server 2008 R2 DB. I have an error indicating the JDBC driver not installed.
    I already put the sqljdbc.jar and sqljdbc4.jar files in folder ...\smartclientSDK\WEB-INF\lib
    the connection data I provided is as follows:
    - Database Name: TEST
    - Database Type: SQLSERVER
    - Obtain connection using: DriverManager
    -Driver Implementer: com.microsoft.sqlserver.jdbc.SQLServerDriver
    - Specify Explicit driver url : Checked
    - Driver URL : jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=TEST;User=sa;Password=mypassword

    Also I tried Driver Implementer to be : com.microsoft.jdbc.sqlserver.SQLServerDriver

    When I click the test button, I have 6 error messages indicating there is an error
    Can anyone help me to solve this problem?

  • #2
    You need to post the complete server-side log for the attempt to connect (always post this log for any server-side issue).

    Comment


    • #3
      Thank you for your reply. I need to know how to check the server log and from where?

      Comment


      • #4
        === 2012-11-13 08:14:41,766 [sor2] DEBUG BuiltinRPC - Testing DB connection for database: TEST with config: {
        dbName:"TEST",
        "database.type":"sqlserver",
        "interface.type":"driverManager",
        dbStatus:"JDBC Driver not installed",
        driver:"com.microsoft.sqlserver.jdbc.SQLServerDriver",
        "driver.url":"jdbc:sqlserver://AAMIN\\SQLEXPRESS:1431;DatabaseName=TEST;User=sa;Password=Amino1982",
        useURL:true,
        "driver.serverName":"Embedded in JDBC URL",
        _selection_9:true,
        "driver.context":"",
        "interface.credentialsInURL":true,
        "driver.driverType":"thin",
        "driver.networkProtocol":"tcp"
        }
        === 2012-11-13 08:14:41,767 [sor2] DEBUG PoolableSQLConnectionFactory - Initializing SQL config for 'TEST' from system config - using DriverManager: com.microsoft.sqlserver.jdbc.SQLServerDriver
        === 2012-11-13 08:14:41,767 [sor2] DEBUG PoolableSQLConnectionFactory - com.microsoft.sqlserver.jdbc.SQLServerDriver lookup successful
        === 2012-11-13 08:14:41,767 [sor2] DEBUG PoolableSQLConnectionFactory - DriverManager fetching connection for TEST via jdbc url jdbc:sqlserver://AAMIN\SQLEXPRESS:1431;DatabaseName=TEST;User=sa;Password=Amino1982
        === 2012-11-13 08:14:41,767 [sor2] DEBUG PoolableSQLConnectionFactory - Passing JDBC URL only to getConnection
        === 2012-11-13 08:14:41,769 [sor2] INFO BuiltinRPC - testDB (TEST) error: java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
        === 2012-11-13 08:14:41,769 [sor2] DEBUG RPCDMI - rpc returned RPCResponse
        === 2012-11-13 08:14:41,769 [sor2] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
        === 2012-11-13 08:14:41,770 [sor2] INFO Compression - /tools/adminConsoleOperations.jsp: 325 -> 253 bytes
        === 2012-11-13 08:14:53,642 [sor2] INFO RequestContext - URL: '/isomorphic/skins/Enterprise/images/Scrollbar/hscroll_start.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11': Safari with Accept-Encoding header
        === 2012-11-13 08:14:53,644 [sor2] INFO Download - done streaming: D:/Smart Client/SmartClient_v82p_2012-11-12_Evaluation/SmartClient_v82p_2012-11-12/smartclientSDK/isomorphic/skins/Enterprise/images/Scrollbar/hscroll_start.png
        === 2012-11-13 08:14:53,687 [sor2] INFO RequestContext - URL: '/isomorphic/skins/Enterprise/images/Scrollbar/hscroll_track.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11': Safari with Accept-Encoding header
        === 2012-11-13 08:14:53,689 [sor3] INFO RequestContext - URL: '/isomorphic/skins/Enterprise/images/Scrollbar/hthumb_stretch.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11': Safari with Accept-Encoding header
        === 2012-11-13 08:14:53,688 [sor8] INFO RequestContext - URL: '/isomorphic/skins/Enterprise/images/Scrollbar/hscroll_end.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11': Safari with Accept-Encoding header
        === 2012-11-13 08:14:53,689 [sor1] INFO RequestContext - URL: '/isomorphic/skins/Enterprise/images/Scrollbar/hthumb_start.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11': Safari with Accept-Encoding header
        === 2012-11-13 08:14:53,691 [sor3] INFO Download - done streaming: D:/Smart Client/SmartClient_v82p_2012-11-12_Evaluation/SmartClient_v82p_2012-11-12/smartclientSDK/isomorphic/skins/Enterprise/images/Scrollbar/hthumb_stretch.png
        === 2012-11-13 08:14:53,690 [sor2] INFO Download - done streaming: D:/Smart Client/SmartClient_v82p_2012-11-12_Evaluation/SmartClient_v82p_2012-11-12/smartclientSDK/isomorphic/skins/Enterprise/images/Scrollbar/hscroll_track.png
        === 2012-11-13 08:14:53,690 [sor7] INFO RequestContext - URL: '/isomorphic/skins/Enterprise/images/Scrollbar/hthumb_end.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11': Safari with Accept-Encoding header
        === 2012-11-13 08:14:53,689 [sor4] INFO RequestContext - URL: '/isomorphic/skins/Enterprise/images/Scrollbar/hthumb_grip.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11': Safari with Accept-Encoding header
        === 2012-11-13 08:14:53,696 [sor7] INFO Download - done streaming: D:/Smart Client/SmartClient_v82p_2012-11-12_Evaluation/SmartClient_v82p_2012-11-12/smartclientSDK/isomorphic/skins/Enterprise/images/Scrollbar/hthumb_end.png
        === 2012-11-13 08:14:53,694 [sor8] INFO Download - done streaming: D:/Smart Client/SmartClient_v82p_2012-11-12_Evaluation/SmartClient_v82p_2012-11-12/smartclientSDK/isomorphic/skins/Enterprise/images/Scrollbar/hscroll_end.png
        === 2012-11-13 08:14:53,693 [sor1] INFO Download - done streaming: D:/Smart Client/SmartClient_v82p_2012-11-12_Evaluation/SmartClient_v82p_2012-11-12/smartclientSDK/isomorphic/skins/Enterprise/images/Scrollbar/hthumb_start.png
        === 2012-11-13 08:14:53,699 [sor4] INFO Download - done streaming: D:/Smart Client/SmartClient_v82p_2012-11-12_Evaluation/SmartClient_v82p_2012-11-12/smartclientSDK/isomorphic/skins/Enterprise/images/Scrollbar/hthumb_grip.png
        === 2012-11-13 08:14:54,010 [sor2] INFO RequestContext - URL: '/isomorphic/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11': Safari with Accept-Encoding header
        === 2012-11-13 08:14:54,021 [sor2] INFO Compression - /isomorphic/IDACall: 81 -> 86 bytes
        === 2012-11-13 08:14:54,090 [sor2] INFO RequestContext - URL: '/isomorphic/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11': Safari with Accept-Encoding header

        Comment


        • #5
          Finally I solved the problem. Thanks

          Comment

          Working...
          X