You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@camel.apache.org by "anshuman.mishra" <an...@cybage.com> on 2012/02/08 11:24:07 UTC

sending oracle XMLType message to activeMQ

Hi,

I am trying to send oracle XMLType message after dequeueing from oracle to
activeMQ queue 
but getting 

java.io.NotSerilizable exception.



I am using ProducerTemplate.getBodyAndHeader method to send the message.

Anyone knows a way to achieve this.

thanks,
Anshuman

--
View this message in context: http://camel.465427.n5.nabble.com/sending-oracle-XMLType-message-to-activeMQ-tp5466141p5466141.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: sending oracle XMLType message to activeMQ

Posted by tops <il...@gmail.com>.
We still figure out how to handle this issue, but anyway thank you guys for
all of yours proposals!

I'll update this thread once we come up with final decision.



--
View this message in context: http://camel.465427.n5.nabble.com/sending-oracle-XMLType-message-to-activeMQ-tp5466141p5503727.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: sending oracle XMLType message to activeMQ

Posted by kumarburla <ku...@gmail.com>.
Hi Team, 

I am using sql-stored component  to execute a stored procedure in Oracle DB.
My OUT parameter is of type javaa.sql.SQLXML.  When i am getting output in
body, i am getting type as oracle.xdb.XMLType. 

 I am passing this output to another procedure whose input is XMLTYPE. But i
am getting error while doing so. Below is my code 

Step 1 : Call to Oracle Stored procedure 
<to uri="sql-stored:SP_Test(INTEGER 5 , OUT SQLXML PR)dataSource=ds1" />  
<log message=" 324 ${body}"/>
<log message=" 123  ${body.[PR]}"/>
Step 2 : <setBody >
        <simple resultType="java.sql.SQLXML">${body.[PR]}</simple>
        </setBody>
<log message=" after 324  ${body}"/>
Step 3: 
<setHeader headerName="test1"><simple>${body}</simple></setHeader>
                                        <to uri="sql-stored:SP_Test1(SQLXML
${header.test1})?dataSource=ds1}" /> 


After executing the above steps below is my stack trace. 

2017-02-10 16:40:24,601 | INFO  |  324 {PR=oracle.xdb.XMLType@7941dbe3} 
2017-02-10 16:40:24,662 | INFO  |  123  oracle.xdb.XMLType@7941dbe3 
2017-02-10 16:40:24,662 | INFO  |  after 324  oracle.xdb.XMLType@7941dbe3 
2017-02-10 16:40:25,024 | INFO  |
org.springframework.dao.RecoverableDataAccessException:
CallableStatementCallback; SQL [{call SP_Test1(?)}]; Closed Connection;
nested exception is java.sql.SQLRecoverableException: Closed Connection 
        at
org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:98) 
        at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) 
        at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) 
        at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1094) 
        at
org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1130) 
        at
org.springframework.jdbc.object.StoredProcedure.execute(StoredProcedure.java:142) 
        at
org.apache.camel.component.sql.stored.TemplateStoredProcedure.execute(TemplateStoredProcedure.java:74) 
        at
org.apache.camel.component.sql.stored.CallableStatementWrapper.populateStatement(CallableStatementWrapper.java:104) 
        at
org.apache.camel.component.sql.stored.SqlStoredProducer$1.execute(SqlStoredProducer.java:69) 
        at
org.apache.camel.component.sql.stored.CallableStatementWrapper.call(CallableStatementWrapper.java:55) 
        at
org.apache.camel.component.sql.stored.SqlStoredProducer.process(SqlStoredProducer.java:43) 
        at
org.apache.camel.util.AsyncProcessorConverterHelper$ProcessorToAsyncProcessorBridge.process(AsyncProcessorConverterHelper.java:61) 
        at
org.apache.camel.processor.SendProcessor$2.doInAsyncProducer(SendProcessor.java:173) 
        at
org.apache.camel.impl.ProducerCache.doInAsyncProducer(ProducerCache.java:341) 
        at
org.apache.camel.processor.SendProcessor.process(SendProcessor.java:168) 
        at
org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77) 
        at
org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:190) 
        at org.apache.camel.processor.Pipeline.process(Pipeline.java:121) 
        at org.apache.camel.processor.Pipeline.process(Pipeline.java:83) 
        at
org.apache.camel.processor.TryProcessor.process(TryProcessor.java:113) 
        at
org.apache.camel.processor.TryProcessor.process(TryProcessor.java:84) 
        at
