Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-1826

JDBC cache-store doesn't work with modeshape deployed in as7

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 3.1.3.Final, 3.2.0.Final
    • 3.1.1.Final
    • Common
    • None
    • Hide

      standalone-modeshape.xml configuration:

      [...]

      <cache-container name="modeshape" default-cache="sample">
         <local-cache name="sample">
              <transaction mode="NON_XA"/>
              <mixed-keyed-jdbc-store datasource="java:jboss/datasources/PostgresqlDS" passivation="false" purge="false">
                  <property name="databaseType">postgres</property>
                  <string-keyed-table prefix="stringbased">
                      <id-column name="id" type="VARCHAR(200)"/>
                      <data-column name="datum" type="BYTEA"/>
                      <timestamp-column name="version" type="BIGINT"/>
                  </string-keyed-table>
                  <binary-keyed-table prefix="binarybased">
                      <id-column name="id" type="VARCHAR(200)"/>
                      <data-column name="datum" type="BYTEA"/>
                      <timestamp-column name="version" type="BIGINT"/>
                  </binary-keyed-table>
              </mixed-keyed-jdbc-store>
          </local-cache>
          <local-cache name="artifacts">
              <transaction mode="NON_XA"/>
          </local-cache>
      </cache-container>

[...]

      Exceptions caught:

      15:11:08,150 ERROR [org.infinispan.loaders.jdbc.connectionfactory.ManagedConnectionFactory] (http--127.0.0.1-8080-2) ISPN008018: Sql failure retrieving connection from datasource: java.sql.SQLException: javax.resource.ResourceException: IJ000460: Error checking for a transaction
      at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:137)
      at org.infinispan.loaders.jdbc.connectionfactory.ManagedConnectionFactory.getConnection(ManagedConnectionFactory.java:90)

      [...]

      Caused by: javax.resource.ResourceException: IJ000460: Error checking for a transaction
      at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:362)
      at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464)
      at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129)
      ... 154 more
      Caused by: javax.resource.ResourceException: IJ000459: Transaction is not active: tx=TransactionImple < ac, BasicAction: 0:ffff7f000001:-6447336f:512b70d7:8 status: ActionStatus.COMMITTED >
      at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:352)
      ... 156 more

      Show
      standalone-modeshape.xml configuration: [...] <cache-container name= "modeshape" default-cache= "sample" > <local-cache name= "sample" > <transaction mode= "NON_XA" /> <mixed-keyed-jdbc-store datasource= "java:jboss/datasources/PostgresqlDS" passivation= "false" purge= "false" > <property name= "databaseType" > postgres </property> <string-keyed-table prefix= "stringbased" > <id-column name= "id" type= "VARCHAR(200)" /> <data-column name= "datum" type= "BYTEA" /> <timestamp-column name= "version" type= "BIGINT" /> </string-keyed-table> <binary-keyed-table prefix= "binarybased" > <id-column name= "id" type= "VARCHAR(200)" /> <data-column name= "datum" type= "BYTEA" /> <timestamp-column name= "version" type= "BIGINT" /> </binary-keyed-table> </mixed-keyed-jdbc-store> </local-cache> <local-cache name= "artifacts" > <transaction mode= "NON_XA" /> </local-cache> </cache-container> [...] Exceptions caught: 15:11:08,150 ERROR [org.infinispan.loaders.jdbc.connectionfactory.ManagedConnectionFactory] (http--127.0.0.1-8080-2) ISPN008018: Sql failure retrieving connection from datasource: java.sql.SQLException: javax.resource.ResourceException: IJ000460: Error checking for a transaction at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:137) at org.infinispan.loaders.jdbc.connectionfactory.ManagedConnectionFactory.getConnection(ManagedConnectionFactory.java:90) [...] Caused by: javax.resource.ResourceException: IJ000460: Error checking for a transaction at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:362) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464) at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129) ... 154 more Caused by: javax.resource.ResourceException: IJ000459: Transaction is not active: tx=TransactionImple < ac, BasicAction: 0:ffff7f000001:-6447336f:512b70d7:8 status: ActionStatus.COMMITTED > at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:352) ... 156 more

      Trying to set up a JDBC cache-store in infinispan modules used by ModeShape creates some errors.

        1. server.log
          932 kB
          Lucas Ponce
        2. standalone-modeshape.xml
          23 kB
          Lucas Ponce
        3. standalone-modeshape.xml
          24 kB
          Lucas Ponce

              hchiorean Horia Chiorean (Inactive)
              lponce@redhat.com Lucas Ponce
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: