Error with JDBC on SUN One Web: 08S01 804 : I/O Error, Socket closed.

Connectivity

Error with JDBC on SUN One Web: 08S01 804 : I/O Error, Socket closed.

I have following enviroment:

OS: Solaris 9 on SUN (sparc)
Web Server: SUN Web Server 6.1
TD Driver: 12.00.00.00

Classpath in server.xml (classpathsuffix)includes: /usr/local/TeraJDBC/terajdbc4.jar:/usr/local/TeraJDBC/tdgssjava.jar:/usr/local/TeraJDBC/tdgssconfig.jar

And I am getting an exception when trying to establish a connection to Teradata using Teradata JDBC driver (type 4). This error does not occur if I run a stand alone Java DB class on command line; it only happens when running from SUN Web Server 6.1. See exception:

[font=Courier New]com.ncr.teradata.jdbc_4.util.JDBCException: [NCR] [Teradata JDBC Driver] : 08S01 804 : I/O Error, Socket closed. Packet stream read error: local=/10.16.3.147:49670 remote=/10.18.48.112:1025 cid=e59895 sess=356389 Tue Dec 04 13:40:01 EST 2007 com.ncr.teradata.jdbc_4.util.JDBCException: [NCR] [Teradata JDBC Driver] : TeraEncrypt: Error tdgss-stack-trace-begin>>> java.lang.ArrayIndexOutOfBoundsException: 96 at com.ncr.teradata.jgssp2td2.Td2Context.unwrap(DashoA14*..) at com.ncr.teradata.jtdgss.TdgssContext.unwrap(DashoA14*..) at com.ncr.teradata.TeraEncrypt.decrypt(TeraEncrypt.java:474) at com.ncr.teradata.jdbc_4.io.TDPacketStream1_3Impl.decryptIt(TDPacketStream1_3Impl.java:886) at com.ncr.teradata.jdbc_4.io.TDPacketStream1_3Impl.readStream(TDPacketStream1_3Impl.java:817) at com.ncr.teradata.jdbc_4.io.TDPacketStream1_3Impl.readStream(TDPacketStream1_3Impl.java:790) at com.ncr.teradata.jdbc_4.statemachine.ConnectRspState.action(ConnectRspState.java:67) at com.ncr.teradata.jdbc_4.statemachine.LogonController.run(LogonController.java:121) at com.ncr.teradata.jdbc_4.TDSession. (TeraLocalConnection.java:93) at com.ncr.teradata.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:50) at com.ncr.teradata.TeraDriver.connect(TeraDriver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.xc.portal.utils.TestTDConn.testTD(TestTDConn.java:32) at _jsps._etc._opt._SUNWps._desktop._cvs_en_US._cvsVendorMicrostrategyReports._html._channel_jsp._jspService(_channel_jsp.java:170) at com.sun.portal.providers.jsp.jasper3.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:908) at com.sun.portal.providers.jsp.JspServletWrapper.service(JspServletWrapper.java:182) at com.sun.portal.providers.jsp.JSPProvider.processJspFile(JSPProvider.java:896) at com.sun.portal.providers.jsp.JSPProvider.includeJspPage(JSPProvider.java:954) at com.sun.portal.providers.jsp.JspRequestDispatcher.getJspResource(JspRequestDispatcher.java:167) at com.sun.portal.providers.jsp.JspRequestDispatcher.include(JspRequestDispatcher.java:97) at com.sun.portal.providers.jsp.jasper3.jasper.runtime.PageContextImpl.include(PageContextImpl.java:409) at _jsps._etc._opt._SUNWps._desktop._cvs_en_US._cvsVendorMicrostrategyReports._html._content_jsp._jspService(_content_jsp.java:190) at com.sun.portal.providers.jsp.jasper3.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:908) at com.sun.portal.providers.jsp.JspServletWrapper.service(JspServletWrapper.java:182) at com.sun.portal.providers.jsp.JSPProvider.processJspFile(JSPProvider.java:896) at com.sun.portal.providers.jsp.JSPProvider.processJspFile(JSPProvider.java:810) at com.sun.portal.providers.jsp.JSPProvider.getContent(JSPProvider.java:579) at com.cvs.corp.portal.CVSJSPProvider.getContent(CVSJSPProvider.java) at com.sun.portal.desktop.context.ReusableProviderCaller.run(ReusableProviderCaller.java:160)
at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:140)
at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:115)
at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:190)
at com.ncr.teradata.jdbc_4.io.TDPacketStream1_3Impl.analyzeError(TDPacketStream1_3Impl.java:832)
at com.ncr.teradata.jdbc_4.io.TDPacketStream1_3Impl.readStream(TDPacketStream1_3Impl.java:822)
at com.ncr.teradata.jdbc_4.io.TDPacketStream1_3Impl.readStream(TDPacketStream1_3Impl.java:790)
at com.ncr.teradata.jdbc_4.statemachine.ConnectRspState.action(ConnectRspState.java:67)
at com.ncr.teradata.jdbc_4.statemachine.LogonController.run(LogonController.java:121)
at com.ncr.teradata.jdbc_4.TDSession. (TDSession.java:193)
at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalConnection. (TeraLocalConnection.java:93)
at com.ncr.teradata.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:50)
at com.ncr.teradata.TeraDriver.connect(TeraDriver.java:260)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.xc.portal.utils.TestTDConn.testTD(TestTDConn.java:32)
at _jsps._etc._opt._SUNWps._desktop._cvs_en_US._cvsVendorMicrostrategyReports._html._channel_jsp._jspService(_channel_jsp.java:170)
at com.sun.portal.providers.jsp.jasper3.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:908)
at com.sun.portal.providers.jsp.JspServletWrapper.service(JspServletWrapper.java:182)
at com.sun.portal.providers.jsp.JSPProvider.processJspFile(JSPProvider.java:896)
at com.sun.portal.providers.jsp.JSPProvider.includeJspPage(JSPProvider.java:954)
at com.sun.portal.providers.jsp.JspRequestDispatcher.getJspResource(JspRequestDispatcher.java:167)
at com.sun.portal.providers.jsp.JspRequestDispatcher.include(JspRequestDispatcher.java:97)
at com.sun.portal.providers.jsp.jasper3.jasper.runtime.PageContextImpl.include(PageContextImpl.java:409)
at _jsps._etc._opt._SUNWps._desktop._cvs_en_US._cvsVendorMicrostrategyReports._html._content_jsp._jspService(_content_jsp.java:190)
at com.sun.portal.providers.jsp.jasper3.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:908)
at com.sun.portal.providers.jsp.JspServletWrapper.service(JspServletWrapper.java:182)
at com.sun.portal.providers.jsp.JSPProvider.processJspFile(JSPProvider.java:896)
at com.sun.portal.providers.jsp.JSPProvider.processJspFile(JSPProvider.java:810)
at com.sun.portal.providers.jsp.JSPProvider.getContent(JSPProvider.java:579)
at com.cvs.corp.portal.CVSJSPProvider.getContent(CVSJSPProvider.java)
at com.sun.portal.desktop.context.ReusableProviderCaller.run(ReusableProviderCaller.java:160)[/font]

