Hi,

I am always getting the class not found exception while calling the program from commandline though the classpath has been set explicitly for the library db2java.zip .

Properties File

## DB2

hibernate.connection.driver_class COM.ibm.db2.jdbc.app.DB2Driver
hibernate.connection.url jdbc:db2:DB2TEST
hibernate.connection.username *****
hibernate.connection.password *****
hibernate.dialect org.hibernate.dialect.DB2Dialect


Error Message

org.hibernate.HibernateException: JDBC Driver class not found: COM.ibm.db2.jdbc.
app.DB2Driver
at org.hibernate.connection.DriverManagerConnectionProvider.configure(Dr
iverManagerConnectionProvider.java:66)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvi
der(ConnectionProviderFactory.java:124)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvi
der(ConnectionProviderFactory.java:56)
at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFa
ctory.java:414)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:
62)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073
)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.jav
a:1298)
at com.test.ClientMain.main(ClientMain.java:37)
Caused by: java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.app.DB2Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:100)

at org.hibernate.connection.DriverManagerConnectionProvider.configure(Dr
iverManagerConnectionProvider.java:61)
... 7 more

Thanks for the help...

The db2java.zip file may need to be on the classpath of the classloader for the Hibernate libraries, not just the classpath for the war file classloader.

Try packacing the db2java.zip file with the Java Project used by Hibernate. Just try it and see if it goes away. If it does, you may need to configure the classloader.