How to connect jsp program to sath89/oracle-12c docker

MaksymBilenko / docker-oracle-12c

:whale: Docker image with Oracle Database 12c on board

Apache License 2.0

679 stars 285 forks source link

How to connect jsp program to sath89/oracle-12c docker #122

Closed hemanth22 closed 5 years ago

hemanth22 commented 5 years ago

Hello Maksym Bilenko,

I need your help test a jsp program with your oracle 12c docker.

I am using below docker stack file to deploy tomcat with jsp program and oracle 12c

`version: "3.7"

services: oracle: image: sath89/oracle-12c:latest ports:

"8080:8080"
"1521:1521" stop_grace_period: 1m0s deploy: replicas: 1 restart_policy: condition: on-failure max_attempts: 3 networks:
fronter jsp: image: bitroid/jsp-db-docker:latest ports:
"8888:8080" networks:
fronter depends_on:
oracle deploy: replicas: 1 restart_policy: condition: on-failure max_attempts: 3

networks: fronter:`

When i am trying to connect getting java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection.

Please find the detailed information below link:

https://community.oracle.com/message/14978050#14978050

hemanth22 commented 5 years ago

tomcat with jsp program dockerfile link :https://github.com/hemanth22/JSP-DB-Docker/tree/master/JSP

MaksymBilenko commented 5 years ago

@hemanth22 it takes a few minutes to start database, check out oracle containers log file to ensure that database started

hemanth22 commented 5 years ago

@MaksymBilenko I am testing jsp after 10 minutes, when database started. before that i am using below configuration for provisioning docker.

docker exec -it --user root bf18b7294d5b /bin/bash -c "apt-get update -y;apt-get install git -y --force-yes" docker exec -it --user root bf18b7294d5b /bin/bash -c "git clone https://github.com/hemanth22/Oracle_database.git" docker exec -it --user root bf18b7294d5b /bin/bash -c "chmod -R 777 Oracle_database;cd /Oracle_database;ls -la" docker exec -it --user oracle bf18b7294d5b /bin/bash -c "netstat -nlpt" docker exec -it --user oracle bf18b7294d5b /bin/bash -c "ls && cd Oracle_database && ls && bash login.sh"

hemanth22 commented 5 years ago

@MaksymBilenko Can you please help me on this issue.

Will it help, if we try to add environment variable.

hemanth22 commented 5 years ago

@MaksymBilenko

Issue solved. Instead of using localhost i have my system ip address in JSP it worked for me.