[JBoss-user] [JBossCache] - Re: JDBCCacheLoader feature
Hi, I get the same pb and afer looking at the source in cvs it seems that old version of TreeCache make the preload before configuring the LRUPolicy. And cause the npe. It seems to be corrected in the TreeCache.java revision 1.6 in cvs Try to update your TreeCache version Regards, Nicolas PERIDONT View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3875579#3875579 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3875579 --- SF.Net email is sponsored by: Tell us your software development plans! Take this survey and enter to win a one-year sub to SourceForge.net Plus IDC's 2005 look-ahead and a copy of this survey Click here to start! http://www.idcswdc.com/cgi-bin/survey?id=105hix ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBossCache] - Re: JDBCCacheLoader feature
when using LRUPolicy as eviction policy I get the next exception : Caused by: java.lang.NullPointerException at org.jboss.cache.eviction.LRUPolicy.nodeVisited(LRUPolicy.java:100) at org.jboss.cache.TreeCache.notifyNodeVisisted(TreeCache.java:3208) at org.jboss.cache.TreeCache._get(TreeCache.java:1657) I'm using JBoss 4.0.1 my config is : jboss:service=Naming jboss:service=TransactionManager DBTablesCache LOCAL TreeCache-Cluster 5000 1 15000 org.jboss.cache.eviction.LRUPolicy 5 5000 1000 10 0 true org.jboss.cache.loader.JDBCCacheLoader true / false false cache.jdbc.table.name=subscribers cache.jdbc.fqn.column=MSISDN cache.jdbc.fqn.type=VARCHAR2(15) cache.jdbc.node.column=USER_SUB_ID1 cache.jdbc.node.type=VARCHAR2(30) cache.jdbc.node.column=USER_SUB_ID2 cache.jdbc.node.type=VARCHAR2(30) cache.jdbc.parent.column=MSISDN cache.jdbc.datasource=java:/OracleDS View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3873074#3873074 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3873074 --- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBossCache] - Re: JDBCCacheLoader feature
when using LRUPolicy as eviction policy I get the next exception : Caused by: java.lang.NullPointerException at org.jboss.cache.eviction.LRUPolicy.nodeVisited(LRUPolicy.java:100) at org.jboss.cache.TreeCache.notifyNodeVisisted(TreeCache.java:3208) at org.jboss.cache.TreeCache._get(TreeCache.java:1657) I'm using JBoss 4.0.1 my config is : jboss:service=Naming jboss:service=TransactionManager DBTablesCache LOCAL TreeCache-Cluster 5000 1 15000 org.jboss.cache.eviction.LRUPolicy 5 5000 1000 10 0 true org.jboss.cache.loader.JDBCCacheLoader true / false false cache.jdbc.table.name=subscribers cache.jdbc.fqn.column=MSISDN cache.jdbc.fqn.type=VARCHAR2(15) cache.jdbc.node.column=USER_SUB_ID1 cache.jdbc.node.type=VARCHAR2(30) cache.jdbc.node.column=USER_SUB_ID2 cache.jdbc.node.type=VARCHAR2(30) cache.jdbc.parent.column=MSISDN cache.jdbc.datasource=java:/OracleDS View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3873076#3873076 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3873076 --- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBossCache] - Re: JDBCCacheLoader feature
Look into your table schema, check for a PARENT column View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3873065#3873065 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3873065 --- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBossCache] - Re: JDBCCacheLoader feature
I tried to configure the JDBCCacheLoader with the next params : org.jboss.cache.loader.JDBCCacheLoader true / false false cache.jdbc.table.name=subscribers cache.jdbc.fqn.column=MSISDN cache.jdbc.fqn.type=VARCHAR2(15) cache.jdbc.node.column=USER_SUB_ID1 cache.jdbc.node.type=VARCHAR2(30) cache.jdbc.node.column=USER_SUB_ID2 cache.jdbc.node.type=VARCHAR2(30) cache.jdbc.datasource=java:/OracleDS and it threw the next exception : 2005-04-07 16:09:21,598 ERROR [org.jboss.cache.loader.JDBCCacheLoader] Failed to get children names for fqn / java.sql.SQLException: ORA-00904: "PARENT": invalid identifier why is that ? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3873049#3873049 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3873049 --- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBossCache] - Re: JDBCCacheLoader feature
Yes, I think you could easily create a subclass and fetch the data source from there View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3872831#3872831 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3872831 --- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBossCache] - Re: JDBCCacheLoader feature
OK , I guess I can generate some workaround Thanks :-) View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3872829#3872829 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3872829 --- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBossCache] - Re: JDBCCacheLoader feature
Currently scheduled for 1.3, but it may spill over to 1.4, b/c this is a low priority issue View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3872754#3872754 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3872754 --- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBossCache] - Re: JDBCCacheLoader feature
Great !!! :-) will it be on 1.3 release ? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3872530#3872530 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3872530 --- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBossCache] - Re: JDBCCacheLoader feature
No, but I will add a method soon to configure JDBCCacheLoader from a DataSource. You'd be able to set it every 5 minutes I guess View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3872527#3872527 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3872527 --- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBossCache] - Re: JDBCCacheLoader feature
10x :-) I need to retrieve values from my Data Source into the cache every 5 minutes (because my DataSource is changed from other source) . Can I configure this in my xml configuration file ? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3872519#3872519 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3872519 --- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBossCache] - Re: JDBCCacheLoader feature
looks right, I wouldn't drop the table though View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3872484#3872484 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3872484 --- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBossCache] - Re: JDBCCacheLoader feature
Thanks for your reply :-) So lets say I have table named USER , with columns PHONE_NUMBER , ADDRESS and ID (as key). Then the CacheLoaderConfig will look like this ? cache.jdbc.table.name=USER cache.jdbc.table.create=true cache.jdbc.table.drop=true cache.jdbc.fqn.column=ID cache.jdbc.fqn.type=varchar(255) cache.jdbc.node.column=PHONE_NUMBER cache.jdbc.node.type=VARCHAR(10) cache.jdbc.node.column=ADDRESS cache.jdbc.node.type=VARCHAR(10) cache.jdbc.parent.column=parent View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3872474#3872474 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3872474 --- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
