You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@activemq.apache.org by ron55test <rk...@gmail.com> on 2007/03/30 00:52:28 UTC
Data size bigger than max size for this type
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#a9744357
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
Re: Data size bigger than max size for this type
Posted by Pandey <vi...@gmail.com>.
I'm facing the same issue with apache-activemq-4.1.0 right now.
I have faced something simillar earlier.
looks like it's coded in Oracle driver to accept nothing greater than 4K as
a blob/byte[]/clob/char[]
below is how i fixed it (came across the solution somewhere i guess) :
// create an empty blob and execute the statement ... do retain the
identifier for the row
oracle.sql.BLOB blob = oracle.sql.BLOB.empty_lob();
ps.setBlob(4, blob);
ps.execute();
//use the identifier retained above to get the handle to the empty blob
and write the blobData (>4k)
PreparedStatement st =
connection.prepareStatement(getBlobHandleForOracleQuery);
st.setInt(1, rowID);
ResultSet rs = st.executeQuery();
rs.next();
blob = (oracle.sql.BLOB)rs.getBlob(1);
OutputStream os = blob.getBinaryOutputStream();
try {
os.write(blobData);
os.flush();
os.close();
} catch (IOException e) {
e.printStackTrace();
throw new SQLException("Error in writing BLOB data :
"+e.getMessage());
}
This happens only with oracle (far as i'v seen .. sybase and mysql are good
with bigger data as well).
Regards
Vipul
James.Strachan wrote:
>
> On 3/30/07, ron55test <rk...@gmail.com> wrote:
>>
>> 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")
>> )
>
> It looks like the BLOB type is 4Gb long
> http://www.ss64.com/orasyntax/datatypes.html
>
> so I'm not sure thats the problem. I suspect it may be due to the way
> in which the JDBC code works with the BLOB column type. This article
> appears to suggest that the preferred way to work with Oracle BLOBs is
> using the Blob type
> http://www.onjava.com/lpt/a/1370
>
> so I've patched trunk of the Oracle adapter to use this approach
> instead. Any chance you could build trunk and see if this fixes your
> issue?
>
> I've raised this issue to track the issue
> http://issues.apache.org/activemq/browse/AMQ-1216
>
> --
>
> James
> -------
> http://radio.weblogs.com/0112098/
>
>
--
View this message in context: http://www.nabble.com/Data-size-bigger-than-max-size-for-this-type-tf3489299s2354.html#a9878741
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
Re: Data size bigger than max size for this type
Posted by James Strachan <ja...@gmail.com>.
On 3/30/07, ron55test <rk...@gmail.com> wrote:
>
> 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")
> )
It looks like the BLOB type is 4Gb long
http://www.ss64.com/orasyntax/datatypes.html
so I'm not sure thats the problem. I suspect it may be due to the way
in which the JDBC code works with the BLOB column type. This article
appears to suggest that the preferred way to work with Oracle BLOBs is
using the Blob type
http://www.onjava.com/lpt/a/1370
so I've patched trunk of the Oracle adapter to use this approach
instead. Any chance you could build trunk and see if this fixes your
issue?
I've raised this issue to track the issue
http://issues.apache.org/activemq/browse/AMQ-1216
--
James
-------
http://radio.weblogs.com/0112098/
Re: Data size bigger than max size for this type
Posted by ron55test <rk...@gmail.com>.
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.
Re: Data size bigger than max size for this type
Posted by Austin Mills <am...@thecatalis.com>.
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
>
Re: Data size bigger than max size for this type
Posted by Pandey <vi...@gmail.com>.
Hi,
> I did a build from trunk and tested it. It works fine now.
I checked out the code, built it and tried running it but somehow it never
worked for me!!
I then modified the OracleJDBCAdapter which uploads Blobs > 4k now.
Attaching the code herewith! it's not the neatest way but that's only how i
could localize it (AND get it running real real quick :)
~V
http://www.nabble.com/file/7744/OracleJDBCAdapter.java
OracleJDBCAdapter.java
On 3/30/07, ron55test wrote:
>
> I did a build from trunk and tested it. It works fine now.
Awesome - thanks for letting us know!
James
--
View this message in context: http://www.nabble.com/Data-size-bigger-than-max-size-for-this-type-tf3489299s2354.html#a9888172
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
Re: Data size bigger than max size for this type
Posted by Pandey <vi...@gmail.com>.
Hi,
> I did a build from trunk and tested it. It works fine now.
I checked out the code, built it and tried running it but somehow it never
worked for me!!
I then modified the OracleJDBCAdapter which uploads Blobs > 4k now.
Attaching the code herewith! it's not the neatest way but that's only how i
could localize it (AND get it running real real quick :)
~V
http://www.nabble.com/file/7744/OracleJDBCAdapter.java
OracleJDBCAdapter.java
--
View this message in context: http://www.nabble.com/Data-size-bigger-than-max-size-for-this-type-tf3489299s2354.html#a9888181
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
Re: Data size bigger than max size for this type
Posted by James Strachan <ja...@gmail.com>.
On 3/30/07, ron55test <rk...@gmail.com> wrote:
>
> I did a build from trunk and tested it. It works fine now.
Awesome - thanks for letting us know!
James
>
>
> 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#a9757253
> Sent from the ActiveMQ - User mailing list archive at Nabble.com.
>
>
--
James
-------
http://radio.weblogs.com/0112098/
Re: Data size bigger than max size for this type
Posted by ron55test <rk...@gmail.com>.
I did a build from trunk and tested it. It works fine now.
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#a9757253
Sent from the ActiveMQ - User mailing list archive at Nabble.com.