I am running the provided org.jboss.cache.loader.JDBCCacheLoaderTestCase and trying to test this out with Informix database.
The current test case assumes a mysql database. I simply plugged in my informix database settings and tried the test and get the following error: | java.sql.SQLException: A syntax error has occurred. | at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:355) | at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3086) | at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3396) | at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2259) | at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2179) | at com.informix.jdbc.IfxSqli.executeCommand(IfxSqli.java:721) | at com.informix.jdbc.IfxResultSet.executeUpdate(IfxResultSet.java:305) | at com.informix.jdbc.IfxStatement.executeUpdateImpl(IfxStatement.java:882) | at com.informix.jdbc.IfxStatement.executeUpdate(IfxStatement.java:206) | at org.jboss.cache.loader.JDBCCacheLoader.start(JDBCCacheLoader.java:718) | at org.jboss.cache.TreeCache.startService(TreeCache.java:1261) | at org.jboss.cache.loader.CacheLoaderTestsBase.setUp(CacheLoaderTestsBase.java:46) | at com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31) | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78) | | I don't see any special sql scripts that setup the schema so I am assuming that the cache.startService() takes care of setting up the schema for persistance. Can someone tell me what is going on ? I suspect, whatever sql is used to setup the schema is not compatible with Informix syntax. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3912679#3912679 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3912679 ------------------------------------------------------- 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