1 Reply Latest reply on Dec 12, 2001 2:40 PM by Matt Hicks

    Help adding a new datasource to jBoss 3.0

    Matt Hicks Newbie

      Could anyone post an example of how to add a non XA-compliant datasource to jBoss 3.0. I am attempting to use a weblogic driver for MS SQL Server 2000 and have it working in jBoss 2.4.3, but cannot figure out how to add it to 3.0. Thanks for any help

        • 1. Re: Help adding a new datasource to jBoss 3.0
          Matt Hicks Newbie

          I think I figured it out. This file seemed to work for me (just save it as sqlserver.xml and copy it into the deploy directory). Make sure to replace anything surrounded by *something* with your own values (username, password, etc.)

          <?xml version="1.0" encoding="UTF-8"?>


          <!-- ===================================================================== -->
          <!-- -->
          <!-- JBoss Server Configuration -->
          <!-- -->
          <!-- ===================================================================== -->

          <!-- $Id: mssqlserver-service.xml,v 1.0 2001/12/12 12:22:20 mhicks Exp $ -->







          <!-- ==================================================================== -->
          <!-- JDBC - Initialize the databases -->
          <!-- to ConnectionFactoryLoader -->
          <!-- ==================================================================== -->



          ConnectionURL=jdbc:weblogic:mssqlserver4:*DatabaseName*@*ServerName*:*ServerPort*
          DriverClass=weblogic.jdbc.mssqlserver4.Driver
          UserName=username
          Password=password

          *Your JNDI Name*
          java:/TransactionManager

          <mbean-ref name="ResourceAdapterName">JCA:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter</mbean-ref>
          <mbean-ref name="ConnectionManagerFactoryLoaderName">JCA:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</mbean-ref>
          #
          #Wed Aug 15 16:17:29 EDT 2001
          MinSize=5
          MaxSize=10
          BlockingTimeoutMillis=5000
          IdleTimeoutMinutes=30
          CleanupIntervalMinutes=10
          MaxIdleTimeoutPercent=1.0


          org.jboss.resource.security.ManyToOnePrincipalMapping

          UserName=sa