org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77) 
        at
org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:190) 
        at
org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:190) 
        at
org.apache.camel.component.timer.TimerConsumer.sendTimerExchange(TimerConsumer.java:192) 
        at
org.apache.camel.component.timer.TimerConsumer$1.run(TimerConsumer.java:76) 
        at java.util.TimerThread.mainLoop(Timer.java:555) 
        at java.util.TimerThread.run(Timer.java:505) 
Caused by: java.sql.SQLRecoverableException: Closed Connection 
        at
oracle.jdbc.driver.PhysicalConnection.prepareCall(PhysicalConnection.java:4178) 
        at
oracle.jdbc.driver.PhysicalConnection.prepareCall(PhysicalConnection.java:4134) 
        at
oracle.jdbc.oracore.OracleTypeADT.initMetadata12(OracleTypeADT.java:551) 
        at
oracle.jdbc.oracore.OracleTypeADT.initMetadata(OracleTypeADT.java:507) 
        at oracle.jdbc.oracore.OracleTypeADT.init(OracleTypeADT.java:469) 
        at
oracle.sql.OpaqueDescriptor.initPickler(OpaqueDescriptor.java:258) 
        at oracle.sql.OpaqueDescriptor.<init>(OpaqueDescriptor.java:59) 
        at
oracle.sql.OpaqueDescriptor.createDescriptor(OpaqueDescriptor.java:177) 
        at oracle.xdb.XMLType.toDatum(XMLType.java:758) 
        at oracle.xdb.XMLType.toBytes(XMLType.java:4048) 
        at
oracle.jdbc.driver.OraclePreparedStatement.setOPAQUECritical(OraclePreparedStatement.java:6560) 
        at
oracle.jdbc.driver.OraclePreparedStatement.setOPAQUEInternal(OraclePreparedStatement.java:6517) 
        at
oracle.jdbc.driver.OraclePreparedStatement.setSQLXMLInternal(OraclePreparedStatement.java:6598) 
        at
oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:9463) 
        at
oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8946) 
        at
oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:9557) 
        at
oracle.jdbc.driver.OracleCallableStatement.setObject(OracleCallableStatement.java:6090) 
        at
oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:249) 
        at
org.springframework.jdbc.core.StatementCreatorUtils.setValue(StatementCreatorUtils.java:437) 
        at
org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:235) 
        at
org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:150) 
        at
org.springframework.jdbc.core.CallableStatementCreatorFactory$CallableStatementCreatorImpl.createCallableStatement(CallableStatementCreatorFactory.java:213) 
        at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1072) 


Thanks & Regards 
Kumar



--
View this message in context: http://camel.465427.n5.nabble.com/sending-oracle-XMLType-message-to-activeMQ-tp5466141p5793794.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: sending oracle XMLType message to activeMQ

Posted by Claus Ibsen <cl...@gmail.com>.
On Sun, Feb 12, 2012 at 11:26 PM, tops <il...@gmail.com> wrote:
> Hi Claus!
> Please find the full trace in attach (trace.txt)
>
> http://camel.465427.n5.nabble.com/file/n5477595/trace.txt trace.txt
>

Well whatever its an Oracle issue as it contains data that are not serializable.

You can tell Camel to send the message as a javax.jms.TextMessage
instead, by setting the jmsMessageType=Text option on the Camel JMS
endpoint.
Then the message is converted to a String. Since your use some Oracle
XMLType then it would be assumed the XMLType can be converted to a
String.
Alternatively you can convert the message yourself using a java bean /
Camel processor etc.


> --
> View this message in context: http://camel.465427.n5.nabble.com/sending-oracle-XMLType-message-to-activeMQ-tp5466141p5477595.html
> Sent from the Camel - Users mailing list archive at Nabble.com.



-- 
Claus Ibsen
-----------------
FuseSource
Email: cibsen@fusesource.com
Web: http://fusesource.com
Twitter: davsclaus, fusenews
Blog: http://davsclaus.blogspot.com/
Author of Camel in Action: http://www.manning.com/ibsen/

Re: sending oracle XMLType message to activeMQ

Posted by tops <il...@gmail.com>.
Hi Claus!
Please find the full trace in attach (trace.txt)

http://camel.465427.n5.nabble.com/file/n5477595/trace.txt trace.txt 

--
View this message in context: http://camel.465427.n5.nabble.com/sending-oracle-XMLType-message-to-activeMQ-tp5466141p5477595.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: sending oracle XMLType message to activeMQ

