Serious problem with jdbc oci connection closed.

[Jeong-Hwan Kim_1]

i've got serious problem with oci driver on itanium2 (hpux 11.23) and oracle 9.2.0.6 which is applied the latest oracle patch for oracle 9i.
i've using oci driver to connect oracle database server via connection pool, because of dealing with LOB type.
there is no concern with initial oci connection, but the problem is the connection is irregularily closed. i don't know why.
various oci drivers has been tested from 9.2.x to 10.x. there is, however, nothing changed.

---------------------------------
Caused by: java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:226)
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:708)
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:625)
at oracle.jdbc.OracleConnectionWrapper.prepareStatement(OracleConnectionWrapper.java:72)
at jeus.jdbc.connectionpool.ConnectionWrapper.prepareStatement(ConnectionWrapper.java:45)
at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.retrieveObject(StandardRDBMSAdap
ter.java:269)

[Eric Antunes]

Hi,

There is a bug (4162316: "ENQUEUE RETURNS ORA-1031 WHEN THE MESSAGE SIZE IS LARGER THAN 2KBYTE") about this in Metalink:

http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=BUG&p_id=4162316

Best Regards,

Eric Antunes

[Jeong-Hwan Kim_1]

thanks for your reply. but i should have mentioned it. actually i've got sql exception 17008 when connection is closed as following.

-----------------------------
[#|2005-06-01 18:00:07|FINEST|55|com.tmax.eai.nms.impl.repository.provider.slide.SlideSession|assureTransaction|assureTransa
ction()|#]
[2005.06.01 18:00:07][0] 01 Jun 2005 18:00:07 - org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter - ERROR - SQL error 1
7008 on /namespace/aHR0cDovL09TUy1QUklNRS9SZXF1aXJlbWVudE1hbmFnZW1lbnQvV1NETC9STS1UZXN0LVJlcS1zZXJ2aWNl/wsdl: Closed Connect
ion

01 Jun 2005 18:00:07 - org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter - ERROR - SQL error 17008 on /namespace/aHR0cD
ovL09TUy1QUklNRS9SZXF1aXJlbWVudE1hbmFnZW1lbnQvV1NETC9STS1UZXN0LVJlcS1zZXJ2aWNl/wsdl: Closed Connection
[2005.06.01 18:00:07][0] org.apache.slide.common.ServiceAccessException: Service org.apache.slide.store.impl.rdbms.J2EEStore
@6be16028 access error : Closed Connection

org.apache.slide.common.ServiceAccessException: Service org.apache.slide.store.impl.rdbms.J2EEStore@6be16028 access error :
Closed Connection
[2005.06.01 18:00:07][0] at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createException(StandardRDBMSAdapt
er.java:1405)

at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createException(StandardRDBMSAdapter.java:1405)
[2005.06.01 18:00:07][0] at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.retrieveObject(StandardRDBMSAdapte
r.java:350)
at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.retrieveObject(AbstractRDBMSStore.java:420)
at org.apache.slide.store.AbstractStore.retrieveObject(AbstractStore.java:594)
at org.apache.slide.store.ExtendedStore.retrieveObject(ExtendedStore.java:574)

at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.retrieveObject(StandardRDBMSAdapter.java:350)
at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.retrieveObject(AbstractRDBMSStore.java:420)
at org.apache.slide.store.AbstractStore.retrieveObject(AbstractStore.java:594)
at org.apache.slide.store.ExtendedStore.retrieveObject(ExtendedStore.java:574)
[2005.06.01 18:00:07][0] at org.apache.slide.structure.StructureImpl.retrieve(StructureImpl.java:178)
at org.apache.slide.content.ContentImpl.retrieve(ContentImpl.java:155)
at com.tmax.eai.nms.impl.repository.provider.slide.SlideNode.getNodeRevisionDescriptors(SlideNode.java:1107)
at com.tmax.eai.nms.impl.repository.provider.slide.SlideNode.getContentStream(SlideNode.java:614)

at org.apache.slide.structure.StructureImpl.retrieve(StructureImpl.java:178)
at org.apache.slide.content.ContentImpl.retrieve(ContentImpl.java:155)
at com.tmax.eai.nms.impl.repository.provider.slide.SlideNode.getNodeRevisionDescriptors(SlideNode.java:1107)
at com.tmax.eai.nms.impl.repository.provider.slide.SlideNode.getContentStream(SlideNode.java:614)

[Eric Antunes]

Hi again,

Try to download and test using the latest JDBC OCI Driver (Metalink Note 263914.1)

Regards,

Eric Antunes

[Jeong-Hwan Kim_1]

Connection closed problem was appeared by user's fault hanlding jdbc connection pool. SQL 17008 or 17108 was simple exception message when connection was closed explicitly as the way user coded and tried to reuse the closed connection thread.
Anyway, thanks a lot.

[Jeong-Hwan Kim_1]

as mentioned above, this problem has been closed. ^^