java2db

Connect DB2 with Hibernate 4 in MyEclipse,NetBeans,RAD



Hibernate is a ORM (Object/Relational Mapping) framework.To connect DB2 with Hibernate , It requires additional jar files. Hibernate is not an installable software .

Basic requirements to Connect DB2 with Hibernate :

Connect DB2 with HibernateSoftwares :

…….Java  (Download Java)

…….DB2 (Download DB2)

 

Connect DB2 with HibernateJar files: (Download Hibernate 4 jars)

…….antlr-2.7.7.jar

…….dom4j-1.6.1.jar

…….hibernate-commons-annotations-4.0.5.Final.jar

…….hibernate-core-4.3.6.Final.jar

…….hibernate-jpa-2.1-api-1.0.0.Final.jar

…….jandex-1.1.0.Final.jar

…….javassist-3.18.1-GA.jar

…….jboss-logging-3.1.3.GA.jar

…….jboss-logging-annotations-1.2.0.Beta1.jar

…….jboss-transaction-api_1.2_spec-1.0.0.Final.jar

…….db2jcc.jar

…….db2jcc_license_cisuz.jar

…….db2jcc_license_cu.jar

Connect DB2 with HibernateFiles :

…….EmployeeDetails.java

…….EmpBean.java

…….hibernate.cfg.xml

…….Employee.hbm.xml

 

Directory Structure :

MyEclipse IDE

Connect DB2 with Hibernate

NetBeans IDE

Connect DB2 with Hibernate

 

 

Connect DB2 with Hibernate Create new java project .

 Add all the jar files to the libraries .

 Create Employee table in the database and insert few records.

 Copy the four (two java,two xml) files .

 Finally , run the EmployeeDetails.java  file .

 

 

Note : Here we created EmpBean.java , EmployeeDetails.java and Employee.hbm.xml files in the <default package>.You can also create these files in a separate package (Ex : EmpApp) and do the following changes :

Connect oracle with hibernate Change 1 . In hibernate.cfg.xml : <mapping resource=”Employee.hbm.xml“/> to <mapping ….resource=”EmpApp/Employee.hbm.xml“/> .

Connect oracle with hibernate Change 2 . In Employee.hbm.xml : <class name=”EmpBean” table=”Employee”> to <class ….name=”EmpApp.EmpBean” table=”Employee”>

Connect oracle with hibernate Change 3 . Add the package name (package EmpApp; ) as a first line in the .java files.

 

Example code to  Connect DB2 with Hibernate :

EmployeeDetails.java (main class):

EmpBean.java (Bean class) :

hibernate.cfg.xml  (Hibernate configuration file) :

Employee.hbm.xml (Mapping file) :

Create Employee table in DB2 data base :

 

 

Output : Run the main class as a java application .

 

connect postgresql with Hibernate

 

Note : If you try to run the above application in  command prompt ,  add jar files to the class path.




Related Posts :
Hibernate error user_sequences doesn’t exist in mysql ( resolved )
Jsp , Servlet and JDBC login application example in NetBeans
Connect PostgreSQL with Hibernate 4 in Myeclipse,NetBeans,RAD
Connect MySQL with Hibernate 4 in NetBeans,MyEclipse,RAD
Connect oracle with hibernate in MyEclipse, NetBeans, RAD
Jdbc with Mysql in NetBeans and MyEclipse
Jdbc with PostgreSQL using MyEclipse and NetBeans
Jdbc with DB2 in NetBeans and MyEclipse
   [will not be published]



^ <