How to use oracle and jpa with a docker container?

Asked May 26 '21 at 16:02

Active May 26 '21 at 16:02

Viewed 20 times

I have a spring application which connects to a local database. The application works perfectly. When I try making a docker container, I get connection refused error and it won't connect to the database anymore. This is the application.properties file:

server.port = 8010
# create and drop tables and sequences, loads import.sql
spring.jpa.hibernate.ddl-auto=

spring.datasource.url= jdbc:oracle:thin:@localhost:1521/xe
spring.datasource.username=STUDENT
spring.datasource.password=STUDENT
spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
#hibernate config
spring.jpa.database-platform=org.hibernate.dialect.Oracle10gDialect

This is how I run the docker container:

 docker run correctanadressserver:0.0.1-SNAPSHOT

The application starts and works, but it can't connect to the database.

asked May 26 '21 at 16:02

Fisher

Is your database in the same container? Or on the host machine? Another container? – Sayan Malakshinov May 26 '21 at 16:10
It is on the host machine @SayanMalakshinov – Fisher May 26 '21 at 16:11
so you need to use hostname of your host machine, if your container is not configured to run with host network: https://docs.docker.com/network/host/ because your container has own ip address – Sayan Malakshinov May 26 '21 at 16:13
just replace your `localhost` with `host.docker.internal` in `jdbc:oracle:thin:@localhost:1521/xe`, so it should be `jdbc:oracle:thin:@host.docker.internal:1521/xe` – Sayan Malakshinov May 26 '21 at 16:18
Ok, that worked, but now it says that timezone region not found and I can't acces any of the services – Fisher May 26 '21 at 17:12
just specify correct timezone in your java call arguments or java properties – Sayan Malakshinov May 26 '21 at 18:42
`java -Duser.timezone="` – Sayan Malakshinov May 26 '21 at 18:42
Thank you! That helped me a lot! – Fisher May 26 '21 at 20:12

How to use oracle and jpa with a docker container?

0 Answers0