This looks like hsqldb cannot handle this big of a store as it is the
jdbc driver that is bombing, not the persistence manager. I can find
any info on the limits for hsqldb 1.6.1 so you will have to experiment
to see if this is a limitation of the db.
xxxxxxxxxxxxxxxxxxxxxxxx
Scott Stark
Chief Technology Officer
JBoss Group, LLC
xxxxxxxxxxxxxxxxxxxxxxxx
----- Original Message -----
From: "Sebastian Hauer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 10:12 AM
Subject: [JBoss-user] jdbc2.PersistenceManager fails with large messages
Hi again,
Forgot a subject line in my first post...
Today I did some testing of the JBoss JMS implementation (JBoss 3.0.4)
and it seems it breaks using larger ObjectMessages. I setup a durable
subscriber account and had been listening to my test topic for new
messages. I've used the org.jboss.mq.pm.jdbc2.PersistenceManager. If I
send an object message with a payload of approximately 32224 bytes and
receive the following exception:
------------------------------------------------------------------------
-----------
12:20:56,948 INFO [UILServerILService] Client request resulted in a
server exce
ption:
org.jboss.mq.SpyJMSException: Could not store message: 238; - nested
throwable:
(java.sql.SQLException: Connection is broken)
at
org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:
680)
at
org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:4
1)
at org.jboss.mq.server.JMSTopic.addMessage(JMSTopic.java:265)
at
org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationMa
nager.java:398)
at
org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationMa
nager.java:376)
at
org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerI
nterceptorSupport.java:135)
at
org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecu
rityInterceptor.java:155)
at
org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor.
java:209)
at
org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java
:137)
at
org.jboss.mq.il.uil.UILServerILService.run(UILServerILService.java:26
4)
at java.lang.Thread.run(Thread.java:484)
+ nested throwable:
java.sql.SQLException: Connection is broken
at org.hsqldb.Trace.getError(Trace.java:180)
at org.hsqldb.Trace.getError(Trace.java:144)
at org.hsqldb.Trace.error(Trace.java:205)
at
org.hsqldb.jdbcConnection.executeHSQL(jdbcConnection.java:904)
-------------------------------------------------------
This sf.net email is sponsored by: To learn the basics of securing
your web site with SSL, click here to get a FREE TRIAL of a Thawte
Server Certificate: http://www.gothawte.com/rd524.html
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
