java2db

Connect PostgreSQL with Hibernate 4 in Myeclipse,NetBeans,RAD



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

Basic requirements to Connect PostgreSQL with Hibernate :

Connect PostgreSQL with HibernateSoftwares :

…….Java  (Download Java)
…….PostgreSQL (Download PostgreSQL)

Connect PostgreSQL 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

…….postgresql_8_2_504_jdbc3.jar

Connect PostgreSQL with HibernateFiles :
…….EmployeeDetails.java
…….EmpBean.java
…….hibernate.cfg.xml
…….Employee.hbm.xml

 

Directory Structure

MyEclipse IDE:

Connect PostgreSQL with Hibernate

NetBeans IDE:

Connect PostgreSQL with Hibernate

 

 

Connect PostgreSQL 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 PostgreSQL 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 PostgreSQL data base :

 

 

Output : Run the main class as a java application .

connect postgresql with Hibernate

 

Note : If you are running the above application  from the command prompt , copy all 4 files in a folder and add jar files to the class path.




Related Posts :
How to Connect Liferay 7 to PostgreSQL ( Java Liferay portlet and PostgreSQL integration )
Hibernate error user_sequences doesn’t exist in mysql ( resolved )
Connect DB2 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]



^ <