BTW: I can send large messages with the
org.jboss.mq.pm.file.PersistenceManager setup.

> -----Original Message-----
> From: Sebastian Hauer 
> Sent: Monday, November 18, 2002 1:13 PM
> To: [EMAIL PROTECTED]
> 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)
>         at org.hsqldb.jdbcConnection.execute(jdbcConnection.java:718)
>         at 
> org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:686)
>         at 
> org.hsqldb.jdbcStatement.executeUpdate(jdbcStatement.java:85)
>         at 
> org.hsqldb.jdbcPreparedStatement.executeUpdate(jdbcPreparedStatement.
> java:152)
>         at 
> org.jboss.resource.adapter.jdbc.local.LocalPreparedStatement.executeU
> pdate(LocalPreparedStatement.java:308)
>         at
> org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:
> 758)
>         at
> org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:
> 667)
>         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)
> 12:20:57,182 WARN  [jbossweb] WARNING: Exception for 
> /jmx-console/HtmlAdaptor
> MBeanException: Exception in MBean operation 
> 'sendToTopicXMessagesYSize(,int,int
> )'
> Cause: org.jboss.mq.SpyJMSException: Could not store message: 
> 238; - nested thro
> wable: (java.sql.SQLException: Connection is broken)
>         at 
> org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea
> nDispatcher.java:303)
>         at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
>         at
> org.jboss.jmx.adaptor.control.Server.invokeOpByName(Server.java:227)
>         at
> org.jboss.jmx.adaptor.control.Server.invokeOp(Server.java:196)
>         at 
> org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.invokeOp(HtmlAdaptorSer
> vlet.java:183)
>         at 
> org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.processRequest(HtmlAdap
> torServlet.java:78)
>         at 
> org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.doPost(HtmlAdaptorServl
> et.java:60)
>         at 
> javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
>         at 
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>         at 
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:366
> )
>         at 
> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicati
> onHandler.java:293)
>         at 
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:5
> 81)
>         at org.mortbay.http.HttpContext.handle(HttpContext.java:1687)
>         at 
> org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplication
> Context.java:544)
>         at org.mortbay.http.HttpContext.handle(HttpContext.java:1637)
>         at org.mortbay.http.HttpServer.service(HttpServer.java:875)
>         at org.jboss.jetty.Jetty.service(Jetty.java:543)
>         at
> org.mortbay.http.HttpConnection.service(HttpConnection.java:806)
>         at
> org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:956)
>         at
> org.mortbay.http.HttpConnection.handle(HttpConnection.java:823)
>         at
> org.mortbay.http.SocketListener.handleConnection(SocketListener.java:
> 203)
>         at
> org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:290)
>         at
> org.mortbay.util.ThreadPool$JobRunner.run(ThreadPool.java:743)
>         at java.lang.Thread.run(Thread.java:484)
>  + nested throwable:
> org.jboss.mq.SpyJMSException: Could not store message: 238; - nested
> throwable:
> (java.sql.SQLException: Connection is broken)
>         <<no stack trace available>>
>  + nested throwable: java.sql.SQLException: Connection is broken
>         <<no stack trace available>>
> getTargetException():
> org.jboss.mq.SpyJMSException: Could not store message: 238; - nested
> throwable:
> (java.sql.SQLException: Connection is broken)
>         <<no stack trace available>>
>  + nested throwable: java.sql.SQLException: Connection is broken
>         <<no stack trace available>> 
> 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)
>         at org.hsqldb.jdbcConnection.execute(jdbcConnection.java:718)
>         at 
> org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:686)
>         at 
> org.hsqldb.jdbcStatement.executeUpdate(jdbcStatement.java:85)
>         at 
> org.hsqldb.jdbcPreparedStatement.executeUpdate(jdbcPreparedStatement.
> java:152)
>         at 
> org.jboss.resource.adapter.jdbc.local.LocalPreparedStatement.executeU
> pdate(LocalPreparedStatement.java:308)
>         at
> org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:
> 758)
>         at
> org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:
> 667)
>         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)
> 12:20:57,182 WARN  [jbossweb] WARNING: Exception for 
> /jmx-console/HtmlAdaptor
> MBeanException: Exception in MBean operation 
> 'sendToTopicXMessagesYSize(,int,int
> )'
> Cause: org.jboss.mq.SpyJMSException: Could not store message: 
> 238; - nested thro
> wable: (java.sql.SQLException: Connection is broken)
>         at 
> org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea
> nDispatcher.java:303)
>         at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
>         at
> org.jboss.jmx.adaptor.control.Server.invokeOpByName(Server.java:227)
>         at
> org.jboss.jmx.adaptor.control.Server.invokeOp(Server.java:196)
>         at 
> org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.invokeOp(HtmlAdaptorSer
> vlet.java:183)
>         at 
> org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.processRequest(HtmlAdap
> torServlet.java:78)
>         at 
> org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.doPost(HtmlAdaptorServl
> et.java:60)
>         at 
> javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
>         at 
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>         at 
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:366
> )
>         at 
> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicati
> onHandler.java:293)
>         at 
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:5
> 81)
>         at org.mortbay.http.HttpContext.handle(HttpContext.java:1687)
>         at 
> org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplication
> Context.java:544)
>         at org.mortbay.http.HttpContext.handle(HttpContext.java:1637)
>         at org.mortbay.http.HttpServer.service(HttpServer.java:875)
>         at org.jboss.jetty.Jetty.service(Jetty.java:543)
>         at
> org.mortbay.http.HttpConnection.service(HttpConnection.java:806)
>         at
> org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:956)
>         at
> org.mortbay.http.HttpConnection.handle(HttpConnection.java:823)
>         at
> org.mortbay.http.SocketListener.handleConnection(SocketListener.java:
> 203)
>         at
> org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:290)
>         at
> org.mortbay.util.ThreadPool$JobRunner.run(ThreadPool.java:743)
>         at java.lang.Thread.run(Thread.java:484)
>  + nested throwable:
> org.jboss.mq.SpyJMSException: Could not store message: 238; - nested
> throwable:
> (java.sql.SQLException: Connection is broken)
>         <<no stack trace available>>
>  + nested throwable: java.sql.SQLException: Connection is broken
>         <<no stack trace available>>
> getTargetException():
> org.jboss.mq.SpyJMSException: Could not store message: 238; - nested
> throwable:
> (java.sql.SQLException: Connection is broken)
>         <<no stack trace available>>
>  + nested throwable: java.sql.SQLException: Connection is broken
>         <<no stack trace available>>
> --------------------------------------------------------------
> ----------
> -----------
> 
> Is this a bug in the jdbc2 persistence manager?
> 
> Regards,
> 
> Sebastian
> 
> 
> -------------------------------------------------------
> 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/j> boss-user
> 


-------------------------------------------------------
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

Reply via email to