Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
<persistence xmlns="http://xmlns.jcp.org/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence
http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd"
version="2.1">
<persistence-unit name="persistenceUnitName" transaction-type="RESOURCE_LOCAL">
<properties>
<property name="javax.persistence.jdbc.driver" value="org.postgresql.Driver" /> <!-- DB Driver -->
<property name="javax.persistence.jdbc.url" value="jdbc:postgresql://localhost/dbName" /> <!-- BD Mane -->
<property name="javax.persistence.jdbc.user" value="postgres" /> <!-- DB User -->
<property name="javax.persistence.jdbc.password" value="12345" /> <!-- DB Password -->
<property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/> <!-- DB Dialect -->
<property name="hibernate.hbm2ddl.auto" value="update" /> <!-- create / create-drop / update -->
<property name="hibernate.show_sql" value="true" /> <!-- Show SQL in console -->
<property name="hibernate.format_sql" value="true" /> <!-- Show SQL formatted -->
</properties>
</persistence-unit>
</persistence>
@sebkoller

This comment has been minimized.

Copy link

@sebkoller sebkoller commented Oct 16, 2017

PostgreSQLDialect is deprecated, according to the docs.
You can use PostgreSQL95Dialect instead.

@Pomile

This comment has been minimized.

Copy link

@Pomile Pomile commented Dec 15, 2019

Well done! @SergioDiniz

@OliverZulett

This comment has been minimized.

Copy link

@OliverZulett OliverZulett commented Oct 27, 2020

THANKS

@elhadjindongo

This comment has been minimized.

Copy link

@elhadjindongo elhadjindongo commented Apr 29, 2021

Wonderful bro !
You missed the port number on line 11 :
value="jdbc:postgresql://localhost:5432/dbName" -- This is the correct one with the default postgresql port number

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment