-
Bug
-
Resolution: Done
-
Major
-
4.3.0.GA_CP09
-
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.
- blocks
-
JBPAPP-5296 Upgrade JBM to 1.4.0.SP3_CP11
- Closed
- duplicates
-
JBPAPP-5319 JMS "sybase-persistence-service.xml" does not work with Sybase.
- Closed