[jboss-user] [JBoss Cache POJO Edition] - How exactly PojoCache.detach(Fqn fqn) works ... ?

[Ajuba Ajuba]

Ajuba Ajuba [http://community.jboss.org/people/ajuba] created the discussion

"How exactly PojoCache.detach(Fqn fqn) works ... ?"

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

--------------------------------------------------------------
I am using PojoCache version 3.0.x "Nana" with JobssAS 5.0.1


I am using JDBC CacheLoader "org.jboss.cache.loader.JDBCCacheLoader" for persisting the Nodes.

Configurations are as follows:

<!-- New 1.3.x cache loader config block -->
        <attribute name="CacheLoaderConfiguration">
            <config>
                <passivation>false</passivation>
                
                <cacheloader>
                    <class>org.jboss.cache.loader.JDBCCacheLoader</class>
                    <!-- whether the cache loader writes are asynchronous -->
                    <async>false</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>
                    
                    <!-- same as the old CacheLoaderConfig attribute -->
                    <properties>
                        cache.jdbc.driver=com.mysql.jdbc.Driver
                        cache.jdbc.url=jdbc:mysql://ipaddress/pojocachedb
                        cache.jdbc.user=myuser
                        cache.jdbc.password=mypassword
                        <!--  table properties -->
                        cache.jdbc.table.name=feedbackpojocache
                        cache.jdbc.table.create=false
                        cache.jdbc.table.drop=false
                        cache.jdbc.table.primarykey=feedbackpojocache_pk
                        cache.jdbc.fqn.column=fqn
                        cache.jdbc.fqn.type=varchar(255)
                        cache.jdbc.node.column=node
                        cache.jdbc.node.type=LONGBLOB
                        cache.jdbc.parent.column=parent
                    </properties>
                    
                </cacheloader>
            </config>
        </attribute>



Now when i am attaching fqn to PojoCache it is working fine, means it is writing it to Database as (FQN, NODE, PARENT) also.

but when i am detaching the Node it is deleting only NODE value from database ... not deleting the FQN and PARENT vlaues from database;


what to do..?

means how to delete FQN, NODE, PARENT from database.. when detaching the given Fqn..?

Pls help.

Regards,
Ajuba

--------------------------------------------------------------

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

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

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