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

[Yong Hao Gao (JIRA)]

     [ https://jira.jboss.org/browse/JBMESSAGING-1824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yong Hao Gao closed JBMESSAGING-1824.
-------------------------------------

    Fix Version/s: 1.4.0.SP3.CP11
                   1.4.8.GA
                       (was: EAP/SOA-P Integration)
       Resolution: Done


> "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: 1.4.0.SP3.CP11, 1.4.8.GA
>
>
> 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