topic Re: Oracle java.sql.SQLException: Closed Connection in Alfresco Archive

Oracle java.sql.SQLException: Closed Connection

harry_moore — Fri, 26 Jun 2009 16:16:12 GMT

We are seeing errors similar to this a few times each day. Initially they looked like they were caused by broken pipe errors but we started using custom connection pool settings last night and now we still see the errors but they are not accompanied by broken pipe errors. Has anyone seen this?2009-0

Re: Oracle java.sql.SQLException: Closed Connection

dward — Fri, 26 Jun 2009 16:44:38 GMT

Have you changed the value of hibernate.connection.release_mode?

Are you using a JTA transaction manager?

How is your datasource defined?

Re: Oracle java.sql.SQLException: Closed Connection

dward — Fri, 26 Jun 2009 16:59:36 GMT

What custom connection pooling settings are you using?

If you are still using commons dbcp, you should probably set a validation query to ensure your connection is tested before use. E.g.

    <!– Datasource bean –>
    <bean id="defaultDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName">
            <value>${db.driver}</value>
        </property>
        <property name="url">
            <value>${db.url}</value>
        </property>
        <property name="username">
            <value>${db.username}</value>
        </property>
        <property name="password">
            <value>${db.password}</value>
        </property>
        <property name="initialSize" >
            <value>${db.pool.initial}</value>
        </property>
        <property name="maxActive" >
            <value>${db.pool.max}</value>
        </property>
        <property name="defaultAutoCommit" >
            <value>false</value>
        </property>
        <property name="defaultTransactionIsolation" >
            <value>${db.txn.isolation}</value>
        </property>
        <property name="validationQuery" >
            <value>SELECT NULL FROM DUAL</value>
        </property>
    </bean>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