I am running an application that used struts and hibernate. I am currently using Derby database. Now i have to shift on DB2 database.
I an giving the below mentioned settings in hibernate configuration file.

<property name="dialect">org.hibernate.dialect.DB2Dialect</property>
<property name="connection.driver_class">com.ibm.db2.jdbc.app.DB2Driver</property>
<property name="connection.url">jdbc:db2://1988.144.141.34:500/db</property>
<property name="connection.username">Db2admin</property>
<property name="connection.password">******</property>

I also included 2 jars for DB2 (db2jcc.jar & db2jcc_license_cu.jar).

But I got exception.

Caused by:
java.lang.Throwable: org.hibernate.HibernateException: JDBC Driver class not found: com.ibm.db2.jdbc.app.DB2Driver
at org.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.java:66)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:414)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:62)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
... 179 more
Caused by:
java.lang.Throwable: java.lang.ClassNotFoundException: com.ibm.db2.jdbc.app.DB2Driver
at java.lang.Class.forNameImpl(Native Method)
at java.lang.Class.forName(Class.java:131)
at org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:100)
at org.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.java:61)
... 185 more

What should be the reason.

Thanks
Imran Tariq

Hi,

It's because the configured JDBC driver is not found in your application class path (java.lang.ClassNotFoundException). Maybe you have made a mistake in the driver name. I've seen that the driver name could be COM.ibm.db2.jdbc.app.DB2Driver (http://publib.boulder.ibm.com/infocente ... rivers.htm).

Hope this help

--Kevin

PS: for questions related to Hibernate, you should use this forum section viewforum.php?f=1

Thanks this problem is over but there's another.

I am getting this error



Error code 42704 means that OpenIncident table does not exist. But it exists in the database.

Any idea what could be the problem? Problem with schema or anything else?

Its solved.

Problem was with database schema.

i was using

schema.tableName

when I use

schema1.tableName

it works. Because in DB schema was schema1.