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

[Tim Fox (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBMESSAGING-1154?page=comments#action_12389109 ] 
            
Tim Fox commented on JBMESSAGING-1154:
--------------------------------------

The db2 config shouldn't be in the distro, since we haven't tested against DB2.

I've removed it.

> 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