Any clues on this database connection error?


Am using Hibernate 2.1. I've received the following error when trying to initialize a session against DB2.

java.lang.AbstractMethodError: COM.ibm.db2.jdbc.app.DB2DatabaseMetaData.supportsResultSetType(I)Z
at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:87)
at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1172)
at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:803)

This is using the DB2 driver found in DB2java.zip ( Db2 7 and 8 ).

When I use the connection setup via JDBC ODBC the session initializes just fine. But when I switch to the JDBC driver for DB2 the exception is thrown. Oddly enough middlegen & hbm2java are able to use the same connection just fine.

Below is an exerpt from my hibernate.cfg.xml .....



<!-- JDBC ODBC -->
<property name="hibernate.connection.url">jdbc:odbc:vfdev8</property>
<property name="hibernate.connection.driver_class">sun.jdbc.odbc.JdbcOdbcDriver</property>
<!-- local connection properties
<property name="hibernate.connection.url">jdbc:db2:VFDWDEVL</property>
<property name="hibernate.connection.driver_class">COM.ibm.db2.jdbc.app.DB2Driver</property>
-->
<!-- dialect for DB2 -->
<property name="dialect">
net.sf.hibernate.dialect.DB2Dialect
</property>
<property name="hibernate.show_sql">FALSE</property>
<property name="hibernate.transaction.factory_class">
net.sf.hibernate.transaction.JDBCTransactionFactory
</property>

This error is on a PC running Windows 2000. And as my client really likes backlevel software the DB2 drivers are those that ship with DB2 version 7.