Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

java.sql.SQLException: ORA-00904: "JMSMESSAGEID": invalid identifier

334994Oct 30 2007 — edited Oct 31 2007
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)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 28 2007
Added on Oct 30 2007
3 comments
7,300 views