This content has been marked as final.
Show 1 reply
-
1. Re: JDBCCacheLoaderTestCase and Informix persistance
jlukar Dec 14, 2005 3:02 PM (in response to jlukar)
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"