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
[EMAIL PROTECTED], 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
[EMAIL PROTECTED], 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
[EMAIL PROTECTED], 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
[EMAIL PROTECTED], 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
[EMAIL PROTECTED], 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
[EMAIL PROTECTED], 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
[EMAIL PROTECTED], 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
[EMAIL PROTECTED], 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
[EMAIL PROTECTED], 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
