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

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@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#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...