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.