Oracle AQ + Java + Spring
1003737Apr 17 2013 — edited Apr 19 2013Hello Guys
My name is Kleber and I'm talking from Brasil ! :)
I'm trying to connect my app Java in one Oracle AQ and I'm getting this error
2013-04-17 14:00:30,937 WARN [oracleAqJMSQueue-1] [jms.listener.DefaultMessageListenerContainer.handleListenerSetupFailure:818] - Setup of JMS message listener invoker failed for destination 'PIN.AQ_QUEUE' - trying to recover. Cause: JMS-120: Dequeue failed; nested exception is java.sql.SQLException: XMLTypeFactory can only work with OPAQUE
oracle.jms.AQjmsException: JMS-120: Dequeue failed
at oracle.jms.AQjmsError.throwEx(AQjmsError.java:315)
at oracle.jms.AQjmsConsumer.jdbcDequeue(AQjmsConsumer.java:1630)
at oracle.jms.AQjmsConsumer.receiveFromAQ(AQjmsConsumer.java:1037)
at oracle.jms.AQjmsConsumer.receiveFromAQ(AQjmsConsumer.java:962)
at oracle.jms.AQjmsConsumer.receiveFromAQ(AQjmsConsumer.java:940)
at oracle.jms.AQjmsConsumer.receive(AQjmsConsumer.java:792)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveMessage(AbstractPollingMessageListenerContainer.java:429)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:310)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:263)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1058)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1050)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:947)
at java.lang.Thread.run(Thread.java:680)
Caused by: java.sql.SQLException: XMLTypeFactory can only work with OPAQUE
at oracle.xdb.XMLTypeFactory.create(XMLTypeFactory.java:69)
at oracle.jms.AQjmsConsumer.jdbcDequeue(AQjmsConsumer.java:1453)
I followed this code on https://github.com/sachin-handiekar/oracle-aq-samples/tree/master/java/oracle-aq-jms-api but it`s not woking.
Could anyone help me please?