Why can the spring app not connect to the Postgres db?

Question

I want to build my spring boot app with a Postgres db in a docker container with docker compose. I got an error when I build the docker compose container. The spring app cannot connect to the Postgres db. The Postgres container run as it should and I can create a connection with a usually db-client (dbeaver).

Here are my configuration files:

1. application.yml

server:
  port: 8081
  error:
    include-message: always
    include-binding-errors: always
spring:
  datasource:
    password: password
    url: jdbc:postgresql://postgres:5432/trainingdb
    username: user
  jpa:
    hibernate:
      ddl-auto: create
    properties:
      hibernate:
        dialect: org.hibernate.dialect.PostgreSQLDialect
        format_sql: true
    show-sql: true

2. Dockerfile

FROM openjdk:11
ADD target/training-service-1.0.0.jar app.jar
ENTRYPOINT ["java", "-jar", "app.jar"]

3. docker-compose.yml

version: '1'
services:
  app:
    container_name: springboot
    image: springboot
    build: ./
    depends_on:
      - postgres
    ports:
      - "8081:8081"
  postgres:
    image: postgres:latest
    ports:
      - "5432:5432"
    environment:
      - POSTGRES_USER=user
      - POSTGRES_PASSWORD=password
      - POSTGRES_DB=trainingdb

first I run ./mvnw clean package -DskipTests

to build the jar file and then I run the docker compose up

little snippet to the log messages:

springboot                   |  at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:51) ~[postgresql-42.2.24.jar!/:42.2.24]
springboot                   |  at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:225) ~[postgresql-42.2.24.jar!/:42.2.24]
springboot                   |  at org.postgresql.Driver.makeConnection(Driver.java:465) ~[postgresql-42.2.24.jar!/:42.2.24]
springboot                   |  at org.postgresql.Driver.connect(Driver.java:264) ~[postgresql-42.2.24.jar!/:42.2.24]
springboot                   |  at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-4.0.3.jar!/:na]
springboot                   |  at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364) ~[HikariCP-4.0.3.jar!/:na]
springboot                   |  at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[HikariCP-4.0.3.jar!/:na]
springboot                   |  at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476) ~[HikariCP-4.0.3.jar!/:na]
springboot                   |  at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) ~[HikariCP-4.0.3.jar!/:na]
springboot                   |  at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) ~[HikariCP-4.0.3.jar!/:na]
springboot                   |  at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[HikariCP-4.0.3.jar!/:na]
springboot                   |  at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) ~[hibernate-core-5.4.32.Final.jar!/:5.4.32.Final]
springboot                   |  at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcEnvironmentInitiator.java:180) ~[hibernate-core-5.4.32.Final.jar!/:5.4.32.Final]
springboot                   |  at org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl.getIsolatedConnection(DdlTransactionIsolatorNonJtaImpl.java:43) ~[hibernate-core-5.4.32.Final.jar!/:5.4.32.Final]
springboot                   |  ... 44 common frames omitted
springboot                   | Caused by: java.net.UnknownHostException: postgresql
springboot                   |  at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:220) ~[na:na]
springboot                   |  at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[na:na]
springboot                   |  at java.base/java.net.Socket.connect(Socket.java:609) ~[na:na]
springboot                   |  at org.postgresql.core.PGStream.createSocket(PGStream.java:231) ~[postgresql-42.2.24.jar!/:42.2.24]
springboot                   |  at org.postgresql.core.PGStream.<init>(PGStream.java:95) ~[postgresql-42.2.24.jar!/:42.2.24]
springboot                   |  at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:98) ~[postgresql-42.2.24.jar!/:42.2.24]
springboot                   |  at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:213) ~[postgresql-42.2.24.jar!/:42.2.24]
springboot                   |  ... 58 common frames omitted
springboot                   | 
springboot exited with code 1

The log messages from my postgres container:


PostgreSQL Database directory appears to contain a database; Skipping initialization


