[jboss-user] [JBoss Cache] - Configure Time interval to persist data in storage

[Deepak A]

Deepak A [http://community.jboss.org/people/deeal] created the discussion

"Configure Time interval to persist data in storage"

To view the discussion, visit: http://community.jboss.org/message/592016#592016

--------------------------------------------------------------
Hello

I am using JDBCCacheLoader to persist the data present in cache to DB. 
The configuration is:

<cacheloader>
                    <class>org.jboss.cache.loader.JDBCCacheLoader</class>
                    <!-- same as the old CacheLoaderConfig attribute -->
                    <properties>
                        cache.jdbc.table.name=SCHEMA.JBOSS_CACHE_DATA
                        cache.jdbc.table.create=false
                        cache.jdbc.table.drop=false
                        cache.jdbc.table.primarykey=jbosscache_pk
                        cache.jdbc.fqn.column=fqn
                        cache.jdbc.fqn.type=varchar2(3000)
                        cache.jdbc.node.column=node
                        cache.jdbc.node.type=blob
                        cache.jdbc.parent.column=parent
                         cache.jdbc.datasource=ABC/DB-BASIC
                        cache.jdbc.sql-concat=concat(1,2)
                           cache.jdbc.connection.factory=org.jboss.cache.loader.C3p0ConnectionFactory
                           c3p0.maxPoolSize=20
                           c3p0.checkoutTimeout=20000
                    </properties>
                    <!-- whether the cache loader writes are asynchronous -->
                    <async>true</async>
                    <!-- only one cache loader in the chain may set fetchPersistentState
                to true. An exception is thrown if more than one cache loader 
            sets this to true. -->
                    <fetchPersistentState>true</fetchPersistentState>
                    <!-- determines whether this cache loader ignores writes - defaults 
                to false. -->
                    <ignoreModifications>false</ignoreModifications>
                    <!-- if set to true, purges the contents of this cache loader when the 
                cache starts up. Defaults to false.  -->
                    <purgeOnStartup>false</purgeOnStartup>
                </cacheloader>

What I observed that on each write to cache will trigger an update query to persist data in DB. 
I did quiet research to find out whether I can configure the interval to write to DB, but went in vain.... 

Is there any way that I can configure this property.
--------------------------------------------------------------

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

Start a new discussion in JBoss Cache at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2052]

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