Java Web Application can't connect database on remote Tomcat 8 Server

Question

I have a Spring web application and I deployed this application in a remote Tomcat 8 server (AWS). I also deployed a database as an SQL file in the same server. When I tried to open my application in a web browser, the webpages were opened successfully but the web services doesn't work. I think it was because the web services uses the database.

This is my database.properties:

 jdbc.url=jdbc:mysql://localhost:3306/srfms
 jdbc.username=*****
 jdbc.password=*****

I also tried another configuration:

 jdbc.url=jdbc:mysql://94.73.145.205:3306/srfms
 jdbc.username=*****
 jdbc.password=*****

I can connect this database wtth MySQL Workbench successfully.

can you provide the error?

daN
– daN

2018-06-29 15:01:00 +00:00
Commented Jun 29, 2018 at 15:01 — daN
– daN, Commented Jun 29, 2018 at 15:01

Vitaliy Kushneruk · Accepted Answer · 2018-06-29 15:07:02Z

1

Check if the driver for mysql is installed before you proceed, do not forget to copy the JDBC Driver's jar into $CATALINA_HOME/lib.

answered Jun 29, 2018 at 15:07

Vitaliy Kushneruk

487 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mohsin Khan · Accepted Answer · 2018-06-29 14:56:52Z

0

Have you checked your VPC your database and application should be in same VPC. Also please check the IMRole and security group for DB.

answered Jun 29, 2018 at 14:56

Mohsin Khan

992 silver badges12 bronze badges

Collectives™ on Stack Overflow

Java Web Application can't connect database on remote Tomcat 8 Server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related