Hi. I know that this question has been posted a great number of times. But for the life of me I haven't been able to see what could be wrong in my case.
I've gone to the READ THIS FIRST section and I've set the TRACE logging for org.jboss.mq, org.jboss.logging.XLevel and org.jboss.logging.XLevel. I looked for any SQL related exception, and this is what I found: 2005-02-24 17:13:58,578 DEBUG [org.jboss.mq.pm.jdbc2.PersistenceManager] Resolving uncommited TXS 2005-02-24 17:13:59,343 ERROR [STDERR] java.io.EOFException 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.DatabaseFile.readInteger(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Cache.makeRow(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Cache.getRow(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Table.setIndexRoots(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Table.setIndexRoots(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Database.processSet(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Database.execute(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Log.runScript(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Log.open(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Database$Logger.openLog(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Database.open(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Database.(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Server.openDB(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Server.run(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Server.main(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.jboss.jdbc.HypersonicDatabase$2.run(HypersonicDatabase.java:250) 2005-02-24 17:13:59,343 INFO [STDOUT] Server.run/init: java.sql.SQLException: File input/output error: File input/output error: reading: java.io.EOFException in statement [SET TABLE JMS_MESSAGES INDEX '19640 8'] 2005-02-24 17:13:59,343 ERROR [STDERR] java.sql.SQLException: File input/output error: File input/output error: reading: java.io.EOFException in statement [SET TABLE JMS_MESSAGES INDEX '19640 8'] 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Trace.getError(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Log.runScript(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Log.open(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Database$Logger.openLog(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Database.open(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Database.(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Server.openDB(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Server.run(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Server.main(Unknown Source) 2005-02-24 17:13:59,343 ERROR [STDERR] at org.jboss.jdbc.HypersonicDatabase$2.run(HypersonicDatabase.java:250) 2005-02-24 17:13:59,546 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Connection is broken: Connection refused: connect) . . . I'm working exclusively with Queues and I'm persisting them in Hypersonic. I've read that the problem could be with durable subscriptions, is the procedure the same for Queues as it is for Topics? I truly appreciate any help I can get. I know that you might need more information regarding my configuration but I truly don't know what would be relevant and what wouldn't. Please let me know. Thank you. P.S. By the way, if I erase any reference to the JMS tables from the hypersonic scripts, I get a clean startup. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3867837#3867837 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3867837 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
