Hi, most probably your have an hsqldb-jdbc2-state-service.xml file lying around
in or beneath your deploy/ directory (probably deploy/jms). The SQL code it is
failing on is the CREATE CACHED TABLE - so far as I know postgres does not
support the CACHED keyword in this context.
In my server.log (you should have the same indicator to the smoking gun here) :
2007-09-02 10:51:11,622 DEBUG [org.jboss.mq.pm.jdbc2.PersistenceManager] Could
not create table with SQL: CREATE CACHED TABLE JMS_MESSAGES ( MESSAGEID INTEGER
NOT NULL, DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER, TXOP CHAR(1),
MESSAGEBLOB OBJECT, PRIMARY KEY (MESSAGEID, DESTINATION) )
| org.postgresql.util.PSQLException: ERROR: syntax error at or near "CACHED"
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
| ...<snip>
|
Don't ask me why this is different to the INFO log output which reports
10:51:11,634 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")
Kind regards,
ROb
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4080284#4080284
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4080284
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
