I resolved issue, by debugging and tracing through the JDBCCacheLoader code.
It is the sql syntax that is different for mysql v.s. informix when creating persist table schema in DB. mysql syntax is: | create table jbosscache(fqn varchar(255) not null, node blob, parent varchar(255), constraint jbosscache_pk primary key (fqn)) | whereas infomix requires: | create table jbosscache(fqn varchar(255) not null, node blob, parent varchar(255), primary key (fqn) constraint jbosscache_pk ) | otherwise syntax error is propogated out of DB. Had to turn on "debug" View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3912710#3912710 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3912710 ------------------------------------------------------- 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 JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user