Author: manik.surtani(a)jboss.com Date: 2009-02-12 08:51:27 -0500 (Thu, 12 Feb 2009) New Revision: 7684 Modified: core/trunk/src/main/java/org/jboss/cache/loader/AdjListJDBCCacheLoaderConfig.java Log: JBCACHE-1477: Bug in JDBC cache loader SQL on Informix Modified: core/trunk/src/main/java/org/jboss/cache/loader/AdjListJDBCCacheLoaderConfig.java =================================================================== --- core/trunk/src/main/java/org/jboss/cache/loader/AdjListJDBCCacheLoaderConfig.java 2009-02-11 17:13:41 UTC (rev 7683) +++ core/trunk/src/main/java/org/jboss/cache/loader/AdjListJDBCCacheLoaderConfig.java 2009-02-12 13:51:27 UTC (rev 7684) @@ -479,8 +479,9 @@ private String constructCreateTableDDL() { + // removed CONSTRAINT clause as this causes problems with some databases, like Informix. return "CREATE TABLE " + table + "(" + fqnColumn + " " + fqnType + " NOT NULL, " + nodeColumn + " " + nodeType + - ", " + parentColumn + " " + fqnType + ", CONSTRAINT " + primaryKey + " PRIMARY KEY (" + fqnColumn + "))"; + ", " + parentColumn + " " + fqnType + ", PRIMARY KEY (" + fqnColumn + "))"; } @Override