[jboss-jira] [JBoss JIRA] Created: (JBAS-4230) Be explicit about allowing NULL in the JBossMQ JDBC configuration

[Adrian Brock (JIRA)]

Be explicit about allowing NULL in the JBossMQ JDBC configuration
-----------------------------------------------------------------

                 Key: JBAS-4230
                 URL: http://jira.jboss.com/jira/browse/JBAS-4230
             Project: JBoss Application Server
          Issue Type: Sub-task
      Security Level: Public (Everyone can see)
          Components: JMS service
    Affects Versions: JBossAS-4.2.0.CR1
            Reporter: Adrian Brock
         Assigned To: Adrian Brock
             Fix For: JBossAS-5.0.0.Beta2, JBossAS-4.2.0.GA, JBossAS-4.0.5.SP1 


Comment from super task:
"Also, If you omit null or not null in the create table statement, Adaptive Server uses the null mode defined for the database (by default, NOT NULL).

Hence while creating the JMS_USERS table, and inserting users, i get this error.
The column CLIENTID in table JMS_USERS does not allow null values.

CREATE TABLE JMS_USERS (USERID VARCHAR(32) NOT NULL, PASSWD VARCHAR(32) NOT NULL, CLIENTID VARCHAR(128), PRIMARY KEY(USERID))
INSERT INTO JMS_USERS (USERID, PASSWD) VALUES ('guest', 'guest')

Either we need to update the sql in which case we need to provide a separate sybase-jdbc-state-service.xml?

Or I can set this on the sybase database.
sp_dboption db_name, "allow nulls by default", true

I am following the 2nd option. 
"

So we need to explicity say which columns allow NULL.

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