java.sql.SQLException: Closed Connection

[vjy chin]

Hi,

I am using Oracle 10g database and Oracle 10 AppServer. I am doing an intesive process in whichit will insert thousands of records in the tables. So i started teh process yesterday and today morning i saw this exception.

The error log that shows is

 06/03/09 07:55:16 java.sql.SQLException: Closed Connection
06/03/09 07:55:16 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
06/03/09 07:55:16 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)
06/03/09 07:55:16 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:239)
06/03/09 07:55:16 at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1267)
06/03/09 07:55:16 at com.evermind.sql.FilterConnection.rollback(FilterConnection.java:193)
06/03/09 07:55:22 at com.evermind.sql.OrionCMTConnection.rollback(OrionCMTConnection.java:527)
06/03/09 07:55:22 at com.evermind.sql.ConnectionBCELProxy.rollback(ConnectionBCELProxy.java:151)
 
   

I have all the rights for accessing the database and the previous instances it was working. Please let me know how I should go about this.

Thanks

[Beksy Kurian]

Does your database go down at night for cold backups?
Check with your dba to know cold and hot backup timings. It might have worked on hot backup days since the database doesn't have to be down for hot backups.
Beksy

[vjy chin]

Thanks for your reply dude.
I will check that with my DBA and proceed from there. I will also update once I find the cause.

Thanks for your time.