Uploaded image for project: 'Pentaho BA Platform'
  1. Pentaho BA Platform
  2. BISERVER-474

Hibernate connection closes when configured to use JNDI (Oracle repos tested)

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Won't Fix
    • Affects Version/s: Pentaho 1.6 GA
    • Fix Version/s: None
    • Labels:
      None
    • Environment:
      1.6 PCI, Oracle repository
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      With Hibernate configured to use JNDI datasource, the following error occurs (being reported against Oracle):

      15:22:15,050 ERROR [JDBCTransaction] JDBC commit failed
      java.sql.SQLException: Connection handle has been closed and is unusable
      at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:537)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:524)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConnection.java:333)
      at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139)
      at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
      at org.pentaho.repository.HibernateUtil.commitTransaction(HibernateUtil.java:377)
      at org.pentaho.repository.HibernateUtil.systemExitPoint(HibernateUtil.java:631)
      at org.pentaho.core.system.StandaloneApplicationContext.invokeExitPoints(StandaloneApplicationContext.java:132)
      at org.pentaho.core.system.PentahoSystem.systemExitPoint(PentahoSystem.java:1278)
      at org.pentaho.ui.servlet.GetImage.doPost(GetImage.java:135)

      Caused by: java.sql.SQLException: Connection handle has been closed and is unusable
      at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:537)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:524)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConnection.java:333)
      at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139)
      at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
      ... 65 more
      15:22:15,114 ERROR [JDBCTransaction] Could not toggle autocommit
      java.sql.SQLException: Connection handle has been closed and is unusable
      at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:537)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.setAutoCommit(WrappedConnection.java:321)
      at org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:194)
      at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:142)
      at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
      at org.pentaho.repository.HibernateUtil.commitTransaction(HibernateUtil.java:377)
      at org.pentaho.repository.HibernateUtil.systemExitPoint(HibernateUtil.java:631)
      at org.pentaho.core.system.StandaloneApplicationContext.invokeExitPoints(StandaloneApplicationContext.java:132)
      at org.pentaho.core.system.PentahoSystem.systemExitPoint(PentahoSystem.java:1278)
      at org.pentaho.ui.servlet.GetImage.doPost(GetImage.java:135)
      at org.pentaho.ui.servlet.GetImage.doGet(GetImage.java:44)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jcornelius Jared Cornelius
            • Votes:
              2 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: