ATG OOTB SqlJMSAdmin

Today I would like to share about one of the less used but effective tool SQLJMSAdmin that is shipped by Oracle along with ATG install.

How does it help?
There is a need to administer and monitor JMS messages once you begin using SQL JMS Provider in your application. Since SQL JMS stores message states in database, you have two choices:

1. Use DML statements as specified in documentation to query message build up or
2. Use SQLJMSAdmin, a browser based administration tool for SQL JMS 

How to configure?

1. If your application server
• Jboss: Modify <ATG_INSTALL_FOLDER>\SQLJMSAdmin\j2ee-apps\sqlJmsAdmin\ejbModule\META-INF\jboss.xml with appropriate Core datasource (same as Order repository DataSource)
• Weblogic: Modify all enterprise bean definitions in file <ATG_INSTALL_FOLDER>\SQLJMSAdmin\j2ee-apps\sqlJmsAdmin\ejbModule\META-INF\weblogic-ejb-jar.xml to include Core datasource, for example

 ...  
  <weblogic-enterprise-bean>  
   <ejb-name>DMSTopicSubscription</ejb-name>  
   <reference-descriptor>  
    <resource-description>  
    <res-ref-name>jdbc/datasource</res-ref-name>  
    <jndi-name>atg_core</jndi-name>  
    </resource-description>  
   </reference-descriptor>    
   <enable-call-by-reference>True</enable-call-by-reference>  
  </weblogic-enterprise-bean>  
 ...  

2. You need to add "SQLJMSAdmin" to runAssembler task so that it is included in the ear file

How to use it?

Once the ear is built including SQLJMSAdmin module, you can access the administration tool at http://<host>:<port>/sqlJmsAdmin.

When prompted for credentials, use the same credentials as in Dynamo Administration Tool. Now you access to monitor message build up

Fig 1: SQLJmsAdmin Dashboard

Fig 2: Messages in a Queue

if you look at Fig2, you can see choices to move messages from let's say a DeadLetterQueue to a Normal Queue like "SubmitToOMS" to be retried.