javax.jms.JMSException: Not supported in XA-backed session outside

Ranch Hand

Posts: 228

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hello Friends,

I am trying to setup OracleOJMS provider and tries to access queue and post to queue from a normal jsp for testing.

I am getting the following

javax.jms.JMSException: Not supported in XA-backed session outside global transaction
at oracle.j2ee.ra.jms.generic.RAUtils.make(RAUtils.java:525)
at oracle.j2ee.ra.jms.generic.RAUtils.toJMSException(RAUtils.java:199)
at oracle.j2ee.ra.jms.generic.RAUtils.toJMSException(RAUtils.java:210)
at oracle.j2ee.ra.jms.generic.CommonProducerWrapper.prepareForSend(CommonProducerWrapper.java:350)
at oracle.j2ee.ra.jms.generic.CommonProducerWrapper.send(CommonProducerWrapper.java:159)
at _ResourceProvider._jspService(_ResourceProvider.java:112)
at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.1.0) ].http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:453)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:591)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:515)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:711)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:216)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)

Steps i have done
ResourceProvider.jsp

<%@ page import="javax.jms.QueueConnectionFactory "%>
<%@ page import="javax.jms.XAQueueConnectionFactory "%>
<%@ page import="javax.jms.QueueConnection "%>
<%@ page import="javax.jms.QueueSession "%>
<%@ page import="javax.jms.Queue "%>
<%@ page import="javax.jms.QueueSender "%>
<%@ page import="javax.jms.Message "%>
<%@ page import="javax.jms.Session "%>
 
<%@ page import="javax.naming.Context "%>
<%@ page import="javax.naming.InitialContext "%>
 
<html>
  <head>
    <title>
      Configuration of ResourceProvider for Advanced Queueing
    </title>
  </head>
  <body>
    <form name="TestResourceProvider" method="GET">
    <%
      // Check if the message has to be enqueued
      if (request.getParameter("Message") != null){
 
        
        Context jndiContext = new InitialContext();
 
        XAQueueConnectionFactory queueCF = (XAQueueConnectionFactory)jndiContext.lookup
              ("java:comp/env/jms/InQueueCF");
        Queue queue = (Queue)jndiContext.lookup("java:comp/env/jms/InQueue");
        QueueConnection queueConnection = queueCF.createQueueConnection();
 
        // Start the Connection
        queueConnection.start();
        QueueSender sender = queueSession.createSender(queue);
        Message msg = queueSession.createTextMessage(request.getParameter("Message"));
        sender.send(msg);
        queueSession.commit();
        sender.close();
        queueSession.close();
        queueConnection.close();
    %>
    <%
      }else{
        // User can enter the message to be enqueued through here
    %>
        Enter the message to be enqueued
 
        <INPUT type="text" name="Message">
        <br><br>
        <input type="Submit" value="Enqueue Message">
    <%
      }
    %>
    </form>
  </body>
</html>

My Steps for OJMS PRovider
1. Creating AQ queue in DB
2. configuration of resource adapter and provider
3. configuration of connection factories for resourceadapter[jmsconnector]

1. Created the Queue table in DB using the sql 
 
DROP USER jmsuser CASCADE;
GRANT connect, resource,AQ_ADMINISTRATOR_ROLE TO jmsuser IDENTIFIED BY jmsuser;
GRANT execute ON sys.dbms_aqadm TO jmsuser;
GRANT execute ON sys.dbms_aq    TO jmsuser;
GRANT execute ON sys.dbms_aqin  TO jmsuser;
GRANT execute ON sys.dbms_aqjms TO jmsuser;
 
connect jmsuser/jmsuser;
-- Create table to hold the queue, then create queue.
-- For topics multiple_consumers must be true
BEGIN
   DBMS_AQADM.CREATE_QUEUE_TABLE( Queue_table => 'SMSCP_INQTBL', Queue_payload_type => 'SYS.AQ$_JMS_MESSAGE',
        sort_list => 'PRIORITY,ENQ_TIME',  multiple_consumers => false, compatible => '8.1.5');
   DBMS_AQADM.CREATE_QUEUE(  Queue_name => 'SMSCP_INQ',  Queue_table => 'SMSCP_INQTBL');
   DBMS_AQADM.START_QUEUE(queue_name => 'SMSCP_INQ');
END;
/
quit;
 
Now our queue Name is queue Name : SMSCP_INQ table Name: SMSCP_INQTBL
2. Creating the Cp and datasource for the db [jmsuser] to make java to access queue
Creating ConnectionPool jmsDBPool
Creating DataSource  jmsDBDataSource
Jndi jdbc jdbc/JMSDBDS
 
After creating, i got the following data-sources.xml
 
DATASOURCES.XML
---------------------
<?xml version = '1.0' encoding = 'UTF-8'?>
<data-sources xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://xmlns.oracle.com/oracleas/schema/data-sources-10_1.xsd" schema-major-version="10" schema-minor-version="1">

   <managed-data-source connection-pool-name="Example Connection Pool" jndi-name="jdbc/OracleDS" name="OracleDS"/>
      
  <managed-data-source connection-pool-name="jmsDBPool" jndi-name="jdbc/JMSDBDS" name="jmsDBDataSource"/>

   <connection-pool name="Example Connection Pool">
      <connection-factory factory-class="oracle.jdbc.pool.OracleDataSource" user="scott" password="tiger" url="jdbc :-o	 racle:thin:@//localhost:1521/ORCL"/>
   </connection-pool>
   
   <connection-pool name="jmsDBPool">
      <connection-factory factory-class="oracle.jdbc.pool.OracleDataSource" user="jmsuser" password="jmsuser" url="jdbc :-o	 racle:thin:@//localhost:1521/xe"/>
   </connection-pool>
</data-sources>
 
3. JMS Connector Task. Customising the ra.xml
 
ra.xml
-------

  <resourceadapter>
    <resourceadapter-class>oracle.j2ee.ra.jms.generic.JMSResourceAdapter</resourceadapter-class>
      <config-property>
        <config-property-name>lookupMethod</config-property-name>
        <config-property-type>java.lang.String</config-property-type>
        <config-property-value>resourceProvider</config-property-value>
      </config-property>
      <config-property>
        <config-property-name>resourceProviderName</config-property-name>
        <config-property-type>java.lang.String</config-property-type>
        <config-property-value>testResourceProvider</config-property-value>
      </config-property>
 

   
<adminobject>
            <adminobject-interface>javax.jms.Queue</adminobject-interface>
            <adminobject-class>oracle.j2ee.ra.jms.generic.AdminObjectQueueImpl</adminobject-class>
            <config-property>
                <config-property-name>jndiName</config-property-name>
                <config-property-type>java.lang.String</config-property-type>
                <config-property-value>Queues/MY_QUEUE</config-property-value>
            </config-property>
            <config-property>
                <config-property-name>resourceProviderName</config-property-name>
                <config-property-type>java.lang.String</config-property-type>
                <config-property-value>testResourceProvider</config-property-value>
            </config-property>
        </adminobject>
 

        <adminobject>
            <adminobject-interface>javax.jms.Queue</adminobject-interface>
            <adminobject-class>oracle.j2ee.ra.jms.generic.AdminObjectQueueImpl</adminobject-class>
            <config-property>
                <config-property-name>resourceProviderName</config-property-name>
                <config-property-type>java.lang.String</config-property-type>
                <config-property-value>testResourceProvider</config-property-value>
            </config-property>
        </adminobject>

<adminobject>
            <adminobject-interface>javax.jms.Topic</adminobject-interface>
            <adminobject-class>oracle.j2ee.ra.jms.generic.AdminObjectTopicImpl</adminobject-class>
            <config-property>
                <config-property-name>resourceProviderName</config-property-name>
                <config-property-type>java.lang.String</config-property-type>
                <config-property-value>testResourceProvider</config-property-value>
            </config-property>
        </adminobject>
 
    </resourceadapter>
 
4. Create a JMS Connector INstance
oc4j-connectors.xml
<connector name="testResourceAdapter" path="testResourceAdapter.rar">
<config-property name="lookupMethod" value="resourceProvider"/>
<config-property name="resourceProviderName" value="testResourceProvider"/>


</connector>
 
5. RA Connection Factories
<?xml version="1.0" encoding="UTF-8"?>
 
<oc4j-connector-factories xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                          xsi:noNamespaceSchemaLocation="http://xmlns.oracle.com/oracleas/schema/oc4j-connector-factories-10_0.xsd"
                          schema-major-version="10"
                          schema-minor-version="0">
   <connector-factory location="resourceAdapterXAQCF/MYXAQCF" connector-name="testResourceAdapter">
        <config-property name="jndiLocation" value="XAQueueConnectionFactories/XAQCF"/>
                <connection-pooling use="private">
                  <property name="waitTimeout" value="300" />
                  <property name="scheme" value="fixed_wait" />
                  <property name="maxConnections" value="50" />
                  <property name="minConnections" value="0" />
            </connection-pooling>
        <connectionfactory-interface>javax.jms.XAQueueConnectionFactory</connectionfactory-interface>
    </connector-factory>
</oc4j-connector-factories>

orion-web.xml
<?xml version="1.0"?>
 
<orion-web-app
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://xmlns.oracle.com/oracleas/schema/orion-web-10_0.xsd" deployment-version="10.1.3.1.0"
deployment-time="1218369811921"
jsp-cache-directory="./persistence"
jsp-cache-tlds="standard"
temporary-directory="./temp"
context-root="/smscpReceiver"
 schema-major-version="10" schema-minor-version="0" >

<resource-ref-mapping name="jms/InQueueCF" location="resourceAdapterXAQCF/MYXAQCF" />
<message-destination-ref-mapping location="resourceAdapterInQ/MYINQ" name="jms/InQueue">
</message-destination-ref-mapping>
<web-app>
</web-app>
</orion-web-app>

web.xml
 
 <resource-ref>
 <res-ref-name>jms/InQueueCF</res-ref-name>
 <res-type>javax.jms.XAQueueConnectionFactory</res-type>
<res-auth>Container</res-auth>
 </resource-ref>
  
  <message-destination-ref>
  
  <message-destination-ref-name>jms/InQueue</message-destination-ref-name>
  <message-destination-type>javax.jms.Queue</message-destination-type>
   <message-destination-usage>Produces</message-destination-usage>
  <message-destination-link>jms/InQueue</message-destination-link>
  </message-destination-ref>
   <message-destination>
           <message-destination-name>jms/InQueue</message-destination-name>
   </message-destination>

SCJP 1.4 SCWCD 1.4 SCDJWS 1.4

Karthik Rajendiran

Ranch Hand

Posts: 228

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Issue Got Solved.

1. Reason Servlet/jsp connects to queue using xaqueueconnectionfactory,
since they are not coded within transaction, we cannot use xaconnectionfactory.

Instead i replaced the factory with normal queueconnectionfactory and i was able to post the data to queue

And suppose if you want to use xaqueueconnfactory, we should use it within transaction or inside ejb or mdb

SCJP 1.4 SCWCD 1.4 SCDJWS 1.4

Where all the women are strong, all the men are good looking and all the tiny ads are above average:

a bit of art, as a gift, that will fit in a stocking

https://gardener-gift.com