users@glassfish.java.net

Re: Problem with JDBC Connection Pool

From: <glassfish_at_javadesktop.org>
Date: Mon, 15 Mar 2010 14:41:44 PDT

Youness,

Thanks for the reply. There is no firewall between these servers, both are connected to the same physical Ethernet switch. Both can ping each other and telnetting to port 3306 from one to the other shows the connection is successful (MySQL version number followed by non-textual info is displayed).

The Glassfish 3 server has a local MySQL server. The pool within Glassfish (newserver.luzerne.edu) has the servername, ServerName, and serverName properties set to portal.luzerne.edu. Url, url, and URL properties are set to jdbc:mysql://portal.luzerne.edu/staff.

The access denied message indicates access is denied for 'portal'@'newserver.luzerne.edu'. I understand the access denied message, it is connecting to the local MySQL server and the credentials in use are not valid for this server. Why it is connecting to this box is a mystery. The properties indicate it should be connecting to portal.luzerne.edu, not newserver.luzerne.edu.

I'm confused :)

Bob
[Message sent by forum member 'bdushok' (bdushok_at_gmail.com)]

http://forums.java.net/jive/thread.jspa?messageID=392024