You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Dag H. Wanvik (JIRA)" <ji...@apache.org> on 2013/11/26 23:54:38 UTC

[jira] [Commented] (DERBY-6422) After running performance code for long time, suddenly no connections are available

    [ https://issues.apache.org/jira/browse/DERBY-6422?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13833191#comment-13833191 ] 

Dag H. Wanvik commented on DERBY-6422:
--------------------------------------

It's not obvious to me this is a Derby problem: Hibernate seems to be calling "getAutoCommit" [1] on a closed Derby connection. It could, of course, be that Derby has experiences a problem and so erroneously closed the connection without throwing any indication to Hibernate, but this should be investigated first. Any clues in derby.log 

[1] http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#getAutoCommit()

> After running performance code for long time, suddenly no connections are available
> -----------------------------------------------------------------------------------
>
>                 Key: DERBY-6422
>                 URL: https://issues.apache.org/jira/browse/DERBY-6422
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.9.1.0
>         Environment: Os: Suse 10.
>            Reporter: patil devidas
>   Original Estimate: 1m
>  Remaining Estimate: 1m
>
> Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection
> 	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
> 	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> 	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
> 	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
> 	at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
> 	at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
> 	at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
> 	at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1330)
> 	at org.pentaho.platform.repository.hibernate.HibernateUtil.beginTransaction(HibernateUtil.java:465)
> 	... 74 more
> Caused by: java.sql.SQLNonTransientConnectionException: No current connection.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.getAutoCommit(Unknown Source)
> 	at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:108)
> 	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
> 	... 79 more



--
This message was sent by Atlassian JIRA
(v6.1#6144)