[Hibernate-issues] [Hibernate-JIRA] Created: (HHH-1733) JDBC Connection Closed Exception

[srinath r. (JIRA) <no...@at...>]

JDBC Connection Closed Exception 
---------------------------------

         Key: HHH-1733
         URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1733
     Project: Hibernate3
        Type: Bug

    Versions: 3.0 final    
 Environment: Hibernate Version 3.0
JBoss 3.2.3
Linux 2.4.9-e.49enterprise
Oracle 9i
    Reporter: srinath ramachandran


When My database is restarted and I don't restart my application server and try to query using Hibernate. I get the below mentioned exception. It looks like Hibernate still uses the cached connection.  

My Hibernate properties :
hibernate.dialect=org.hibernate.dialect.OracleDialect
transaction.factory_class=org.hibernate.transaction.JDBCTransactionFactory
hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider
hibernate.cglib.use_reflection_optimizer=false
hibernate.show_sql=true
hibernate.use_identifer_rollback=true

Exception : 
Caused by: java.sql.SQLException: Closed Connection
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
        at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:962)
        at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:869)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:396)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:334)
        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:88)
        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1162)
        at org.hibernate.loader.Loader.doQuery(Loader.java:390)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
        at org.hibernate.loader.Loader.doList(Loader.java:1593)


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira