oracle.AQ.AQException: JMS-112: Connection is invalid
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Annapurna_P
Posted On:   Tuesday, January 6, 2009 02:55 AM

Hi, I am trying to create data source in oracle advance queues. I got data source connection successfully. While creating AQ session using the following lines of code. aqSession = AQDriverManager.createAQSession(conn); I am getting following error: oracle.AQ.AQException: JMS-112: Connection is invalid at oracle.AQ.AQDriverManager.createAQSession(AQDriverManager.java:193) at com.vodafone.upss.utils.oaq.OAQHelper.getAQSession(OAQHelper.java:201) at com.vodafone.upss.utils.oaq.OAQHelper.enqueueDataToQueue(OAQHelper.java:277) at com.vodafone.upss.utils.oaq.OAQHelper.main(OAQHelper.java:1004) Exception in thread "P=40808:O=0:CT" com.vodafone.up   More>>

Hi,

I am trying to create data source in oracle advance queues.
I got data source connection successfully.
While creating AQ session using the following lines of code.

aqSession = AQDriverManager.createAQSession(conn);

I am getting following error:

oracle.AQ.AQException: JMS-112: Connection is invalid


at oracle.AQ.AQDriverManager.createAQSession(AQDriverManager.java:193)
at com.vodafone.upss.utils.oaq.OAQHelper.getAQSession(OAQHelper.java:201)
at com.vodafone.upss.utils.oaq.OAQHelper.enqueueDataToQueue(OAQHelper.java:277)
at com.vodafone.upss.utils.oaq.OAQHelper.main(OAQHelper.java:1004)
Exception in thread "P=40808:O=0:CT" com.vodafone.upss.exceptions.OAQException: AQException while creating AQSession: JMS-112: Connection is invalid


at com.vodafone.upss.utils.oaq.OAQHelper.getAQSession(OAQHelper.java:207)
at com.vodafone.upss.utils.oaq.OAQHelper.enqueueDataToQueue(OAQHelper.java:277)
at com.vodafone.upss.utils.oaq.OAQHelper.main(OAQHelper.java:1004)

Please help with the solution

Regards
Annapurna.

   <<Less

Re: oracle.AQ.AQException: JMS-112: Connection is invalid

Posted By:   Christoph_Petz  
Posted On:   Thursday, January 15, 2009 02:38 AM

Problem with AQ is that it requries oracle.jdbc.OracleConnections so you need to ensure that whatever datasource you use provides you something that can directly be casted to OracleConnection.
If you get a proxy as Connection you might be able to get the wrapped OracleConnection
About | Sitemap | Contact