[jboss-user] [Datasource Configuration] - Re: Jboss 7.x - HA Web Sessions via Database Persistence with Oracle

[manish suriya]

manish suriya [https://community.jboss.org/people/techtalk] created the discussion

"Re: Jboss 7.x - HA Web Sessions via Database Persistence with Oracle"

To view the discussion, visit: https://community.jboss.org/message/746675#746675

--------------------------------------------------------------
> 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 ?
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/746675#746675]

Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120706/d78cee2d/attachment.html