2022-01-30 07:39:04.321 UTC [1] LOG:  starting PostgreSQL 14.1 (Debian 14.1-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit

2022-01-30 07:39:04.321 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432

2022-01-30 07:39:04.321 UTC [1] LOG:  listening on IPv6 address "::", port 5432

2022-01-30 07:39:04.327 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"

2022-01-30 07:39:04.338 UTC [27] LOG:  database system was shut down at 2022-01-30 07:38:38 UTC

2022-01-30 07:39:04.349 UTC [1] LOG:  database system is ready to accept connections

2022-01-30 07:42:16.689 UTC [45] LOG:  invalid length of startup packet

2022-01-30 07:42:16.709 UTC [46] LOG:  invalid length of startup packet

2022-01-30 07:42:16.726 UTC [47] LOG:  invalid length of startup packet

2022-01-30 07:42:39.376 UTC [1] LOG:  received fast shutdown request

2022-01-30 07:42:39.379 UTC [1] LOG:  aborting any active transactions

2022-01-30 07:42:39.381 UTC [1] LOG:  background worker "logical replication launcher" (PID 33) exited with exit code 1

2022-01-30 07:42:39.386 UTC [28] LOG:  shutting down

2022-01-30 07:42:39.430 UTC [1] LOG:  database system is shut down

2022-01-30 07:45:33.835 UTC [1] LOG:  starting PostgreSQL 14.1 (Debian 14.1-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit

2022-01-30 07:45:33.835 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432

2022-01-30 07:45:33.836 UTC [1] LOG:  listening on IPv6 address "::", port 5432

2022-01-30 07:45:33.841 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"

2022-01-30 07:45:33.852 UTC [26] LOG:  database system was shut down at 2022-01-30 07:42:39 UTC

2022-01-30 07:45:33.861 UTC [1] LOG:  database system is ready to accept connections

2022-01-30 07:48:44.550 UTC [1] LOG:  received fast shutdown request

2022-01-30 07:48:44.559 UTC [1] LOG:  aborting any active transactions

2022-01-30 07:48:44.564 UTC [1] LOG:  background worker "logical replication launcher" (PID 32) exited with exit code 1

2022-01-30 07:48:44.572 UTC [27] LOG:  shutting down

2022-01-30 07:48:44.630 UTC [1] LOG:  database system is shut down

2022-01-30 07:49:05.986 UTC [1] LOG:  starting PostgreSQL 14.1 (Debian 14.1-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit

2022-01-30 07:49:05.986 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432

2022-01-30 07:49:05.988 UTC [1] LOG:  listening on IPv6 address "::", port 5432

2022-01-30 07:49:05.995 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"

2022-01-30 07:49:06.004 UTC [26] LOG:  database system was shut down at 2022-01-30 07:48:44 UTC

2022-01-30 07:49:06.035 UTC [1] LOG:  database system is ready to accept connections


PostgreSQL Database directory appears to contain a database; Skipping initialization



PostgreSQL Database directory appears to contain a database; Skipping initialization

``

 command to start up the containers. Is there any error in my spring boot configuration ?

There are no errors in my opinion. Can you share your stacktrace? — Georgii Lvov
– Georgii Lvov, Commented Jan 29, 2022 at 21:02

Medamine · Accepted Answer · 2022-01-29 21:51:30Z

1

I think the problem is your jdbc URL: jdbc:postgresql://postgres:5432/trainingdb

can you try this URL instead: jdbc:postgresql://localhost:5432/trainingdb

answered Jan 29, 2022 at 21:51

Medamine

1497 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tech_Dog Over a year ago

I tried it without success

Viraj · Accepted Answer · 2022-01-30 00:34:15Z

0

Can you check on the log, whether postgre container is up and running?

Also please check the container status by using the command 'docker ps' and check for the container name 'postgres'.

answered Jan 30, 2022 at 0:34

Viraj

1971 gold badge4 silver badges16 bronze badges

1 Comment

Tech_Dog Over a year ago

I set the container_name in the docker compose file to postgres. After that change, the docker ps command show me the Postgres db container with the name of 'postgers'. But this doesn't solve my problem.

Collectives™ on Stack Overflow

Why can the spring app not connect to the Postgres db?

2 Answers 2

1 Comment

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Related