Uploaded image for project: 'JBoss Enterprise Application Platform 4 and 5'
  1. JBoss Enterprise Application Platform 4 and 5
  2. JBPAPP-5349

Issue in JBoss Messaging sybase-persistence-service.xml example file

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 4.3.0.GA_CP09
    • 4.3.0.GA_CP09
    • Messaging
    • None
    • Not Required

      We found issue in the persistence configuration file for JMS which is distributed with EAP. Issue is located in jboss-as/docs/examples/jms/sybase-persistence-service.xml. Issue is located in JDBCJMSUserManagerService MBean configuration. Current value of CREATE_USER_TABLE sql statement is CREATE TABLE JBM_USER (USER_ID VARCHAR(32) NOT NULL, PASSWD VARCHAR(32) NOT NULL, CLIENTID VARCHAR(128), PRIMARY KEY(USER_ID)). This SQL statement creates table with CLIENTID IS_NULLABLE=NO. But POPULATE.TABLES.x statements (except value 3) insert only 2 values into the row.

      Error message: The column CLIENTID in table JBM_USER does not allow null values.

      CREATE_USER_TABLE SQL statement should be updated to:
      CREATE TABLE JBM_USER (USER_ID VARCHAR(32) NOT NULL, PASSWD VARCHAR(32) NOT NULL, CLIENTID VARCHAR(128) NULL, PRIMARY KEY(USER_ID))

      This SQL statement creates table with CLIENTID IS_NULLABLE=YES and all example data will be inserted into database.

              mnovak1@redhat.com Miroslav Novak
              pslavice@redhat.com Pavel Slavicek
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: