Return-Path: Delivered-To: apmail-activemq-dev-archive@www.apache.org Received: (qmail 1024 invoked from network); 30 Mar 2007 10:47:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 30 Mar 2007 10:47:56 -0000 Received: (qmail 36834 invoked by uid 500); 30 Mar 2007 10:48:03 -0000 Delivered-To: apmail-activemq-dev-archive@activemq.apache.org Received: (qmail 36814 invoked by uid 500); 30 Mar 2007 10:48:03 -0000 Mailing-List: contact dev-help@activemq.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@activemq.apache.org Delivered-To: mailing list dev@activemq.apache.org Received: (qmail 36805 invoked by uid 99); 30 Mar 2007 10:48:03 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Mar 2007 03:48:03 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Mar 2007 03:47:54 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 9864D71406A for ; Fri, 30 Mar 2007 03:47:34 -0700 (PDT) Message-ID: <25657205.1175251654620.JavaMail.jira@brutus> Date: Fri, 30 Mar 2007 03:47:34 -0700 (PDT) From: "james strachan (JIRA)" To: dev@activemq.apache.org Subject: [jira] Resolved: (AMQ-1216) oracle jdbc adapter has issues storing messages greater than 64k In-Reply-To: <22843994.1175251054476.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/activemq/browse/AMQ-1216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] james strachan resolved AMQ-1216. --------------------------------- Resolution: Fixed Fix Version/s: 4.2.0 I think this is now resolved in trunk with commit: 524036 Its still awaiing testing; if it doesn't work for you let us know and we'll reopen this issue > oracle jdbc adapter has issues storing messages greater than 64k > ---------------------------------------------------------------- > > Key: AMQ-1216 > URL: https://issues.apache.org/activemq/browse/AMQ-1216 > Project: ActiveMQ > Issue Type: Bug > Components: Broker > Environment: --I'm using ojdbc14-10g-10.2.0.1.0.jar driver. > Reporter: james strachan > Fix For: 4.2.0 > > > destroy-method="close"> > value="oracle.jdbc.driver.OracleDriver"/> > > > > > > org.springframework.jms.UncategorizedJmsException: Uncategorized exception > occured during JMS processing; nested exception is javax.jms.JMSException: > Failed to broker message: ID:abc2-2257-1175204828244-0:8:1:1:1 in container: > java.sql.SQLException: Data size bigger than max size for this type: 63268 > Caused by: > javax.jms.JMSException: Failed to broker message: > ID:abc2-2257-1175204828244-0:8:1:1:1 in container: java.sql.SQLException: > Data size bigger than max size for this type: 63268 > at > org.apache.activemq.util.JMSExceptionSupport.create(JMSExceptionSupport.java:46) > at > org.apache.activemq.ActiveMQConnection.syncSendPacket(ActiveMQConnection.java:1177) > at org.apache.activemq.ActiveMQSession.send(ActiveMQSession.java:1548) > at > org.apache.activemq.ActiveMQMessageProducer.send(ActiveMQMessageProducer.java:465) > at > org.apache.activemq.ActiveMQMessageProducer.send(ActiveMQMessageProducer.java:356) > at org.springframework.jms.core.JmsTemplate.doSend(JmsTemplate.java:537) > at org.springframework.jms.core.JmsTemplate.doSend(JmsTemplate.java:513) > at org.springframework.jms.core.JmsTemplate$2.doInJms(JmsTemplate.java:479) > at org.springframework.jms.core.JmsTemplate.execute(JmsTemplate.java:430) > at org.springframework.jms.core.JmsTemplate.send(JmsTemplate.java:477) > at org.springframework.jms.core.JmsTemplate.send(JmsTemplate.java:469) > at > com.abc.jump.jdm.service.jms.AsynchronousTaskManagerImpl.createDeploymentTasks(AsynchronousTaskManagerImpl.java:67) > at > com.abc.jump.process.view.plan.wizard.DeploymentTasksWizard.createDeploymentTasksAsynchronously(DeploymentTasksWizard.java:465) > at > com.abc.jump.process.view.plan.wizard.DeploymentTasksWizard.onFinish(DeploymentTasksWizard.java:424) > at > com.abc.jump.process.view.wizard.WizardScreen.onNavigation(WizardScreen.java:504) > at echopoint.WizardPane.fireOnNavigation(WizardPane.java:416) > at echopoint.WizardPane.actionPerformed(WizardPane.java:292) > at nextapp.echo.AbstractButton.fireActionPerformed(AbstractButton.java:256) > at > nextapp.echo.AbstractButton$EventForwarder.actionPerformed(AbstractButton.java:135) > at > nextapp.echo.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:98) > at nextapp.echo.DefaultButtonModel.doAction(DefaultButtonModel.java:87) > at nextapp.echo.AbstractButton.doAction(AbstractButton.java:245) > at > nextapp.echoservlet.ui.AbstractButtonUI.clientAction(AbstractButtonUI.java:86) > at echopoint.ui.PushButtonUI.clientAction(PushButtonUI.java:86) > at > nextapp.echoservlet.ControllerInputProcessor.doAction(ControllerInputProcessor.java:157) > at > nextapp.echoservlet.ControllerInputProcessor.(ControllerInputProcessor.java:126) > at > nextapp.echoservlet.ControllerInputProcessor.process(ControllerInputProcessor.java:54) > at nextapp.echoservlet.Controller.service(Controller.java:609) > at nextapp.echoservlet.Connection.process(Connection.java:459) > at nextapp.echoservlet.EchoServer.process(EchoServer.java:314) > at com.abc.jump.process.view.PortalServlet.process(PortalServlet.java:162) > at nextapp.echoservlet.EchoServer.doPost(EchoServer.java:234) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > at > com.abc.jump.process.view.web.filter.TemporaryAssetContentIntegrationFilter.doFilter(TemporaryAssetContentIntegrationFilter.java:76) > at > org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > at > com.abc.common.view.util.ThreadLocalResourceFilter.doFilter(ThreadLocalResourceFilter.java:58) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > at > org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174) > at > org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > at > com.abc.common.util.filter.AuditUserDetailsFilter.doFilter(AuditUserDetailsFilter.java:64) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > at > org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:195) > at > org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) > at > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) > at > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) > at > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) > at java.lang.Thread.run(Thread.java:595) > Caused by: java.io.IOException: Failed to broker message: > ID:abc2-2257-1175204828244-0:8:1:1:1 in container: java.sql.SQLException: > Data size bigger than max size for this type: 63268 > at > org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:31) > at > org.apache.activemq.store.jdbc.JDBCMessageStore.addMessage(JDBCMessageStore.java:74) > at > org.apache.activemq.store.memory.MemoryTransactionStore.addMessage(MemoryTransactionStore.java:224) > at > org.apache.activemq.store.memory.MemoryTransactionStore$1.addMessage(MemoryTransactionStore.java:117) > at org.apache.activemq.broker.region.Queue.send(Queue.java:345) > at > org.apache.activemq.broker.region.AbstractRegion.send(AbstractRegion.java:305) > at > org.apache.activemq.broker.region.RegionBroker.send(RegionBroker.java:378) > at > org.apache.activemq.broker.TransactionBroker.send(TransactionBroker.java:197) > at org.apache.activemq.broker.BrokerFilter.send(BrokerFilter.java:126) > at > org.apache.activemq.broker.CompositeDestinationBroker.send(CompositeDestinationBroker.java:98) > at > org.apache.activemq.broker.MutableBrokerFilter.send(MutableBrokerFilter.java:136) > at > org.apache.activemq.broker.TransportConnection.processMessage(TransportConnection.java:449) > at > org.apache.activemq.command.ActiveMQMessage.visit(ActiveMQMessage.java:604) > at > org.apache.activemq.broker.TransportConnection.service(TransportConnection.java:258) > at > org.apache.activemq.broker.TransportConnection$1.onCommand(TransportConnection.java:164) > at > org.apache.activemq.transport.TransportFilter.onCommand(TransportFilter.java:65) > at > org.apache.activemq.transport.WireFormatNegotiator.onCommand(WireFormatNegotiator.java:133) > at > org.apache.activemq.transport.InactivityMonitor.onCommand(InactivityMonitor.java:122) > at > org.apache.activemq.transport.TransportSupport.doConsume(TransportSupport.java:84) > at > org.apache.activemq.transport.tcp.TcpTransport.run(TcpTransport.java:137) > ... 1 more > Caused by: java.sql.SQLException: Data size bigger than max size for this > type: 63268 > at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) > at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) > at oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:95) > at > oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.java:2413) > at > oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.java:1166) > at > oracle.jdbc.driver.OraclePreparedStatement.setBytes(OraclePreparedStatement.java:2208) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.setBytes(DelegatingPreparedStatement.java:105) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.setBytes(DelegatingPreparedStatement.java:105) > at > org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.setBinaryData(DefaultJDBCAdapter.java:56) > at > org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doAddMessage(DefaultJDBCAdapter.java:175) > at > org.apache.activemq.store.jdbc.JDBCMessageStore.addMessage(JDBCMessageStore.java:71) > ... 19 more > -- > View this message in context: http://www.nabble.com/Data-size-bigger-than-max-size-for-this-type-tf3489299s2354.html#a9744357 -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.