Posted by Claus Ibsen <cl...@gmail.com>.
Can you post the full stacktrace?


On Fri, Feb 10, 2012 at 6:34 PM, tops <il...@gmail.com> wrote:
> Hi Ashwin!
>
> Let me answer to your questions:
>
> 1. Yes, ActiveMQ (5.5.1) uses a persistent store, but this store is MySQL
> not the Oracle database. Therefore it's not clear for me why the class that
> thrown the exception is oracle.jdbc.driver.T2CConnection:
>
> Caused by: java.io.NotSerializableException:
> oracle.jdbc.driver.T2CConnection
>
> This is the respective ActiveMQ configuration part:
>
>    <bean id="mysql-ds" class="org.apache.commons.dbcp.BasicDataSource"
> destroy-method="close">
>        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
>        <property name="url"
> value="jdbc:mysql://foo.com/activemq?relaxAutoCommit=true"/>
>        <property name="username" value="activemq"/>
>        <property name="password" value="activemq"/>
>        <property name="maxActive" value="200"/>
>        <property name="poolPreparedStatements" value="true"/>
>    </bean>
>
>
>       <persistenceFactory>
>            <journalPersistenceAdapterFactory journalLogFiles="5"
> dataDirectory="${activemq.base}/activemq-data" dataSource="#mysql-ds"/>
>         </persistenceFactory>
>
>
> 2. I went through the oracle documentation once again, just to make sure
> that value of the object is serialized:
>
> http://docs.oracle.com/cd/B28359_01/appdev.111/b28391/serialized-form.html#oracle_xdb_XMLType
>
> we use XMLType xtype.getClobVal() - which is one of the serialized fields,
> according to documentation mentioned above.
>
> --
> View this message in context: http://camel.465427.n5.nabble.com/sending-oracle-XMLType-message-to-activeMQ-tp5466141p5473294.html
> Sent from the Camel - Users mailing list archive at Nabble.com.



-- 
Claus Ibsen
-----------------
FuseSource
Email: cibsen@fusesource.com
Web: http://fusesource.com
Twitter: davsclaus, fusenews
Blog: http://davsclaus.blogspot.com/
Author of Camel in Action: http://www.manning.com/ibsen/

Re: sending oracle XMLType message to activeMQ

Posted by tops <il...@gmail.com>.
Hi Ashwin!

Let me answer to your questions:

1. Yes, ActiveMQ (5.5.1) uses a persistent store, but this store is MySQL
not the Oracle database. Therefore it's not clear for me why the class that
thrown the exception is oracle.jdbc.driver.T2CConnection:

Caused by: java.io.NotSerializableException:
oracle.jdbc.driver.T2CConnection

This is the respective ActiveMQ configuration part:

    <bean id="mysql-ds" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url"
value="jdbc:mysql://foo.com/activemq?relaxAutoCommit=true"/>
        <property name="username" value="activemq"/>
        <property name="password" value="activemq"/>
        <property name="maxActive" value="200"/>
        <property name="poolPreparedStatements" value="true"/>
    </bean>


       <persistenceFactory>
            <journalPersistenceAdapterFactory journalLogFiles="5"
dataDirectory="${activemq.base}/activemq-data" dataSource="#mysql-ds"/>
         </persistenceFactory>


2. I went through the oracle documentation once again, just to make sure
that value of the object is serialized:

http://docs.oracle.com/cd/B28359_01/appdev.111/b28391/serialized-form.html#oracle_xdb_XMLType 

we use XMLType xtype.getClobVal() - which is one of the serialized fields,
according to documentation mentioned above.

--
View this message in context: http://camel.465427.n5.nabble.com/sending-oracle-XMLType-message-to-activeMQ-tp5466141p5473294.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: sending oracle XMLType message to activeMQ

Posted by Ashwin Karpe <ak...@fusesource.com>.
Hi,

Looks like this message us being thrown by an ActiveMQ broke from an
ActiveMQ PooledConnectionFactory that used an Oracle database as a
persistent store and uses an Oracle Driver to persist the message being sent
via Camel.

Can you please verify that the object being sent in its binary form is
indeed Serializable and serialized on the wire...

Cheers,

Ashwin...

-----
---------------------------------------------------------
Ashwin Karpe
Apache Camel Committer & Sr Principal Consultant
FUSESource (a Progress Software Corporation subsidiary)
http://fusesource.com 

