Skip to Main Content

Java User Groups

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting exception while connecting to oracle database using JSP program.

Bitra HemanthOct 29 2018 — edited Dec 14 2018

Hello team,

I have create a jsp program and added in tomcat docker while testing in local desktop i am getting below exception.

java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection.

i am using oracle database 12c docker.

First i have create below stack file.

stack file:

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

    ports:

      - "8888:8080"

    networks:

      - fronter

    depends_on:

      - oracle

    deploy:

      replicas: 1

      restart_policy:

        condition: on-failure

        max_attempts: 3

networks:

  fronter:

after creating above stack file i used below command to deploy docker in local system.

$docker stack deploy jsp_oracle -c pwdcmdstack.yml

and after deploying i have provisioned oracle database docker with below scripts.

docker exec -it --user root jsp_oracle_oracle.1.zqz4r7k4x1cxdagh9fj415u5p /bin/bash -c "apt-get update -y;apt-get install git -y --force-yes"

docker exec -it --user root jsp_oracle_oracle.1.zqz4r7k4x1cxdagh9fj415u5p /bin/bash -c "git clone https://github.com/hemanth22/Oracle_database.git"

docker exec -it --user root jsp_oracle_oracle.1.zqz4r7k4x1cxdagh9fj415u5p /bin/bash -c "chmod -R 777 Oracle_database;cd /Oracle_database;ls -la"

docker exec -it --user oracle jsp_oracle_oracle.1.zqz4r7k4x1cxdagh9fj415u5p /bin/bash -c "netstat -nlpt"

docker exec -it --user oracle jsp_oracle_oracle.1.zqz4r7k4x1cxdagh9fj415u5p /bin/bash -c "ls && cd Oracle_database && ls && bash login.sh"

Can you please check and advice how get ride of the java.sql.SQLRecoverableException

Thanks and regards,

Hemanth.

This post has been answered by Bitra Hemanth on Dec 14 2018
Jump to Answer

Comments

karianna

I'd ask this question over on StackOverflow.

Bitra Hemanth

Ok i will ask same in the stack over flow

Bitra Hemanth
Answer

Hello team,

Issue is resolved for me.

Instead of using localhost, i have used IP Address of docker swarm network it worked fine.

Thanks,

Hemanth.

Marked as Answer by Bitra Hemanth · Sep 27 2020
1 - 3

Post Details

Added on Oct 29 2018
3 comments
2,064 views