[jboss-user] [JBossCache] - Re: JBossCache 1.3 - CacheStoreInterceptor does not commit t

Yippppeeeeeeeee!!!! I have solved the problem!!! Actually I should have used an XADataSource for the underlying database to use global transactions for the cache. The clue of the problem was in comments of TxInterceptor.RemoteSynchronizationHandler.afterCompletion() - // this should really not be done here - // it is supposed to be post commit not actually run the commit Actually in 2-phase commit, the transaction would already have been committed, so there is no way that connection.commit() would be called in CacheStoreInterceptor. I would recommend that this should be included as a part of the faq or jboss cache tutorials - that whenever we are using a backing store with application server's TransactionManager, we should always use an XADataSource. <attribute name="CacheLoaderConfiguration"> | <config> | <passivation>false</passivation> | <preload>/</preload> | <shared>true</shared> | <cacheloader> | <class>org.jboss.cache.loader.JDBCCacheLoader</class> | <properties> | cache.jdbc.table.name=jbosscache | cache.jdbc.table.create=true | cache.jdbc.table.drop=false | cache.jdbc.table.primarykey=jbosscache_pk | cache.jdbc.fqn.column=fqn | cache.jdbc.fqn.type=varchar(255) | cache.jdbc.node.column=node | cache.jdbc.node.type=blob | cache.jdbc.parent.column=parent | cache.jdbc.datasource=AshleyCacheDataSource | </properties> | <async>false</async> | <fetchPersistentState>true</fetchPersistentState> | <ignoreModifications>false</ignoreModifications> | </cacheloader> | </config> | </attribute> OR <attribute name="CacheLoaderConfiguration"> | <config> | <passivation>false</passivation> | <preload>/</preload> | <shared>true</shared> | <cacheloader> | <class>org.jboss.cache.loader.JDBCCacheLoader</class> | <properties> | cache.jdbc.table.name=jbosscache | cache.jdbc.table.create=true | cache.jdbc.table.drop=false | cache.jdbc.table.primarykey=jbosscache_pk | cache.jdbc.fqn.column=fqn | cache.jdbc.fqn.type=varchar(255) | cache.jdbc.node.column=node | cache.jdbc.node.type=blob | cache.jdbc.parent.column=parent | cache.jdbc.driver=oracle.jdbc.xa.client.OracleXADataSource | cache.jdbc.url=jdbc:oracle:thin:@localhost:1521:ACRMDEV | cache.jdbc.user=FASTDEV | cache.jdbc.password=fastdev123$ | </properties> | <async>false</async> | <fetchPersistentState>true</fetchPersistentState> | <ignoreModifications>false</ignoreModifications> | </cacheloader> | </config> | </attribute> Took me 2 days for this problem but I must say it was a wonderful experience and great sleuthing ;) View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4025417#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...