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

[Clebert Suconic (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBMESSAGING-525?page=comments#action_12343512 ] 
            
Clebert Suconic commented on JBMESSAGING-525:
---------------------------------------------

I have tested this basically by deploying a postgres datasource on a JBoss 4.0 and didn't find any issues.

The SQL look ok to me also, since I have a lot of experience with SQL.


So, the patch was applied.

> 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.2.0.Beta1, 1.0.1.CR5
>
>         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