[jboss-jira] [JBoss JIRA] Created: (JBMESSAGING-1824) "sybase-persistence-service.xml" does not work with Sybase.

Thu Oct 28 11:08:54 EDT 2010

"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