Why doesn't AQ_ADMINISTRATOR_ROLE or AQ_USER_ROLE always work for AQ applications using Java/JMS API?
Answer / munnu
In addition to granting the roles, you would also need to grant execute to the user on the following packages:
* grant execute on sys.dbms_aqin to <userid>
* grant execute on sys.dbms_aqjms to <userid>
Is This Answer Correct ? | 0 Yes | 0 No |
Explain about session interface?
What is a jms listener?
What is the principle difference between the working mechanism of jms and rpc?
How many types of messaging model do JMS provide for and what are they?
What is jms consumer?
Can two different jms services talk to each other? For instance, if a and b are two different jms providers, can provider a send messages directly to provider b? If not, then can a subscriber to provider a act as a publisher to provider b?
What are the core JMS-related objects required for each JMS-enabled application?
What are the various message types supported by JMS?
Are you aware of any major JMS products available in the market?
How to handle the exception caused by jms?
What is the main parts of jms applications?
What is jms in websphere?