I'm still seeing this which means I can't run the smoke tests. The JBM_ID_CACHE should be created from the default ddl coming from hard coded defaults in the JDBCPersistenceManager: protected Map getDefaultDDLStatements() { Map<String, String> map = new LinkedHashMap<String, String>(); map.put("CREATE_DUAL", "CREATE TABLE JBM_DUAL (DUMMY INTEGER, PRIMARY KEY(DUMMY))"); // Message reference map.put("CREATE_MESSAGE_REFERENCE", "CREATE TABLE JBM_MSG_REF (MESSAGE_ID BIGINT, " + "CHANNEL_ID BIGINT, TRANSACTION_ID BIGINT, STATE CHAR(1), ORD BIGINT, PAGE_ORD BIGINT, " + "DELIVERY_COUNT INTEGER, SCHED_DELIVERY BIGINT, PRIMARY KEY(MESSAGE_ID, CHANNEL_ID))"); map.put("CREATE_IDX_MESSAGE_REF_TX", "CREATE INDEX JBM_MSG_REF_TX ON JBM_MSG_REF (TRANSACTION_ID, STATE)"); // Message map.put("CREATE_MESSAGE", "CREATE TABLE JBM_MSG (MESSAGE_ID BIGINT, RELIABLE CHAR(1), " + "EXPIRATION BIGINT, TIMESTAMP BIGINT, PRIORITY TINYINT, TYPE TINYINT, HEADERS LONGVARBINARY, " + "PAYLOAD LONGVARBINARY, " + "PRIMARY KEY (MESSAGE_ID))"); // Transaction map.put("CREATE_TRANSACTION", "CREATE TABLE JBM_TX (" + "NODE_ID INTEGER, TRANSACTION_ID BIGINT, BRANCH_QUAL VARBINARY(254), " + "FORMAT_ID INTEGER, GLOBAL_TXID VARBINARY(254), PRIMARY KEY (TRANSACTION_ID))"); // Counter map.put("CREATE_COUNTER", "CREATE TABLE JBM_COUNTER (NAME VARCHAR(255), NEXT_ID BIGINT, PRIMARY KEY(NAME))"); // Id cache map.put("CREATE_ID_CACHE", "CREATE TABLE JBM_ID_CACHE (NODE_ID INTEGER, CNTR INTEGER, JBM_ID VARCHAR(255), PRIMARY KEY(NODEID, CNTR))"); return map; } The CREATE_ID_CACHE statement is simply wrong as its primary key statement references the NODEID while the column is named NODE_ID: java.sql.SQLException: Column not found: NODEID in statement [CREATE TABLE JBM_ID_CACHE (NODE_ID INTEGER, CNTR INTEGER, JBM_ID VARCHAR(255), PRIMARY KEY(NODEID, CNTR)] I don't know what I'm missing for this to work correctly. I would assume the sql can be overriden via a descriptor, but I'm up to date as far as I can see. Dimitris Andreadis wrote: