Hi All, I have been testing JDBCCacheLoader with various DBMs, particularly, MySQL Versions (3.23.58, 4.1.1.0a-Max, 5.0.16), Oracle versions (9i release 2, 10g release 2), and PostgreSQL 8.1. I have found that you don't need to change any code to make it work with MySQL or any other DBMS for that matter.
The reason that you've got this NPE is the size of the object you're trying to store in the cache. If the size of the node is greater than 65k then you'll get this exception thrown. MySQL data type for the data type of blob greater 65k must be defined as MEDIUMBLOB or LONGBLOB. If you need a bigger store for your larger objects, you can add the following line to your JDBCCacheLoader configuration file cache.node.type=LONGBLOB. see etc/jdbcCacheLoader-service.xml for example of that configuration. Also, I'd recommand to view the data types in MySQL documentation @ http://dev.mysql.com/doc/refman/5.0/en/data-types.html to see the requirements for different data types in MySQL. I'm also in the process of creating a wiki page to include all the various dbms mentioned above test condtions to cover all the caveats in using JDBCCacheLoader. Cheers, H. Mesha View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3913606#3913606 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3913606 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
