I have an application that uses JMS op top of Oracle advanced queuing. I would like to do a query on the queue table that shows the content of the message ... |
I have problem with Oracle 9.2 and JMS.
I created PL/SQL routine to send XML text (from file or CLOB) to queue,
but this routine do not compile.
My code looks like (filling ... |
After some struggle with Oracle Advanced Queuing and dbms_aq package
I encountered another issue. I copied code from Oracle tutorials
but when I compile this code:
create or replace
procedure jms_test(msg varchar2)
is
...
|
I'm using JMS topic to publish messages. And on the message producer I'm setting setTimeToLive.I'm expecting the messages to be deleted after 16 hours. But even after 16 hours the message ... |
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 ... |
I'm running into problems with JMS in Oracle AS 10.1.3.3.
The error I am getting is 'connectors\ojms.rar (The system cannot find the path specified)' from EM.
Below are a few bullets on ... |
I've been testing Oracle AQ for the first time. I have managed to create 2000 rows of test inserts into the queue I created.
Now, I'd like to clear those out. ... |
|
I'm new to Oracle AQ.
I have created a table and a queue like so:
EXEC dbms_aqadm.create_queue_table(queue_table=>'MY_QUEUE_TABLE',
...
|
new to Oracle AQ, but it seems like it should really make things easy for the project I am working on.
I want to create a queue with multiple durable subscribers, but ... |
Would anyone be able to point me to some sample java code that shows me to how to listen on an Oracle AQ Queue?
Thanks
Damien
|
I have set up a queue in OracleAQ. If I understand the settings correctly this configuration will try each hour for 168 hours before removing the message:
EXEC dbms_aqadm.create_queue(queue_name=>'MYT_INFO_QUEUE',queue_table=>'MY_QUEUE_TABLE',max_retries=>168,retry_delay=>60,retention_time=>3600);
How can ... |
I need to listen to an Oracle AQ queue in a Java EE application that runs under JBoss AS 5.1.
I managed to create a regular JMS client using Oracle's JMS client ... |
Im trying to create a MDB (JBoss AS 6) that connect to an Oracle AD queue.
I got the following example to work:
@MessageDriven(name = "TestMdb", activationConfig = {
@ActivationConfigProperty(propertyName="destinationType", ...
|
Our environment is weblogic 11g, oracle, jms and mostly webservices.
Using XA driver. datasource as TX
Transactions are working fine for all the updates, we are wrapping the statements with begin, commit/rollback.
Problem is, ... |
I have installed Oracle11.2.0(windows,32 bit) and tried to create a queuetable..
(I have granted all permissions for the jmsuser,AQ_ADMINISTRATOR_ROLE,AQ_USER_ROLE,DB_Access).
when try to create a queuetable, Oracle gives following issue;
oracle.jms.AQjmsException: ORA-01017: invalid username/password; logon ... |
We would select a queue server for a distributed architecture. Our DBA talked us about Oracle JMS Server?
What is your feeling?
I got feedback with servers like RabbitMQ/HornetMQ/ActiveMQ? How would you ... |
I'm looking for a full example or detail tutorial how to set Oracle AQ as a JMSProvider. I would like to create MDB which would be executed by the messages from ... |