Connecting PostgreSQL 9.2.1 with Hibernate

Question

I am having a new Spring MVC project, and I have installed the Hibernate and the PostgreSQL drivers using Maven.

So how can I able to connect PostgreSQL with the Hibernate.

Any help here, please?

Answer 1

This is a hibernate.cfg.xml for PostgreSQL and this will help you with the basic hibernate configurations for PostgreSQL.

<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
    <session-factory>
        <property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property>
        <property name="hibernate.connection.driver_class">org.postgresql.Driver</property>
        <property name="hibernate.connection.username">postgres</property>
        <property name="hibernate.connection.password">password</property>
        <property name="hibernate.connection.url">jdbc:postgresql://localhost:5432/hibernatedb</property>



        <property name="connection_pool_size">1</property>

        <property name="hbm2ddl.auto">create</property>

        <property name="show_sql">true</property>



       <mapping class="org.javabrains.sanjaya.dto.UserDetails"/>

    </session-factory>
</hibernate-configuration>

Are you pretty much interested to Learn SQL in detail? Join the SQL Course to gain more knowledge.