"sybase-persistence-service.xml" does not work with Sybase.
-----------------------------------------------------------
Key: JBMESSAGING-1824
URL:
https://jira.jboss.org/browse/JBMESSAGING-1824
Project: JBoss Messaging
Issue Type: Bug
Affects Versions: 1.4.7.GA
Environment: SOA 5.1.0 ER3 (EAP 5.1.0 GA)
Reporter: Julian Coleman
Fix For: EAP/SOA-P Integration
Using the supplied:
sybase-persistence-service.xml
file with Sybase 15 causes errors of the form:
2010-10-26 13:15:13,460 DEBUG [org.jboss.jms.server.plugin.JDBCJMSUserManager] (main)
Failed to execute INSERT INTO JBM_USER (USER_ID, PASSWD) VALUES ('guest',
'guest')
com.sybase.jdbc4.jdbc.SybSQLException: The column CLIENTID in table JBM_USER does not
allow null values.
and the entries in the "JBM_USER" table that have no "CLIENTID"
defined are not inserted into the database.
At runtime, this causes errors of the form:
org.jboss.resource.JBossResourceException: Unable to setup connection; - nested
throwable: (javax.jms.JMSSecurityException: User guest is NOT authenticated)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira