users@glassfish.java.net

Re: Toplink in Java SE, are there known issues connecting to MS SQL server?

From: Mitesh Meswani <Mitesh.Meswani_at_Sun.COM>
Date: Wed, 13 Aug 2008 18:19:02 -0700

>Caused by: java.net.SocketException: Connection reset

> at java.net.SocketInputStream.read(SocketInputStream.java:168)
> at java.net.SocksSocketImpl.readSocksReply(SocksSocketImpl.java:85)
> at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:429)
> at java.net.Socket.connect(Socket.java:519)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:304)
> at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:255)

This seem to indicate that there is an issue at socket level. There is
nothing that Toplink Essentials is doing here. You should try and debug
your environment or consult the driver provider. Have you tried using
Microsfot's jdbc driver for MS SQL?