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.