How to use DB2 JDBC driver with Hibernate

Question

I keep getting

java.lang.ClassNotFoundException: Could not load requested class : com.ibm.db2.jcc.DB2Driver

when trying to connect to a DB2 database using Hibernate. The driver jar is referenced as an external library:

Image of Eclipse's "Referenced Library" folder

It also shows up in the classpath:

classpathentry kind="lib" path="C:/Program Files (x86)/IBM/SQLLIB/java/db2jcc.jar"/>

I can also access the class by importing it in the source code. My persistence.xml looks as follows:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.0"
   xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
   <persistence-unit name="name" transaction-type="RESOURCE_LOCAL">
      <description>Persistence Unit</description>
      <provider>org.hibernate.ejb.HibernatePersistence</provider>

      <class>MyClass</class>

      <properties>
         <property name="javax.persistence.jdbc.driver" value="com.ibm.db2.jcc.DB2Driver" />
         <property name="javax.persistence.jdbc.url" value="jdbc:db2://url" />         
         <property name="javax.persistence.jdbc.user" value="user" />
         <property name="javax.persistence.jdbc.password" value="password" />
         <property name="hibernate.dialect" value="org.hibernate.dialect.DB2Dialect" />

         <property name="hibernate.hbm2ddl.auto" value="create" />
         <property name="hibernate.show_sql" value="false" />
         <property name="hibernate.format_sql" value="true" />         
      </properties>
   </persistence-unit>
</persistence>

My suspicion why this does not work is that the class is contained in an external library and not as a maven dependency, because when I replace the DB2 driver by net.ucanaccess.jdbc.UcanaccessDriver (which is contained in a Maven package), the class will be found just fine.

Any idea what I am doing wrong here?

score 0 · Answer 1 · answered Nov 11 '16 at 11:50

0

when you are using com.ibm.db2.jcc.DB2Driver' make sure db2jcc.jar & db2jcc_license_cu.jar are in your classpath.Please add both the jar in your classpath and give a try.

answered Nov 11 '16 at 11:50

Zia

1,001
1
13
25

Unfortunately, this does not help, still the same error. – Tim Nov 11 '16 at 11:56
add the both jar as external jar in your project – Zia Nov 11 '16 at 12:13
verify your persistence.xml files properties. – Zia Nov 11 '16 at 12:43

score 0 · Accepted Answer · answered Nov 23 '16 at 07:42

0

The problem was that I was using the Maven exec plugin to run the main class. W/o using Maven, it works fine...

answered Nov 23 '16 at 07:42

Tim

13
4

How to use DB2 JDBC driver with Hibernate

2 Answers2