how to connect hibernate and DB2

java hibernate struts db2
Muhammad Imran Tariq picture Muhammad Imran Tariq · Mar 31, 2011 · Viewed 39.1k times · Source

I am running an application that used struts and hibernate. I am currently using Derby database. Now i have to shift on DB2 database.

Please tell me

  • what Configuration I have to do in hibernate configuration file?
  • Do I have to set any classpath variable?
  • I know there are two jars for DB2 (db2jcc.jar & db2jcc_license_cu.jar). Is there any other jar I may need?

Thanks in advance.

Answer

Hardik Mishra picture Hardik Mishra · Mar 31, 2011

It should work with db2jcc.jar

Add below properties to your hibernate.cfg.xml

<property name="hibernate.dialect">org.hibernate.dialect.DB2Dialect</property>

<property name="hibernate.connection.driver_class">com.ibm.db2.jcc.DB2Driver</property>

<property name="connection.url">jdbc:db2://<host>:<port50000>/<dbname></property>

<property name="connection.username">dbusername</property>

<property name="connection.password">dbpassword</property>

Change last 3 properties according to your configuration

Related questions

Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException:

I am creating web application using Spring, Hibernate, Struts, and Maven. I get the below error when I run mvn clean install command: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.project.action.PasswordHintActionTest': Injection of autowired …

Read More
How to prevent JPA from rolling back transaction?

Methods invoked: 1. Struts Action 2. Service class method (annotated by @Transactional) 3. Xfire webservice call Everything including struts (DelegatingActionProxy) and transactions is configured with Spring. Persistence is done with JPA/Hibernate. Sometimes the webservice will throw an unchecked exception. I catch this …

Read More
Getting a 'No thread-bound request found' error from spring in my web app

I'm getting a 'No thread-bound request found' error in my web app and hoping to get some help. I'm trying to use struts2 + spring + hibernate, and use spring to manage the hibernate session factory, and inject hibernate sessions into my …

Read More