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=...
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 ...
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...
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...
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 ...
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), ...