Connecting to DB2 using SQL Developer

0
votes

I trying to connect to DB2 database through SQL Developer. I followed following steps create connection: 1. Open SQL Developer 2. Go to Tools > Preferences > Database > Third Party JDBC Drivers. 3. I added third-party JDBC driver path entries (db2jcc.jar and db2jcc_license_cu.jar)

As soon as I try to create connection I get below error enter image description here

1
db2oracle-sqldeveloper
Does SQL Developer even support DB2? Its main site seems to indicate it's for Oracle DBs. SQLCode 204 is an error indicating "<name>" is an undefined name - which probably means SQL Developer is trying to query something in the db that Oracle has but DB2 doesn't. – Tanktalus
Which Db2 version/platform are you connecting to? – mustaccio

1 Answers

0
votes

Oracle SQL-Developer Version 17.2 works fine for me with Db2 Version 11 for Linux x64 and I am using a recent Type-4 jdbc (db2jcc4.jar) driver from IBM.

You question shows that your Db2 jdbc driver version is very old (Version 9.7 fixpack 5) and out of support, so you should upgrade to the latest available Db2 client for your (unspecified) operating-system. Also you should ensure you are using the latest release of the Oracle-SQL-Developer for your operating system.

As your question gives no facts about your versions of Oracle or Db2 products or operating systems, this is the best advice that is possible.