DhanaTontanahal / JobPortal-Web-App-on-AWS

JobPortal-Web-App-on-AWS Tech used : java, Spring (DI, Security ,MVC ) Angular JS , Hibernate, Oracle DB
1 stars 0 forks source link

Unable to communicate to Oracle Database from Java web app deployed on tomcat in Ec2 on AWS #2

Closed DhanaTontanahal closed 4 years ago

DhanaTontanahal commented 4 years ago

Unable to communicate to Oracle Database from Java web app deployed on tomcat in Ec2 on AWS

Cause # 1: The DB configuration was set to Public Accessiblity --> "No"

Solution : changed above by modifying the Database to Public Accessibilty --> "Yes"

Cause # 2:

There was no ojdbc bridge jar, in local environment , the same ojdbc14.jar was put in the tomcat/lib folder.

Solution: Copied the jar from my local to tmp directory on teh Ec2 Aws instance. Then using mv command moved the jar from tmp to tomcat/libs folder Need to sudo su for this.

DhanaTontanahal commented 4 years ago

The above issue fixed.