Connecting PostgreSQL 9 2 1 with Hibernate

Question

I have a blank Spring MVC project  and I ve installed Hibernate and the PostgreSQL drivers using Maven   I m running short on complete tutorials that show how to connect PostgreSQL with Hibernate   Any help here

User · Accepted Answer

This is a hibernate cfg xml for posgresql and it will help you with basic hibernate configurations for posgresql    lt  DOCTYPE hibernate-configuration PUBLIC          -  Hibernate Hibernate Configuration DTD 3 0  EN           http   www hibernate org dtd hibernate-configuration-3 0 dtd  gt    lt hibernate-configuration gt       lt session-factory gt           lt property name  hibernate dialect  gt org hibernate dialect PostgreSQLDialect lt  property gt           lt property name  hibernate connection driver class  gt org postgresql Driver lt  property gt           lt property name  hibernate connection username  gt postgres lt  property gt           lt property name  hibernate connection password  gt password lt  property gt           lt property name  hibernate connection url  gt jdbc postgresql   localhost 5432 hibernatedb lt  property gt              lt property name  connection pool size  gt 1 lt  property gt            lt property name  hbm2ddl auto  gt create lt  property gt            lt property name  show sql  gt true lt  property gt             lt mapping class  org javabrains sanjaya dto UserDetails   gt        lt  session-factory gt   lt  hibernate-configuration gt

User · Answer

This is the hibernate cfg xml file to connect postgresql 9 5 and this is help to you basic configuration     lt  xml version  1 0  encoding  utf-8   gt    lt  --     Hibernate  Relational Persistence for Idiomatic Java         License  GNU Lesser General Public License  LGPL   version 2 1 or later      See the lgpl txt file in the root directory or  lt http   www gnu org licenses lgpl-2 1 html gt     -- gt   lt  DOCTYPE hibernate-configuration SYSTEM          http   www hibernate org dtd hibernate-configuration-3 0 dtd  gt   lt hibernate-configuration  gt       lt session-factory gt           lt  -- Database connection settings -- gt           lt property name  connection driver class  gt org postgresql Driver lt  property gt           lt property name  connection url  gt jdbc postgresql   localhost 5433 hibernatedb lt  property gt           lt property name  connection username  gt postgres lt  property gt           lt property name  connection password  gt password lt  property gt            lt  -- JDBC connection pool  use the built-in  -- gt           lt property name  connection pool size  gt 1 lt  property gt            lt  -- SQL dialect -- gt           lt property name  hibernate dialect  gt org hibernate dialect PostgreSQLDialect lt  property gt            lt  -- Enable Hibernate s automatic session context management -- gt           lt property name  current session context class  gt thread lt  property gt            lt  -- Disable the second-level cache  -- gt           lt property name  cache provider class  gt org hibernate cache internal NoCacheProvider lt  property gt            lt  -- Echo all executed SQL to stdout -- gt           lt property name  show sql  gt true lt  property gt            lt  -- Drop and re-create the database schema on startup -- gt           lt property name  hbm2ddl auto  gt create lt  property gt           lt mapping class  com waseem UserDetails   gt       lt  session-factory gt   lt  hibernate-configuration gt      Make sure File Location should be under src main resources hibernate cfg xml

User · Answer

If the project is maven placed it in src main resources  in the package phase it will copy it in    WEB-INF classes hibernate cfg xml

User · Answer

Yes by using spring-boot with hibernate configuration files we can persist the data to the database  keep hibernating  cfg xml in your src main resources folder for reading the configurations related to database

[java] Connecting PostgreSQL 9.2.1 with Hibernate

Examples related to java

Examples related to hibernate

Examples related to postgresql

Examples related to postgresql-9.2