Help adding a new datasource to jBoss 3.0

[matthicksj]

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

[matthicksj]

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