wood burning stoves 2.0*
The moose likes JForum and the fly likes Getting errors with my dataSource connection on the remote server but not on the local server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Products » JForum
Bookmark "Getting errors with my dataSource connection on the remote server but not on the local server" Watch "Getting errors with my dataSource connection on the remote server but not on the local server" New topic
Author

Getting errors with my dataSource connection on the remote server but not on the local server

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
<resource-ref>
<description>jdbc:mysql://localhost:3306/myData</description>
<res-ref-name>jdbc/myData</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>

Yet when I launch the website from the remote tomcat 5.25 server it gives me the above errors. I even have the mysql driver installed in the WEB-INF/ lib folder, still I get the same problems.

Can someone help me solve this problem.
[originally posted on jforum.net by lennox]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Very little usefull information here.. but here's some things to check:

The XML above mentions localhost in the jdbc URL... if the DB is on a different server, this won;t work.

Also, have you checked that the server setting allow for remote connections by the id/password you are using? MySQL can be picky about that at times.

Have you checked if there are any firewall issues between you and the remote server? Maybe the firewall is blocking it.
[originally posted on jforum.net by monroe]
 
GeeCON Prague 2014
 
subject: Getting errors with my dataSource connection on the remote server but not on the local server