CODEWITHSUNDEEP
oracle-databasejdbcdb2ibm-midrange
pratjz
pratjz

Reputation: 3

jdbc driver to connect to db2 7.1 as400

I need to connect to db2 7.1 as400 system using sqldeveloper & oracle data integrator using jdbc driver.

I downloaded db2cc.jar, db2cc_license_cisuz.jar..jt400.jar, db2java.jar.

The connection shows success and it appears to be connected, but while running any query or browsing any table, every time I get below error: 

SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSLH200;00;S0681e7r ,DRIVER=3.59.81

Upvotes: 0

Views: 4087

Answers (2)

jmarkmurphy
jmarkmurphy

Reputation: 11473

Looks like you have several different and competing drivers here:

  • jt400.jar - This is the IBM jdbc driver for DB2 on IBM i. The most recent driver can be found at jt400.sourceforge.net
  • db2jcc.jar, db2jcc_license_cisuz.jar - This is the IBM jdbc driver for DB2 Linux, Unix, and Windows.
  • db2java.jar - This is the Oracle DB2 driver, presumably for Linux, Unix, and Windows as the Oracle site says to use either this driver or db2jcc.jar and db2jcc_license_cisuz.jar, but not both.

I believe your problem is that you are trying to access DB2 on IBM i with the LUW drivers. This won't work. Of the above drivers, only jt400.jar is applicable. Remove the others from your classpath and then try to access the database.

Upvotes: 3

mao
mao

Reputation: 12267

Ask your DB2 support person or DBA to ensure that db2clipkg.bnd is appropriately bound (or rebound) for your environment - using db2jdbcbind. More information at IBM-doclink

Upvotes: 1

Related Questions