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

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

    Details

    • Steps to Reproduce:
      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

      Description

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

        Gliffy Diagrams

          Attachments

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

            Activity

              People

              • Assignee:
                hchiorean Horia Chiorean
                Reporter:
                rutlucas Lucas Ponce
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: