[jboss-jira] [JBoss JIRA] Closed: (JBMESSAGING-1154) DB2 persistence service example contains invalid SQL query

DB2 persistence service example contains invalid SQL query ---------------------------------------------------------- Key: JBMESSAGING-1154 URL: http://jira.jboss.com/jira/browse/JBMESSAGING-1154 Project: JBoss Messaging Issue Type: Bug Components: Documentation and Training Affects Versions: 1.4.0.SP1 Reporter: Roger Dudler Assigned To: Tim Fox In the db2-persistence-service.xml, there's an invalid create table statement, where some "NOT NULL" parameters are not set. Line 115 CREATE_POSTOFFICE_TABLE=CREATE TABLE JBM_POSTOFFICE (POSTOFFICE_NAME VARCHAR(255), NODE_ID INTEGER, QUEUE_NAME VARCHAR(255), COND VARCHAR(1023), SELECTOR VARCHAR(1023), CHANNEL_ID BIGINT, CLUSTERED CHAR(1), ALL_NODES CHAR(1), PRIMARY KEY(POSTOFFICE_NAME, NODE_ID, QUEUE_NAME)) should be CREATE_POSTOFFICE_TABLE=CREATE TABLE JBM_POSTOFFICE (POSTOFFICE_NAME VARCHAR(255) NOT NULL, NODE_ID INTEGER NOT NULL, QUEUE_NAME VARCHAR(255) NOT NULL, COND VARCHAR(1023), SELECTOR VARCHAR(1023), CHANNEL_ID BIGINT, CLUSTERED CHAR(1), ALL_NODES CHAR(1), PRIMARY KEY(POSTOFFICE_NAME, NODE_ID, QUEUE_NAME))