Oracle-L: JDBC thin driver losing connection

From: Ehresmann, David <David.Ehresmann_at_ps.net>
Date: Fri, 14 Mar 2003 06:59:06 -0800
Message-ID: <F001.0056A1CF.20030314065906@fatcity.com>

List,

We seem to be losing our client connection with a JDBC thin driver connection. The client and the developer say after a while the connection just goes away. This is 8.1.7 64bit and HP11. It does not happened on AIX. Is there something I need to configure, maybe in sqlnet.ora? Could it have something to do with sqlnet.expire_timeout setting that disconnects inactive connections?

Below is the error that gets returned:

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:417)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:432)

at
oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.ja va:182)
at
oracle.jdbc.driver.OracleCallableStatement.<init>(OracleCallableStatement.ja va:102)
at
oracle.jdbc.driver.OracleCallableStatement.<init>(OracleCallableStatement.ja va:86)
at
oracle.jdbc.driver.OracleConnection.privatePrepareCall(OracleConnection.java :736)
at
oracle.jdbc.driver.OracleConnection.prepareCall(OracleConnection.java:622) at
com.psc.dsg.di.dds.DataLayer.BatchDataLayer950.createBatch(BatchDataLayer950
.java:154)

at
com.psc.dsg.di.dds.DiamondObject.Batch.<init>(Batch.java:191)DataService1.lo g (89%)

Info, getBatchList(EI), userid: user1 ( com.psc.dsg.di.dds.core.InteractiveSess
ion.getBatchList_at_355, Thread[RMI TCP Connection(877)-,6,RMI Runti me], Thu Mar 06 12:48:44 CST 2003sport$1.run(Unknown Source)(OracleCallableState
Info, getBatchList(AI), userid: user1 ( com.psc.dsg.di.dds.core.InteractiveSess
DataService1.log (89%)
me], Thu Mar 06 12:48:44 CST 2003TCPTransport.handleMessages(Unknown Source) Info, getBatchList(PI), userid: user1 ( com.psc.dsg.di.dds.core.InteractiveSess
ion.getBatchList_at_355, Thread[RMI TCP Connection(877)-,6,RMI Runti me], Thu Mar 06 12:48:44 CST 2003nknown
Source)prepareCall(OracleConnection.java Info, getBatchList(IO), userid: user1 ( com.psc.dsg.di.dds.core.InteractiveSess
ion.getBatchList_at_355, Thread[RMI TCP Connection(877)-,6,RMI Runti me], Thu Mar 06 12:48:44 CST 2003TCP Connection(877)-,6,RMI Runti Info, getBatchList(OO), userid: user1 ( com.psc.dsg.di.dds.core.InteractiveSess
ion.getBatchList_at_355, Thread[RMI TCP Connection(877)-,6,RMI Runti me], Thu Mar 06 12:48:44 CST 2003TCP Connection(877)-,6,RMI Runti Info, getBatchList(DO), userid: user1 ( com.psc.dsg.di.dds.core.InteractiveSess
ion.getBatchList_at_355, Thread[RMI TCP Connection(877)-,6,RMI Runti me], Thu Mar 06 12:48:44 CST 2003TCP Connection(877)-,6,RMI Runti Info, getBatchList(RO), userid: user1 ( com.psc.dsg.di.dds.core.InteractiveSess
ion.getBatchList_at_355, Thread[RMI TCP Connection(877)-,6,RMI Runti me], Thu Mar 06 12:48:44 CST 2003
Info, getBatchList(EO), userid: user1 ( com.psc.dsg.di.dds.core.InteractiveSess
ion.getBatchList_at_355, Thread[RMI TCP Connection(877)-,6,RMI Runti )-,6,RMI Runtime], Thu Mar 06 12:48:44 CST 200300.156,6,RMI Runti Critical, java.sql.SQLException: Io exception: Broken pipe ( com.psc.dsg.di.dds
.DataLayer.BatchDataLayer950.createBatch_at_197, Thread[RMI TCP
Connection(879)-208
.242.100.140,6,RMI Runtime], Thu Mar 06 12:49:07 CST 2003)42.100.156,6,RMI
Runti
java.sql.SQLException: Io exception: Broken pipe877)-,6,RMI Runti

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)eSess
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)Runti
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323)Runti
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:417)ss
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:432)ti

at
oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.ja va:182)List(EO), userid: user1 ( com.psc.dsg.di.dds.core.InteractiveSess

at
oracle.jdbc.driver.OracleCallableStatement.<init>(OracleCallableState ment.java:102)

at
oracle.jdbc.driver.OracleCallableStatement.<init>(OracleCallableState ment.java:86)

at
oracle.jdbc.driver.OracleConnection.privatePrepareCall(OracleConnecti on.java:736)
:47) at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)eSess

at
com.psc.dsg.di.dds.core.InstClaimSubmit.initialize(InstClaimSubmit.ja va:35) at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323)Runti

at
com.psc.dsg.di.dds.core.DataService.processCommand(DataService.java:3 08) at
oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:432)ti

at java.lang.reflect.Method.invoke(Native Method)it>(OraclePreparedState

at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)teractiveSess

at sun.rmi.transport.Transport$1.run(Unknown Source)(OracleCallableState

        at java.security.AccessController.doPrivileged(Native Method)
        at sun.rmi.transport.Transport.serviceCall(Unknown
Source)eCallableState
        at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
        at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown

Sour
ce)java:736)

at java.lang.Thread.run(Unknown Source)

Info, getBatchList(DI), userid: user1 ( com.psc.dsg.di.dds.core.InteractiveSess
ion.getBatchList_at_355, Thread[RMI TCP Connection(881)- ,6,RMI Runti me], Thu Mar 06 12:50:21 CST 2003

thanks,

David Ehresmann

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ehresmann, David
  INET: David.Ehresmann_at_ps.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Mar 14 2003 - 08:59:06 CST