JDBC - No more data to read from socket

From: <jlee_at_tyc.com>
Date: Tue, 26 Jan 1999 23:06:38 GMT
Message-ID: <78lhpo$km5$1@nnrp1.dejanews.com>

Hi,

  I am using JDBC thin driver, jdk 1.17, Oracle 7.3.3.0.0., and Visual Cafe 3.0. when the JAVA application idles for 10 - 15 minutes, I got "No more data to read from socket" error message from the Visual Cafe Debugger after I try to do something. e.g. clicking on search button.

  When I check the login status from Oracle Enterprise Manager, it is inactive.

   Any suggestion?

Below is the error message.

• SQLException caught ***

SQLState: null
Message: No more data to read from socket Vendor: 0

No more data to read from socket java.sql.SQLException: No more data to read from socket at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:411) at oracle.jdbc.ttc7.TTCInBuffer.getByte(TTCInBuffer.java:94) at

oracle.jdbc.ttc7.TTIMsg.unmarshalSB1(TTIMsg.java:1085)	at
oracle.jdbc.ttc7.Oclose.receive(Oclose.java:110)  at
oracle.jdbc.ttc7.TTC7Protocol.close(TTC7Protocol.java:415)  at
oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1225)  at
oracle.jdbc.driver.OraclePreparedStatement.close(OraclePreparedStatement.java
:99 2)	at
com.tyc.java.tyclibrary.db.dbFunctions.setSQL(dbFunctions.java:282)  at
com.tyc.dcis.common.DBAdapter.getDataByRow(DBAdapter.java:623)	at

com.tyc.dcis.contract.ContractDBAdapter.retrieveProjectOfficerLastNameAndFirs tNa me(ContractDBAdapter.java:2533) at com.tyc.dcis.gui.JDCISFormSF279PersonSearchCriteriaPanel.getSearchResult(JDCI SFo rmSF279PersonSearchCriteriaPanel.java:99) at com.tyc.java.tyclibrary.awt.swing.JTYCSearchPanel.searchAction(JTYCSearchPane l.j ava:249) at
com.tyc.java.tyclibrary.awt.swing.JTYCSearchPanel$JTYCSearchPanelActionAdapte r.a ctionPerformed(JTYCSearchPanel.java:301) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1066) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton .ja va:1101) at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:37 8) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:250)  at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener. jav a:217) at java.awt.Component.processMouseEvent(Component.java:2355) at

java.awt.Component.processEvent(Component.java:2200)  at
java.awt.Container.processEvent(Container.java:904)  at
java.awt.Component.dispatchEventImpl(Component.java:1809)  at
java.awt.Container.dispatchEventImpl(Container.java:949)  at
java.awt.Component.dispatchEvent(Component.java:1741)  at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:1739)	at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:1537)  at
java.awt.LightweightDispatcher.dispatchEvent(Container.java:1453)  at
java.awt.Container.dispatchEventImpl(Container.java:936)  at
java.awt.Window.dispatchEventImpl(Window.java:491)  at
java.awt.Component.dispatchEvent(Component.java:1741)  at
java.awt.EventDispatchThread.run(EventDispatchThread.java:81) Cleaning Result

Panel null

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Jan 26 1999 - 17:06:38 CST