Topic
  • 1 reply
  • Latest Post - ‏2012-11-30T11:43:04Z by SystemAdmin
maddurivenkys
maddurivenkys
1 Post

Pinned topic DB2 Connection failed :java.sql.SQLException: [IBM][CLI Driver] SQLSTATE=ä

‏2012-11-30T10:05:27Z |
Hi All,

I'm trying to connect to DB2 getting below exception. Please let me know, your comments.

java.sql.SQLException: IBMCLI Driver SQLSTATE=ä
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3074)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
Thanks,
Venkatesh.
Updated on 2012-11-30T11:43:04Z at 2012-11-30T11:43:04Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 Connection failed :java.sql.SQLException: [IBM][CLI Driver] SQLSTATE=ä

    ‏2012-11-30T11:43:04Z  
    Hello,

    I suggest you use the IBM JDBC driver.
    Download the package "IBM Data Server Driver for JDBC and SQLJ" : starting from this page :
    http://www-01.ibm.com/support/docview.wss?uid=swg27007053
    - Choose the version/Fix Pack level, ideally the level of the DB2 LUW server.
    - Choose the client application platform.
    - Download the package "IBM Data Server Driver for JDBC and SQLJ".

    Then, follow the instructions on this page :
    http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.apdv.java.doc/src/tpc/imjcc_t0010264.html

    Regards.

    Yves-Antoine Emmanuelli