[jboss-user] [JBoss Portal] - SQL Exception using PostgreSQL

[xevi]

When I start jboss server JBoss Portal 2.7.0 + JBoss AS 4.2.3 (only one zip) configured with PostgreSQL, I allways get the same PSQLException:

11:20:18,153 WARN  [ServiceController] Problem starting service jboss.mq:service=PersistenceManager                                            
org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions.  Message recovery may not be accurate; - nested throwable: (org.postgresql.util.PSQLException: ERROR: syntax error at or near "TXID")                                                                                
        at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:489)                                       
        at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1842)   

I think "TXID" must be a reserved word in Postgresql.

Describe your environment:
JBoss Portal Version 2.7.0 (jboss-portal-2.7.0.GA-bundled.zip)
Did you get Portal from Subversion? or download it? I download it
JBoss AS Version 4.2.3
Database Vendor and Version Postgresql 8.3.5
JDBC Connector and Version JDBC4 Postgresql Driver, Version 8.3-604
OS Platform Ubuntu Linux
JVM:
 -  xevi at chaos:~/apps/jboss-portal-2.7.0.GA/bin$ java -version
 -  java version "1.6.0_11"
 -  Java(TM) SE Runtime Environment (build 1.6.0_11-b03)
 -  Java HotSpot(TM) Client VM (build 11.0-b16, mixed mode, sharing)

I test it using a 1.5 JVM and I the problem was the same. The problem may be in the database lebel, not in java virtual machine.

Whem I log in PostgreSQL, I can see the following tables:

xevi-# \dt
             List of relations
 Schema |       Name        | Type  | Owner
--------+-------------------+-------+-------
 public | hilosequences     | table | xevi
 public | jms_roles         | table | xevi
 public | jms_subscriptions | table | xevi
 public | jms_users         | table | xevi
 public | timers            | table | xevi

I am evaluating JBossPortal with hsqldb (default database) and I want use PostgreSQL in production. Everything is perfect except this problem with my favourite database.

Regards,

Xevi.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4199710#4199710

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4199710