Paul Ferraro wrote:
Actually, you can eliminate the sticky session requirement by using an <invalidation-cache/> instead of a <local-cache/>. This, of course, would require that you use an HA-aware profile (e.g. standalone-ha.xml).
Hi Paul,
Thanks for your reply.
As per your suggestions I am using <invalidation-cache> in standalone-ha.xml... I am getting below error..
15:06:38,303 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-1) MSC00001: Failed to start service jboss.infinispan.web.database.config: org.jboss.msc.service.StartException in service jboss.infinispan.web.database.config: JBAS010291: Failed to add INVALIDATION_ASYNC database cache to non-clustered web cache container.
at org.jboss.as.clustering.infinispan.subsystem.CacheConfigurationService.start(CacheConfigurationService.java:100)
at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [rt.jar:1.6.0_03]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [rt.jar:1.6.0_03]
at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_03]
15:06:38,350 INFO [org.infinispan.cdi.InfinispanExtension] (MSC service thread 1-2) ISPN017001: Infinispan CDI extension version: 5.1.4.FINAL
configuration in standalone-ha.xml is.. since infinispan 1.2 doesn't supports <key-based-jdbc-store> i am using <string-keyed-jdbc-store>. database type is oracle.
<cache-container name="web" default-cache="database">
<invalidation-cache name="database" mode="ASYNC" batching="true">
<string-keyed-jdbc-store datasource="java:jboss/datasources/LiferayPool_test" passivation="false" preload="true" purge="false">
<property name="databaseType">oracle</property>
<string-keyed-table prefix="stringbased ">
<id-column name="id"
type="VARCHAR2"/>
<data-column name="datum"
type="BLOB"/>
<timestamp-column name="version"
type="NUMBER"/>
</string-keyed-table>
</string-keyed-jdbc-store>
</invalidation-cache>
</cache-container>
Could you please guide me what I am doing wrong ?