Integrate Spanner with Hibernate ORM (PostgreSQL dialect)

Hibernate is an object-relational mapping tool for the Java programming language. It provides a framework for mapping an object-oriented domain model to a relational database.

You can integrate PostgreSQL-dialect databases with Hibernate using the open source PostgreSQL JDBC Driver. Hibernate ORM 6.3 is supported with PostgreSQL-dialect databases.

Set up PGAdapter

Ensure that PGAdapter is running on the same machine as the application that is using Hibernate.

For more information, see Start PGAdapter .

Set up Hibernate with PostgreSQL

In your project, add Apache Maven dependencies for the Hibernate ORM core and PostgreSQL JDBC Driver.

 <!-- Hibernate core dependency -->
<dependency>
  <groupId>org.hibernate.orm</groupId>
  <artifactId>hibernate-core</artifactId>
  <version>6.3.1.Final</version>
</dependency>

<!-- Postgresql JDBC driver dependency -->
<dependency>
  <groupId>org.postgresql</groupId>
  <artifactId>postgresql</artifactId>
  <version>42.7.1</version>
</dependency> 

Set up Hibernate properties

Configure hibernate.properties to use the PostgreSQL dialect and PostgreSQL JDBC Driver.

 hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
hibernate.connection.driver_class=org.postgresql.Driver

hibernate.connection.url=jdbc:postgresql://localhost:5432/test-database
hibernate.connection.username=pratick

hibernate.connection.pool_size=5

hibernate.show_sql=true
hibernate.format_sql=true

# hibernate.hbm2ddl.auto validate
hibernate.hbm2ddl.auto=update 

Use Hibernate

For more information about the features and recommendations for integrating Hibernate with PostgreSQL-dialect databases, please consult the reference documentation on GitHub.

What's next

• Checkout code examples using Hibernate with PostgreSQL.
• Learn more about PGAdapter .
• Learn more about Hibernate ORM .
• For more information about PostgreSQL JDBC driver connection options, see PGAdapter - JDBC Connection Options in the PGAdapter GitHub repository.
• Learn more about Integrate Spanner with Hibernate ORM (GoogleSQL dialect) .