我有一個從創造了兩個集裝箱碼頭工人，撰寫，一個有API與springboot和其他的Oracle資料庫，但它does'n的連接API到資料庫和我已經跑出來的選擇，我試圖在配置連接aplication.properties，也docker-compose.yml
這是 docker-compose.yml
version: "3.7"
services:
app:
image: "bm_spring_boot:latest"
build:
context: ./BmApiRestV2/
dockerfile: Dockerfile
container_name: api_spring
depends_on:
- db
ports:
- 8888:8080
environment:
- SPRING_DATASOURCE_URL=jdbc:oracle:thin:@//db:49161/xe
- SPRING_DATASOURCE_USERNAME=system
- SPRING_DATASOURCE_PASSWORD=oracle
networks:
spring-net:
aliases:
- spring-host
db:
image: oracleinanutshell/oracle-xe-11g:latest
container_name: oracle_db
ports:
- 49161:1521
- 5500:5500
environment:
- ORACLE_ALLOW_REMOTE=true
networks:
spring-net:
aliases:
- db-host
networks:
spring-net:
driver: bridge
ipam:
driver: default
Dockerfile
ARG VERSION=8-jdk-slim
FROM openjdk:${VERSION}
ARG JAR_FILE=BmApiRestV2
COPY "./target/${JAR_FILE}.jar" "app.jar"
EXPOSE 8080
ENTRYPOINT [ "java","-jar","app.jar"]
aplication.properties
#spring.datasource.username=system
#spring.datasource.password=oracle
spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
#DOCKER
#spring.datasource.url=jdbc:oracle:thin:@ (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = db)(PORT = 49161)) ) (CONNECT_DATA = (SID = xe) ) )
（連接被注釋，因為在docker-compose它的配置中）
我感謝幫助（我為我的英語道歉）
- - - - - - - 更新 - - - - - - -
連接測驗
ping db
PING db (172.20.0.2) 56(84) bytes of data.
64 bytes from oracle_db.imagenspring_spring-net (172.20.0.2): icmp_seq=1 ttl=64 time=0.221 ms
64 bytes from oracle_db.imagenspring_spring-net (172.20.0.2): icmp_seq=2 ttl=64 time=0.072 ms
64 bytes from oracle_db.imagenspring_spring-net (172.20.0.2): icmp_seq=3 ttl=64 time=0.072 ms
64 bytes from oracle_db.imagenspring_spring-net (172.20.0.2): icmp_seq=4 ttl=64 time=0.072 ms
64 bytes from oracle_db.imagenspring_spring-net (172.20.0.2): icmp_seq=5 ttl=64 time=0.144 ms
64 bytes from oracle_db.imagenspring_spring-net (172.20.0.2): icmp_seq=6 ttl=64 time=0.071 ms
64 bytes from oracle_db.imagenspring_spring-net (172.20.0.2): icmp_seq=7 ttl=64 time=0.161 ms
64 bytes from oracle_db.imagenspring_spring-net (172.20.0.2): icmp_seq=8 ttl=64 time=0.063 ms
^C
--- db ping statistics ---
8 packets transmitted, 8 received, 0% packet loss, time 7090ms
rtt min/avg/max/mdev = 0.063/0.109/0.221/0.054 ms
root@2254b03a8ef4:/#
uj5u.com熱心網友回復：
TLDR
將連接字串中的埠更改為 1521。
擴大的視野
您的服務和網路配置正確。兩個容器都在同一個 docker 網路中，這允許它們相互通信。
此外，與一些評論相反，呼叫容器的所有 3 種方式都是正確的：
- D b
- 資料庫主機
- oracle_db。
這可以使用簡化的 輕松驗證docker-compose.yml，只是為了測驗連接性：
version: "3.7"
services:
app:
image: busybox
command: "sh -c 'sleep 3600;'"
networks:
spring-net:
aliases:
- app-host
db:
image: busybox
command: "sh -c 'sleep 3600;'"
container_name: oracle_db
networks:
spring-net:
aliases:
- db-host
networks:
spring-net:
driver: bridge
ipam:
driver: default
如果您嘗試決議名稱 - 它們都指向同一個容器：
/ # ping db
PING db (172.21.0.2): 56 data bytes
64 bytes from 172.21.0.2: seq=0 ttl=64 time=0.593 ms
^C
--- db ping statistics ---
1 packets transmitted, 1 packets received, 0% packet loss
round-trip min/avg/max = 0.593/0.593/0.593 ms
/ # ping oracle_db
PING oracle_db (172.21.0.2): 56 data bytes
64 bytes from 172.21.0.2: seq=0 ttl=64 time=0.213 ms
^C
--- oracle_db ping statistics ---
1 packets transmitted, 1 packets received, 0% packet loss
round-trip min/avg/max = 0.213/0.213/0.213 ms
/ # ping db-host
PING db-host (172.21.0.2): 56 data bytes
64 bytes from 172.21.0.2: seq=0 ttl=64 time=0.334 ms
^C
--- db-host ping statistics ---
1 packets transmitted, 1 packets received, 0% packet loss
round-trip min/avg/max = 0.334/0.334/0.334 ms
實際上，問題似乎出在您的連接字串上：
- SPRING_DATASOURCE_URL=jdbc:oracle:thin:@//db:49161/xe
port49161是主機埠，而您連接到容器 ( db)。在這種情況下，您應該使用1521容器內的服務器系結到的埠。
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/388838.html
標籤：爪哇 甲骨文 码头工人 docker-compose
下一篇：在OracleSQL中使用日期