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

[Takayoshi Kimura (JIRA)]

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: Ovidiu Feodorov
         Attachments: postgresql-persistence-service.xml.patch

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