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

[Roger Dudler (JIRA)]

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))

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira