oracle-aq

TextMessage received from Oracle AQ using JMS contains just '???'

I need to connect to two Oracle AQ queues in different databases. I'm using exactly similar code in both cases, except for the connection string of course. One of the queues is working fine, but the second one not. String db_string = "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=x.y.z.2)(PORT=1521))(ADDRESS=...

Is Oracle AQ/Streams of any use in my situation?

I'm writing a workflow system that is driven entirely at each step by explicit human interaction. That is, a task is assigned to a person, that person selects from a few limited options {approve, reject, forward}, and then it is either sent along to the next person or terminated. Just curious if Oracle Streams/AQ has anything to offer ...

Start oracle dequeue on startup

Hi, I got the following error of Oracle, ORA-25226: dequeue failed, queue string.string is not enabled for dequeue And the following is the Cause and Action for it from the official document: Cause: The queue has not been enabled for dequeue. Action: Enable the queue using START_QUEUE. But this error occurs every time when resta...

Does anyone know what these Oracle AQ JMS XA properties do?

I'm using Oracle Advanced Queues via JMS from within Websphere App Server. Does anyone know what effect the following two properties have:- - oracle.jms.useEmulatedXA - oracle.jms.useNativeXA I have seen mentioned in some blogs and quick start guides, usually in sentences along the lines of "Add -Doracle.jms.useEmulatedXA=false -Do...

Selective dequeue of unrelated messages in Oracle Advanced Queueing

This question refers to the dequeueing of messages in Oracle Streams Advanced Queueing. I need to ensure that the messages which are related to each other are processed sequentially. For example, assume the queue is seeded with the four messages that have a business-related field called transaction reference (txn_ref) and two of the ...

Delphi ODAC: Disecting JMS messages from Oracle AQ

I'm trying to evaluate ODAC for using Oracle AQ. The request queue contains JMS objects like these (but without linebreaks and other whitespace): SYS.AQ$_JMS_BYTES_MESSAGE( SYS.AQ$_JMS_HEADER( 'null','null','null','null','null','null', SYS.AQ$_JMS_USERPROPARRAY( SYS.AQ$_JMS_USERPROPERTY('Key1',100,'Value1','null',27), ...