[简]SpringDataJPA+PostgreSQL的配置

The following properties are applied to the Spring Data JPA configuration of using Postgres as its DBSM.
Two configuration files will be modified to achieve the goal.

1. pom.xml
   We need to add the PostgreSQL's dependency to your dependency list.

<dependencies>
    ...
    <dependency>
        <groupId>org.postgresql</groupId>
        <artifactId>postgresql</artifactId>
        <scope>runtime</scope>
    </dependency>
    ...
</dependencies>

2. application.properties
   This file is usually located in the main/resources/ folder.
   
   Figure 1. Location of the application.properties file

# Postgres
spring.datasource.driverClassName=org.postgresql.Driver
spring.datasource.url=jdbc:postgresql://localhost:5432/test
spring.datasource.username=postgres
spring.datasource.password=postgres
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
spring.jpa.hibernate.ddl-auto=none
spring.jpa.show-sql: true

# Connection pool
spring.datasource.hikari.connectionTimeout=20000
spring.datasource.hikari.maximumPoolSize=5