Blog: http://opensourceknowledge.blogspot.com 
---------------------------------------------------------
--
View this message in context: http://camel.465427.n5.nabble.com/sending-oracle-XMLType-message-to-activeMQ-tp5466141p5472889.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: sending oracle XMLType message to activeMQ

Posted by Matt Pavlovich <ma...@gmail.com>.
The cause is showing that something isn't serializable.  The XMLType 
object has a toString(), and a constructor that accepts a String to 
re-create the oracle.xdb.XMLType if you need it on the other end.

Its also possible, that you have a header or other object in the 
exchange that is not serializable.  Try adding a <to 
uri="log..?showAll=true" /> line before the AMQ step and Camel will 
output the exchange contents (incl headers) to the log.

On 2/9/12 1:04 PM, tops wrote:
> *Caused by: java.io.NotSerializableException:
> oracle.jdbc.driver.T2CConnection
> 	at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1156)
> 	at
> java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1509)
> 	at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1474)
> 	at
> java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1392)
> 	at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1150)
> 	at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:326)
> 	at
> org.apache.activemq.command.ActiveMQObjectMessage.storeContent(ActiveMQObjectMessage.java:98)

Re: sending oracle XMLType message to activeMQ

Posted by tops <il...@gmail.com>.
Here's the stacktrace:

2012-02-09 13:57:05,031 [DefaultMessageListenerContainer-1] WARN 
org.apache.camel.processor.UnitOfWorkProcessor  - Caught unhandled exception
while processing ExchangeId: ID-SA21-59175-1328813810722-0-1
java.lang.RuntimeException: oracle.jdbc.driver.T2CConnection
	at
org.apache.activemq.command.ActiveMQObjectMessage.storeContent(ActiveMQObjectMessage.java:104)
	at
org.apache.activemq.command.ActiveMQObjectMessage.copy(ActiveMQObjectMessage.java:80)
	at
org.apache.activemq.command.ActiveMQObjectMessage.copy(ActiveMQObjectMessage.java:75)
	at org.apache.activemq.ActiveMQSession.send(ActiveMQSession.java:1619)
	at
org.apache.activemq.ActiveMQMessageProducer.send(ActiveMQMessageProducer.java:227)
	at org.apache.activemq.pool.PooledProducer.send(PooledProducer.java:74)
	at org.apache.activemq.pool.PooledProducer.send(PooledProducer.java:59)
	at org.springframework.jms.core.JmsTemplate.doSend(JmsTemplate.java:592)
	at
org.apache.camel.component.jms.JmsConfiguration$CamelJmsTemplate.doSend(JmsConfiguration.java:268)
	at
org.apache.camel.component.jms.JmsConfiguration$CamelJmsTemplate.doSendToDestination(JmsConfiguration.java:207)
	at
org.apache.camel.component.jms.JmsConfiguration$CamelJmsTemplate.access$100(JmsConfiguration.java:149)
	at
org.apache.camel.component.jms.JmsConfiguration$CamelJmsTemplate$3.doInJms(JmsConfiguration.java:183)
	at org.springframework.jms.core.JmsTemplate.execute(JmsTemplate.java:466)
	at
org.apache.camel.component.jms.JmsConfiguration$CamelJmsTemplate.send(JmsConfiguration.java:180)
	at org.apache.camel.component.jms.JmsProducer.doSend(JmsProducer.java:355)
	at
org.apache.camel.component.jms.JmsProducer.processInOnly(JmsProducer.java:311)
	at org.apache.camel.component.jms.JmsProducer.process(JmsProducer.java:109)
	at
org.apache.camel.processor.UnitOfWorkProcessor.processAsync(UnitOfWorkProcessor.java:150)
	at
org.apache.camel.processor.UnitOfWorkProcessor.process(UnitOfWorkProcessor.java:117)
	at
org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:99)
	at
org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:86)
	at
org.apache.camel.processor.UnitOfWorkProducer.process(UnitOfWorkProducer.java:63)
	at
org.apache.camel.impl.ProducerCache$2.doInProducer(ProducerCache.java:352)
	at
org.apache.camel.impl.ProducerCache$2.doInProducer(ProducerCache.java:324)
	at org.apache.camel.impl.ProducerCache.doInProducer(ProducerCache.java:223)
	at org.apache.camel.impl.ProducerCache.sendExchange(ProducerCache.java:324)
	at org.apache.camel.impl.ProducerCache.send(ProducerCache.java:169)
	at
org.apache.camel.impl.DefaultProducerTemplate.send(DefaultProducerTemplate.java:111)
	at
