oracle « jms « Java Enterprise Q&A

1. Display contents of Oracle AQ SYS.AQ$_JMS_TEXT_MESSAGE stackoverflow.com

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 ...

2. PL/SQL function in Oracle cannot see DBMS_AQ stackoverflow.com

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 ...

3. Oracle: problem with constructing JMS message stackoverflow.com

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
   ...

4. JMS setTimeToLive stackoverflow.com

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 ...

5. Does anyone know what these Oracle AQ JMS XA properties do? stackoverflow.com

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 ...

6. OC4J 10.1.3.3 unable to find ojms.rar setting up database persistences stackoverflow.com

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 ...

7. How to clear a queue in Oracle AQ stackoverflow.com

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. ...

8. How to tell in Oracle AQ which messages have been consumed from a multiple consumer queue stackoverflow.com

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',
                 ...

9. Why is my Oracle AQ so slow with multi-consumer queue stackoverflow.com

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 ...

10. JMS and Oracle AQ stackoverflow.com

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

11. How to set max_retries to unlimited on an OracleAQ queue stackoverflow.com

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 ...

12. How do I create an MDB that listens to Oracle AQ queue under JBoss AS? stackoverflow.com

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 ...

13. MDB connected to Oracle AQ via a datasource stackoverflow.com

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", ...

14. Please help me understand the xa transactions in weblogic stackoverflow.com

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

15. Craeting QueueTable in OracleAQ 11.2.0 stackoverflow.com

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 ...

16. Oracle as JMS Server: Any Feedback? stackoverflow.com

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 ...

17. Using Oracle AQ as a JMS in JBoss5 stackoverflow.com

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 ...