dev@glassfish.java.net

SocketException when pinging db from Glassfish...

From: Lidia Marchioni <lidia.marchioni_at_oracle.com>
Date: Tue, 21 Sep 2010 17:43:23 -0700

Hi all

I'm facing an issue with ping on my test windows system (this issue is
not showing on other windows systems I tried) and am hoping to get some
pointers on how to debug this further.

I am unable to ping a database from Glassfish, neither CLI nor Admin
Console. I am able, however, to connect to the database from a
standalone java program running on the same machine, that's using the
same connection parameters and jdbc driver as the ones used in Glassfish.

The error I get from asadmin is:

C:\as\testing>asadmin ping-connection-pool oraPool
remote failure: Ping Connection Pool for oraPool is Failed. Ping failed
Exception - Connection could not be allocated because: The Network
Adapter could not establish the connection Please check the server.log
for more details.
Ping failed Exception - Connection could not be allocated because: The
Network Adapter could not establish the connection Please check the
server.log for more details.

Command ping-connection-pool failed.


Interestingly, there are no more details in server.log. However, if I
try to ping database from Admin Console, server.log contains the
following exception:

[#|2010-09-21T16:39:23.658-0700|SEVERE|glassfish3.1|com.sun.jersey.spi.container.ContainerResponse|_ThreadID=15;_ThreadName=Thread-1;|Mapped
exception to response: 500 (Internal Server Error)
javax.ws.rs.WebApplicationException:
org.glassfish.admin.rest.CliFailureException: Ping Connection Pool for
oraPool is Failed. Ping failed Exception - Connection could not be
allocated because: The Network Adapter could not establish the co
nnection Please check the server.log for more details.
        at
org.glassfish.admin.rest.resources.TemplateCommandGetResource.processGet(TemplateCommandGetResource.java:84)
(...)
Caused by: java.net.SocketException: Reply from SOCKS server has bad version
        at java.net.SocksSocketImpl.connectV4(SocksSocketImpl.java:269)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:437)
        at java.net.Socket.connect(Socket.java:529)
...

I originally logged this as a bug
(https://glassfish.dev.java.net/issues/show_bug.cgi?id=13401), thinking
it was a windows specific issue, however, ping works on other windows
systems, only not this one. I am hoping someone has an idea of what may
be causing this error. There is no Firewall running on this system.
Not sure what else to check/verify. Any pointers appreciated.

Thanks
Lidia