Laura - 2012-09-21

I am trying to connect my web application to a MS SQL Server 2005 which has SSL enabled. My web app is running on WebSphere 6.0 and Java 1.4 (I know it's outdated but it's an old app). I am using the jtds driver and setting the ssl=required in the connection string. Also tried ssl=request. I also added the MS SQL Server certificate to the WebSphere truststore. When I call getConnection(), I get Network error IOException: Connection reset

Here is the stack trace:
java.sql.SQLException: Network error IOException: Connection reset
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:410)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at java.sql.DriverManager.getConnection(DriverManager.java:539)
at java.sql.DriverManager.getConnection(DriverManager.java:189)
at simed.utils.SQLServerDB.getConnectionT2(SQLServerDB.java:51)
at simed.utils.SQLServerDB.getConnection(SQLServerDB.java:31)
at simed.pkg.User.userAuthenticate(User.java:537)
at simed.servlets.Authenticate.doPost(Authenticate.java:34)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1173)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:69)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:626)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:2837)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220)
at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1681)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:94)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:548)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:601)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:934)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1021)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1332)
Caused by: java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:195)
at net.sourceforge.jtds.ssl.TdsTlsInputStream.readFully(TdsTlsInputStream.java:131)
at net.sourceforge.jtds.ssl.TdsTlsInputStream.primeBuffer(TdsTlsInputStream.java:100)
at net.sourceforge.jtds.ssl.TdsTlsInputStream.read(TdsTlsInputStream.java:78)
at com.ibm.sslite.t.a(Unknown Source)
at com.ibm.sslite.t.b(Unknown Source)
at com.ibm.sslite.m.a(Unknown Source)
at com.ibm.sslite.n.<init>(Unknown Source)
at com.ibm.sslite.be.a(Unknown Source)
at com.ibm.sslite.be.<init>(Unknown Source)
at com.ibm.jsse.bs.a(Unknown Source)
at com.ibm.jsse.bs.startHandshake(Unknown Source)
at net.sourceforge.jtds.ssl.SocketFactories$TdsTlsSocketFactory.createSocket(SocketFactories.java:101)
at net.sourceforge.jtds.jdbc.SharedSocket.enableEncryption(SharedSocket.java:342)
at net.sourceforge.jtds.jdbc.TdsCore.negotiateSSL(TdsCore.java:548)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:339)
... 27 more

[9/21/12 17:54:19:123 GMT] 0000003b SystemErr R at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:410)
[9/21/12 17:54:19:123 GMT] 0000003b SystemErr R at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
[9/21/12 17:54:19:123 GMT] 0000003b SystemErr R at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
[9/21/12 17:54:19:123 GMT] 0000003b SystemErr R at java.sql.DriverManager.getConnection(DriverManager.java:539)
[9/21/12 17:54:19:123 GMT] 0000003b SystemErr R at java.sql.DriverManager.getConnection(DriverManager.java:189)