[JBoss JIRA] Created: (JBMESSAGING-525) postgresql-persistence-service.xml contains invalid SQL syntax
8:53 a.m.
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
8:53 a.m.
New subject: [JBoss JIRA] Updated: (JBMESSAGING-525) postgresql-persistence-service.xml contains invalid SQL syntax
[ http://jira.jboss.com/jira/browse/JBMESSAGING-525?page=all ]
Takayoshi Kimura updated JBMESSAGING-525:
-----------------------------------------
Attachment: postgresql-persistence-service.xml.patch
Patch for svn /messaging/trunk.
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
4:34 p.m.
New subject: [JBoss JIRA] Updated: (JBMESSAGING-525) postgresql-persistence-service.xml contains invalid SQL syntax
[ http://jira.jboss.com/jira/browse/JBMESSAGING-525?page=all ]
Ovidiu Feodorov updated JBMESSAGING-525:
----------------------------------------
Fix Version/s: 1.0.1.CR5
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
Fix For: 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
12:59 p.m.
New subject: [JBoss JIRA] Updated: (JBMESSAGING-525) postgresql-persistence-service.xml contains invalid SQL syntax
[ http://jira.jboss.com/jira/browse/JBMESSAGING-525?page=all ]
Ovidiu Feodorov updated JBMESSAGING-525:
----------------------------------------
Assignee: Clebert Suconic (was: Ovidiu Feodorov)
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
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
4:49 p.m.
New subject: [JBoss JIRA] Commented: (JBMESSAGING-525) postgresql-persistence-service.xml contains invalid SQL syntax
[ http://jira.jboss.com/jira/browse/JBMESSAGING-525?page=comments#action_12... ]
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
4:49 p.m.
New subject: [JBoss JIRA] Closed: (JBMESSAGING-525) postgresql-persistence-service.xml contains invalid SQL syntax
[ 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
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
4:49 p.m.
New subject: [JBoss JIRA] Closed: (JBMESSAGING-525) postgresql-persistence-service.xml contains invalid SQL syntax
[ 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
4:49 p.m.
New subject: [JBoss JIRA] Updated: (JBMESSAGING-525) postgresql-persistence-service.xml contains invalid SQL syntax
[ http://jira.jboss.com/jira/browse/JBMESSAGING-525?page=all ]
Clebert Suconic updated JBMESSAGING-525:
----------------------------------------
Fix Version/s: 1.2.0.Beta1
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
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
4:49 p.m.
New subject: [JBoss JIRA] Reopened: (JBMESSAGING-525) postgresql-persistence-service.xml contains invalid SQL syntax
[ http://jira.jboss.com/jira/browse/JBMESSAGING-525?page=all ]
Clebert Suconic reopened JBMESSAGING-525:
-----------------------------------------
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
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
2:41 p.m.
New subject: [JBoss JIRA] Reopened: (JBMESSAGING-525) postgresql-persistence-service.xml contains invalid SQL syntax
[ http://jira.jboss.com/jira/browse/JBMESSAGING-525?page=all ]
Ovidiu Feodorov reopened JBMESSAGING-525:
-----------------------------------------
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.Alpha1
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
2:41 p.m.
New subject: [JBoss JIRA] Updated: (JBMESSAGING-525) postgresql-persistence-service.xml contains invalid SQL syntax
[ http://jira.jboss.com/jira/browse/JBMESSAGING-525?page=all ]
Ovidiu Feodorov updated JBMESSAGING-525:
----------------------------------------
Fix Version/s: 1.2.0.Alpha1
(was: 1.0.1.CR5)
(was: 1.2.0.Beta1)
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.Alpha1
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
2:41 p.m.
New subject: [JBoss JIRA] Closed: (JBMESSAGING-525) postgresql-persistence-service.xml contains invalid SQL syntax
[ http://jira.jboss.com/jira/browse/JBMESSAGING-525?page=all ]
Ovidiu Feodorov closed JBMESSAGING-525.
---------------------------------------
Resolution: Done
shited up to Alpha1
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.Alpha1
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
7176
days inactive
7215
days old
11 comments
3 participants
participants (3)
-
Clebert Suconic (JIRA) -
Ovidiu Feodorov (JIRA)
-
Takayoshi Kimura (JIRA)