1 Reply Latest reply on Jul 23, 2002 9:38 AM by David Jencks

    Transcational datasource for Oracle Jboss 3.0

    Anil Bholankar Newbie

      HI,
      I am facing problem in creating a XADataSource.Can some one give an sample config file.Whats wrong in my config file.
      This is my config...



      <!-- ==================================================================== -->
      <!-- ConnectionManager setup for xa informix dbs -->
      <!-- Thanks to Larry Sanderson (larrys@mrstock.com) -->
      <!-- Build jmx-api (build/build.sh all) and view for config documentation -->
      <!-- ==================================================================== -->


      <!--make the rar deploy! hack till better deployment-->
      jboss.jca:service=RARDeployer


      <depends optional-attribute-name="ManagedConnectionFactoryName">
      <!--embedded mbean-->

      <!--hack-->
      <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=Minerva JDBC XATransaction ResourceAdapter

      <!--real attributes-->


      <config-property>
      <config-property-name>XADataSourceClass</config-property-name>
      <config-property-type>java.lang.String</config-property-type>
      <config-property-value>oracle.jdbc.xa.client.OracleXADataSource</config-property-value>
      </config-property>
      <config-property>
      <config-property-name>XADataSourceProperties</config-property-name>
      <config-property-type>java.lang.String</config-property-type>
      <config-property-value>URL="jdbc:oracle:thin:@172.20.10.252:1521:trade"</config-property-value>
      </config-property>
      <config-property>
      <config-property-name>UserName</config-property-name>
      <config-property-type>java.lang.String</config-property-type>
      <config-property-value>daljit</config-property-value>
      </config-property>
      <config-property>
      <config-property-name>Password</config-property-name>
      <config-property-type>java.lang.String</config-property-type>
      <config-property-value>daljit</config-property-value>
      </config-property>
      <config-property>
      <config-property-name>TransactionIsolation</config-property-name>
      <config-property-type>java.lang.String</config-property-type>
      <config-property-value>TRANSACTION_READ_COMMITTED</config-property-value>
      </config-property>


      demoPoolDS


      <depends optional-attribute-name="ManagedConnectionPool">
      <!--embedded mbean-->


      0
      50
      5000
      15
      <!--criteria indicates if Subject (from security domain) or app supplied
      parameters (such as from getConnection(user, pw)) are used to distinguish
      connections in the pool. Choices are
      ByContainerAndApplication (use both),
      ByContainer (use Subject),
      ByApplication (use app supplied params only),
      ByNothing (all connections are equivalent, usually if adapter supports
      reauthentication)-->
      ByContainer


      <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager

      <!-- Include a login module configuration named InformixXaDbRealm.
      Update your login-conf.xml, here is an example for a
      ConfiguredIdentityLoginModule:

      <application-policy name = "InformixXaDbRealm">

      <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required">
      <module-option name = "principal">yourprincipal</module-option>
      <module-option name = "userName">yourusername</module-option>
      <module-option name = "password">yourpassword</module-option>
      <module-option name = "managedConnectionFactoryName">jboss.jca:service=XATxCM,name=demoPoolDS</module-option>
      </login-module>

      </application-policy>

      NOTE: the application-policy name attribute must match SecurityDomainJndiName, and the
      module-option name = "managedConnectionFactoryName"
      must match the object name of the ConnectionManager you are configuring here.
      -->
      <!--uncomment out this line if you are using the InformixXaDbRealm above
      InformixXaDbRealm
      -->

      <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:name=JaasSecurityManager

      java:/TransactionManager




      Also We need to configure JMS.Any Help is appericated.
      Thanks,
      Anil

        • 1. Re: Transcational datasource for Oracle Jboss 3.0
          David Jencks Master

          For Oracle xa you need to use 3.0.1 or 3.1 (cvs HEAD). There is a sample oracle-xa-service.xml file, you also need to find and modify the XidFactory mbean as noted in the sample file. If you are using 3.1 you can try the simplified configuration in oracle-xa-ds.xml. (these files are in cvs in jbosscx/src/etc/example-config. Check the cvs tags to make sure you get the right version for your jboss version. I need to update most of the 3.1 **-service.xml files to move the JndiName attibute up one level to the ConnectionManager mbean.)