activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ron55test <rkn...@gmail.com>
Subject Re: Data size bigger than max size for this type
Date Thu, 29 Mar 2007 23:15:43 GMT

The column is of type blob.
This is what the table structure is as created by activemq:
  CREATE TABLE ACTIVEMQ_MSGS" 
   (	"ID" NUMBER(32,0) NOT NULL ENABLE, 
	"CONTAINER" VARCHAR2(250), 
	"MSGID_PROD" VARCHAR2(250), 
	"MSGID_SEQ" NUMBER(32,0), 
	"EXPIRATION" NUMBER, 
	"MSG" BLOB, 
	 PRIMARY KEY ("ID")
)


Austin Mills wrote:
> 
> I've seen that before (outside of ActiveMQ) when trying to store more 
> than 4k characters in a VARCHAR2 column -- if it's more than 4k 
> characters, you have to use a CLOB type instead. It can happen with 
> XMLTYPEs being set as strings as well.
> 
> --Austin
> 
> ron55test wrote:
>> When I try to produce a large message (a list of POJOs), I get the
>> exception
>> below.  I'm using Oracle 10g with Spring and activemq.  
>> --I don't get this exception if I use Derby as the database. 
>> --I'm using ojdbc14-10g-10.2.0.1.0.jar driver.
>> --If I send small message ( a string ), I don't get this exception when
>> using oracle
>>
>> Any help will be appreciated.
>>
>> This is my datasource configuration:
>>
>>   <bean id="oracle-ds" class="org.apache.commons.dbcp.BasicDataSource"
>> destroy-method="close">
>>     <property name="driverClassName"
>> value="oracle.jdbc.driver.OracleDriver"/>
>>     <property name="url"
>> value="jdbc:oracle:thin:@dev.abc.com:1521:dev10g"/>
>>     <property name="username" value="abc"/>
>>     <property name="password" value="abc"/>
>>     <property name="poolPreparedStatements" value="true"/>
>>   </bean>
>>
>>
>> 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.<init>(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#a9744641
Sent from the ActiveMQ - User mailing list archive at Nabble.com.


Mime
View raw message