[jboss-jira] [JBoss JIRA] Updated: (JBMESSAGING-683) MSSQL configuration appears invalid

[Markus Lutum (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBMESSAGING-683?page=all ]

Markus Lutum updated JBMESSAGING-683:
-------------------------------------

                  Summary: MSSQL configuration appears invalid  (was: CLONE -MSSQL configuration appears invalid)
    JBoss Forum Reference:   (was: http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3975994#3975994)
        Affects Version/s: 1.2.0.Alpha1
                               (was: 1.0.1.CR5)
              Description: 
The MSSQL persistence manager config appears to be invalid.

One call inside the mssql-persistence-service.xml must be changed

UPDATE_UNRELIABLE_CHANNELCOUNT=UPDATE JMS_MESSAGE M SET M.CHANNELCOUNT = M.CHANNELCOUNT - 1 WHERE M.MESSAGEID IN (SELECT MR.MESSAGEID FROM JMS_MESSAGE_REFERENCE MR WHERE MR.RELIABLE = 'N' AND MR.CHANNELID = ?)

should be
UPDATE_UNRELIABLE_CHANNELCOUNT=UPDATE JMS_MESSAGE  SET CHANNELCOUNT = CHANNELCOUNT - 1 WHERE MESSAGEID IN (SELECT MR.MESSAGEID FROM JMS_MESSAGE_REFERENCE MR WHERE MR.RELIABLE = 'N' AND MR.CHANNELID = ?)

(without M)


  was:
The MSSQL persistence manager config appears to be invalid.

This needs to be tested with the entire functional tests suite.


> MSSQL configuration appears invalid
> -----------------------------------
>
>                 Key: JBMESSAGING-683
>                 URL: http://jira.jboss.com/jira/browse/JBMESSAGING-683
>             Project: JBoss Messaging
>          Issue Type: Bug
>    Affects Versions: 1.2.0.Alpha1
>            Reporter: Markus Lutum
>         Assigned To: Clebert Suconic
>             Fix For: 1.0.1.GA
>
>
> The MSSQL persistence manager config appears to be invalid.
> One call inside the mssql-persistence-service.xml must be changed
> UPDATE_UNRELIABLE_CHANNELCOUNT=UPDATE JMS_MESSAGE M SET M.CHANNELCOUNT = M.CHANNELCOUNT - 1 WHERE M.MESSAGEID IN (SELECT MR.MESSAGEID FROM JMS_MESSAGE_REFERENCE MR WHERE MR.RELIABLE = 'N' AND MR.CHANNELID = ?)
> should be
> UPDATE_UNRELIABLE_CHANNELCOUNT=UPDATE JMS_MESSAGE  SET CHANNELCOUNT = CHANNELCOUNT - 1 WHERE MESSAGEID IN (SELECT MR.MESSAGEID FROM JMS_MESSAGE_REFERENCE MR WHERE MR.RELIABLE = 'N' AND MR.CHANNELID = ?)
> (without M)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira