Tuesday, 24 April 2012

IBM DB2 UDB JDBC Drivers - What are you using ?

Having an interesting conversation on Skype re a JDBC driver issue from IBM Tivoli Directory Integrator to IBM DB2 UDB

Cannot load JDBC driver class 'com.ibm.db2.jcc.DB2Driver'
java.lang.UnsupportedClassVersionError: (com/ibm/db2/jcc/DB2Driver) bad major version at offset=6

and the question of the JDBC driver version came up.

Did you know ( and I didn''t ) that you can deduce the JDBC driver version by the size of the JAR file e.g. db2jcc.jar etc. from this table: -

So I have DB2 UDB and my dbcjcc.jar is 3,348,681 bytes in size.

That means that it is: -

My correspondent was using DB2 UDB and his JDBC driver was 3,295,950 bytes in size.

Again, this tied up: -

So, a potentially useful way of validating that you have the correct JDBC driver.

Oh, the root cause of the ITDI exception java.lang.UnsupportedClassVersionError  ? Don't yet know, but will report back :-)

No comments:

macOS to macOS File Sharing - Don't work, try The IT Crowd

 I use File Sharing between two Macs on the same network, both running the latest macOS 13.4 Ventura. For some strange reason I wasn't a...