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=bbop=viewtopicp=3867837#3867837
Reply to the post :
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=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=6595alloc_id=14396op=click
___
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user