Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Serious problem with jdbc oci connection closed.

Jeong-Hwan Kim_1
Occasional Advisor

Serious problem with jdbc oci connection closed.

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)
5 REPLIES
Eric Antunes
Honored Contributor

Re: Serious problem with jdbc oci connection closed.

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

Each and every day is a good day to learn.
Jeong-Hwan Kim_1
Occasional Advisor

Re: Serious problem with jdbc oci connection closed.

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
Honored Contributor

Re: Serious problem with jdbc oci connection closed.

Hi again,

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

Regards,

Eric Antunes
Each and every day is a good day to learn.
Jeong-Hwan Kim_1
Occasional Advisor

Re: Serious problem with jdbc oci connection closed.

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
Occasional Advisor

Re: Serious problem with jdbc oci connection closed.

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