Details

    • Type: New Feature New Feature
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 1.4
    • Fix Version/s: None
    • Component/s: jackrabbit-core
    • Labels:
      None

      Description

      It is not possible to configure either JNDIDatabasePersistenceManager or BundleDbPersistenceManager to use a Managed Datasource. Methods like setAutoCommit, commit and rollback should not be called on managed connections.

      Try to run Jackrabbit within JBOSS or Apache Geronimo and you should face the same problems.

        Issue Links

          Activity

          Hide
          Thomas Mueller added a comment -

          Jackrabbit does not support this mode of operation right now.

          To support it, we would need to define exactly how this mode should behave,
          for example: should the Session.save() calls be silently ignored, or should they
          throw an exception (like commit() throws an exception).

          Show
          Thomas Mueller added a comment - Jackrabbit does not support this mode of operation right now. To support it, we would need to define exactly how this mode should behave, for example: should the Session.save() calls be silently ignored, or should they throw an exception (like commit() throws an exception).
          Hide
          Jarle B. Hjortland added a comment -

          If Session.save() does not else than commit the connections, it could fail or log an warning ("Session.save on a managed connection will not commit to the DB").

          So for now the only solution to my problem is to create an EJB with transactions disabled. (Manually defined connections is not a option).

          Show
          Jarle B. Hjortland added a comment - If Session.save() does not else than commit the connections, it could fail or log an warning ("Session.save on a managed connection will not commit to the DB"). So for now the only solution to my problem is to create an EJB with transactions disabled. (Manually defined connections is not a option).
          Hide
          Marcel May added a comment -

          Deploy Jackrabbit using the JCA adapter and configure an unmanaged datasource (For JBoss: <no-tx-datasource/>).

          Show
          Marcel May added a comment - Deploy Jackrabbit using the JCA adapter and configure an unmanaged datasource (For JBoss: <no-tx-datasource/>).
          Hide
          Dirk Feufel added a comment -

          Same problem with WebSphere and datasources. In addition Prepared Statements should not be cached and reused.

          Here some hints were to start:

          Caused by: java.sql.SQLException: DSRA9350E: Operation Connection.commit is not allowed during a global transaction.
          at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:922)
          at org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.store(DatabasePersistenceManager.java:315)

          com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.
          at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.runtimeXIfNotClosed(WSJdbcStatement.java:1505)
          at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setObject(WSJdbcPreparedStatement.java:1408)
          at org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.executeStmt(DatabasePersistenceManager.java:855)
          at org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.store(DatabasePersistenceManager.java:480)

          Show
          Dirk Feufel added a comment - Same problem with WebSphere and datasources. In addition Prepared Statements should not be cached and reused. Here some hints were to start: Caused by: java.sql.SQLException: DSRA9350E: Operation Connection.commit is not allowed during a global transaction. at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:922) at org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.store(DatabasePersistenceManager.java:315) com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed. at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.runtimeXIfNotClosed(WSJdbcStatement.java:1505) at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setObject(WSJdbcPreparedStatement.java:1408) at org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.executeStmt(DatabasePersistenceManager.java:855) at org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.store(DatabasePersistenceManager.java:480)
          Hide
          Michael Braunschweig added a comment -

          The solution for WebSphere application server is:

          Navigate to Resources - JDBC - Data sources - <data source> - Custom properties

          add property nonTransactionalDataSource with value true

          Show
          Michael Braunschweig added a comment - The solution for WebSphere application server is: Navigate to Resources - JDBC - Data sources - <data source> - Custom properties add property nonTransactionalDataSource with value true
          Hide
          Dirk Feufel added a comment -

          I will be out of the office till April 11th 2010. I will respond to your e-mail as soon as possible on my return. Please note, that your mail will not be forwarded. In urgent cases please contact support@de.cordys.com.

          Show
          Dirk Feufel added a comment - I will be out of the office till April 11th 2010. I will respond to your e-mail as soon as possible on my return. Please note, that your mail will not be forwarded. In urgent cases please contact support@de.cordys.com.
          Hide
          Rakesh Goswami added a comment -

          Hi Michael : I have tried what ever u suggest above on my web Sphere but it is not working.
          Have you got resolved this problem through above method.

          Show
          Rakesh Goswami added a comment - Hi Michael : I have tried what ever u suggest above on my web Sphere but it is not working. Have you got resolved this problem through above method.

            People

            • Assignee:
              Unassigned
              Reporter:
              Jarle B. Hjortland
            • Votes:
              3 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:

                Development