org.apache.camel.impl.DefaultProducerTemplate.sendBodyAndHeader(DefaultProducerTemplate.java:150)
	at
org.apache.camel.impl.DefaultProducerTemplate.sendBodyAndHeader(DefaultProducerTemplate.java:146)
	at
com.foo.jms.message.producer.TransactionMessageProducer.sendMessage(TransactionMessageProducer.java:43)
	at
com.foo.jms.aq.OracleAqTransactionMessageListener.onMessage(OracleAqTransactionMessageListener.java:47)
	at
org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:536)
	at
org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:496)
	at
org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:467)
	at
org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:325)
	at
org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:243)
	at
org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1059)
	at
org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1051)
	at
org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:948)
	at java.lang.Thread.run(Thread.java:619)
*Caused by: java.io.NotSerializableException:
oracle.jdbc.driver.T2CConnection
	at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1156)
	at
java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1509)
	at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1474)
	at
java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1392)
	at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1150)
	at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:326)
	at
org.apache.activemq.command.ActiveMQObjectMessage.storeContent(ActiveMQObjectMessage.java:98)
	... 40 more*
2012-02-09 13:57:05,080 [DefaultMessageListenerContainer-1] INFO 
com.foo.jms.message.producer.TransactionMessageProducer  - Exception
occurred during execution on the exchange: Exchange[Message:
oracle.xdb.XMLType@15635fa]




--
View this message in context: http://camel.465427.n5.nabble.com/sending-oracle-XMLType-message-to-activeMQ-tp5466141p5470388.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: sending oracle XMLType message to activeMQ

Posted by Claus Ibsen <cl...@gmail.com>.
Well you reported a not serialized exception, so the Oracle XMLType is
maybe not really serializable.
And post the full stacktrace in the mail, that helps.



On Wed, Feb 8, 2012 at 10:49 PM, tops <il...@gmail.com> wrote:
> Hi Claus!
>
> Do you need to get String value of XMLType even regardless the fact that
> XMLType is serializable class?
>
> http://docs.oracle.com/cd/B28359_01/appdev.111/b28391/oracle/xdb/XMLType.html
>
> Or the reason is the camel implementation issue or so?
>
>
>
> --
> View this message in context: http://camel.465427.n5.nabble.com/sending-oracle-XMLType-message-to-activeMQ-tp5466141p5467801.html
> Sent from the Camel - Users mailing list archive at Nabble.com.



-- 
Claus Ibsen
-----------------
FuseSource
Email: cibsen@fusesource.com
Web: http://fusesource.com
Twitter: davsclaus, fusenews
Blog: http://davsclaus.blogspot.com/
Author of Camel in Action: http://www.manning.com/ibsen/

Re: sending oracle XMLType message to activeMQ

Posted by tops <il...@gmail.com>.
Hi Claus!

Do you need to get String value of XMLType even regardless the fact that
XMLType is serializable class?

http://docs.oracle.com/cd/B28359_01/appdev.111/b28391/oracle/xdb/XMLType.html

Or the reason is the camel implementation issue or so?



--
View this message in context: http://camel.465427.n5.nabble.com/sending-oracle-XMLType-message-to-activeMQ-tp5466141p5467801.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: sending oracle XMLType message to activeMQ

Posted by Claus Ibsen <cl...@gmail.com>.
Hi

You need to convert the oracle XMLType into a neutral type, such as
java.lang.String etc.
To be abel to send it to a non Oracle broker such as AMQ.



On Wed, Feb 8, 2012 at 11:24 AM, anshuman.mishra <an...@cybage.com> wrote:
> Hi,
>
> I am trying to send oracle XMLType message after dequeueing from oracle to
> activeMQ queue
> but getting
>
> java.io.NotSerilizable exception.
>
>
>
> I am using ProducerTemplate.getBodyAndHeader method to send the message.
>
> Anyone knows a way to achieve this.
>
> thanks,
> Anshuman
>
> --
> View this message in context: http://camel.465427.n5.nabble.com/sending-oracle-XMLType-message-to-activeMQ-tp5466141p5466141.html
> Sent from the Camel - Users mailing list archive at Nabble.com.



-- 
Claus Ibsen
-----------------
FuseSource
Email: cibsen@fusesource.com
Web: http://fusesource.com
Twitter: davsclaus, fusenews
Blog: http://davsclaus.blogspot.com/
Author of Camel in Action: http://www.manning.com/ibsen/