I am trying to dequeue a message but I always get the following error. I am not sure how to debug this further. I was having issues with oracle 9.2.0.4 so I installed 10G specifically 10.2.0.1.0 but now get this error. I can browse the message but when I try to dequeue it I get the error. Here is the code for dequing the message. Can someone let me know how to debug this further?
Deuque Code
String messageSelector = "JMSMessageID = 'ID:" +am.getJMSMessageID()+ "'";
qr = ((AQjmsSession)qsess).createReceiver(q1,messageSelector, orad);
((AQjmsQueueReceiver)qr).receiveNoData();
Here is the error message
oracle.jms.AQjmsException: JMS-120: Dequeue failed
at oracle.jms.AQjmsError.throwEx(AQjmsError.java:311)
at oracle.jms.AQjmsConsumer.dequeue(AQjmsConsumer.java:2234)
at oracle.jms.AQjmsConsumer.dequeue(AQjmsConsumer.java:1161)
at oracle.jms.AQjmsConsumer.receiveNoData(AQjmsConsumer.java:2573)
at oracle.jms.AQjmsConsumer.receiveNoData(AQjmsConsumer.java:2510)
at OraclePushTest.queueBrowserDemo(OraclePushTest.java:101)
at OraclePushTest.main(OraclePushTest.java:46)
[Linked-exception]
java.sql.SQLException: ORA-00904: "JMSMESSAGEID": invalid identifier
ORA-06512: at "SYS.DBMS_AQIN", line 651
ORA-06512: at line 1
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.
java:212)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableSta
tement.java:951)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1160)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
aredStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
dStatement.java:3329)
at oracle.jms.AQjmsConsumer.dequeue(AQjmsConsumer.java:1633)
at oracle.jms.AQjmsConsumer.dequeue(AQjmsConsumer.java:1161)
at oracle.jms.AQjmsConsumer.receiveNoData(AQjmsConsumer.java:2573)
at oracle.jms.AQjmsConsumer.receiveNoData(AQjmsConsumer.java:2510)
at OraclePushTest.queueBrowserDemo(OraclePushTest.java:101)
at OraclePushTest.main(OraclePushTest.java:46)