[jboss-jira] [JBoss JIRA] Closed: (JBMESSAGING-525) postgresql-persistence-service.xml contains invalid SQL syntax

[Clebert Suconic (JIRA)]

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

Clebert Suconic closed JBMESSAGING-525.
---------------------------------------

    Resolution: Done

> postgresql-persistence-service.xml contains invalid SQL syntax
> --------------------------------------------------------------
>
>                 Key: JBMESSAGING-525
>                 URL: http://jira.jboss.com/jira/browse/JBMESSAGING-525
>             Project: JBoss Messaging
>          Issue Type: Bug
>          Components: Configuration and Management
>    Affects Versions: 1.0.1.CR4
>         Environment: JBoss 4.0.4.GA, JBoss Messaging 1.0.1.CR4, PostgreSQL 8.1
>            Reporter: Takayoshi Kimura
>         Assigned To: Clebert Suconic
>             Fix For: 1.0.1.CR5, 1.2.0.Beta1
>
>         Attachments: postgresql-persistence-service.xml.patch
>
>          Time Spent: 2 hours
>  Remaining Estimate: 0 minutes
>
> The UPDATE_UNRELIABLE_CHANNELCOUNT SQL in postgresql-persistence-service.xml uses "UPDATE tablename alias" syntax but PostgreSQL does not support this syntax.
> http://www.postgresql.org/docs/8.1/static/sql-update.html
> http://www.postgresql.org/docs/7.4/static/sql-update.html
> To fix this, simply remove the aliases from the SQL.

-- 
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