Database Side Configuration:-
1. Create
User
Create
user "aquser"
Password : aiadbsys
Password : aiadbsys
2. Grant Permissions
connect
/ as sysdba;
Grant
connect, resource TO aquser;
Grant
aq_user_role TO aquser;
Grant
execute ON sys.dbms_aqadm TO aquser;
Grant
execute ON sys.dbms_aq TO aquser;
Grant execute ON sys.dbms_aqin TO aquser;
Grant execute ON sys.dbms_aqjms TO aquser;
Grant execute ON sys.dbms_aqin TO aquser;
Grant execute ON sys.dbms_aqjms TO aquser;
3. Create
AQ Queue
dbms_aqadm.create_queue_table(
queue_table =>"AQ_QUEUE",
queue_payload_type =>'sys.aq$_jms_text_message',
multiple_consumers =>false
);
queue_table =>"AQ_QUEUE",
queue_payload_type =>'sys.aq$_jms_text_message',
multiple_consumers =>false
);
dbms_aqadm.create_queue(
queue_name=>'AIA_AQJMS',
queue_table=>'AQ_QUEUE'
);
queue_name=>'AIA_AQJMS',
queue_table=>'AQ_QUEUE'
);
4.
Start AQ
exec
dbms_aqadm.stop_queue(“AIA_AQJMS”)
exec
dbms_aqadm.start_queue(“AIA_AQJMS”)
Weblogic Side Configuration (AIA )
1.
Configure New Multi Data Source “AIAAQJMS”. Set JNDI name “jdbc/aqjms”
Navigate
to Services -> Data Sources -> Multi Data Source
2. Set
JNDI Name as jdbc/aqjms
Select
the target as Soa Cluster
Select
“XA Driver”
Select
Database Driver as shown below
Provide
Database specific details
2.
Configure a New JMS Module “AQJMSModule”.
Navigate
to Messaging -> JMS Modules. Create a new module “AQJmsQueue”
Type
in Local JNDI and Remote JNDI Name – jms/aqjmsdest and Queues/AIA_AQJMS
3.
In JMS Module, Create a New Foreign Server “AQForeignServer”. Set Initial
Context Factory to oracle.jms.AQJmsInitialContextFactory. Associate JNDI
Properties to JNDI configured in first step i.e. “jdbc/aqjms”
4.
Configure Foreign Destination “AQjmsQueue” with local JNDI Name and Foreign JNDI
Name. Local JNDI Name – “jms/aqjmsdest”. Remote JNDI Name – “Queues/AIA_AQJMS”
5.
Configure New Connection Factory “AQJmsConnectionFactory. Set Local JNDI Name
to “jms/aqjmscf” and Remote JNDI to “XAQueueConnectionFactory”
6.
Update JMS Adapter. Navigate to Deployment Tab and then to JMS Resource Adapter
Link. Select Configuration -> Outbound Connection Pools. Create a new
connection pool “AQConnection”. Set the connection factory location to
“jdbc/aqjms” configured in first step.
0 comments:
Post a Comment