Can anyone let me know what the problem is, please? Is it a known issue with SUN Web Server 6.1 and Teradata JDBC driver?

Thanks.
4 REPLIES

Re: Error with JDBC on SUN One Web: 08S01 804 : I/O Error, Socket closed.

I met the same problem.Can anyone help me?
Enthusiast

Re: Error with JDBC on SUN One Web: 08S01 804 : I/O Error, Socket closed.

I met the same problem. It would be great who faced this error and got resolved.
N/A

Re: Error with JDBC on SUN One Web: 08S01 804 : I/O Error, Socket closed.

[Teradata JDBC Driver] [TeraJDBC 03.01.00.103] 08S01 804 : I/O Error, Socket closed

I came across this issue and my problem was PreparedStatement getting closed after connection getting closed. Since closing connection closes PreparedStatement object also, this exception was thrown.
Teradata Employee

Re: Error with JDBC on SUN One Web: 08S01 804 : I/O Error, Socket closed.

The list of application servers supported by the Teradata JDBC Driver is available at:
http://www.teradata.com/DownloadCenter/Topic9391-98-1.aspx

Please note that the Sun ONE Web Server is not supported by the Teradata JDBC Driver.

Having said that, this problem corresponds to JDBC DR 119329, which was fixed in Teradata JDBC Driver version 12.00.00.104 and later versions.