Here's a mssql-xa-server.xml, for using Microsoft SQL Server 2000 with
Microsoft's JDBC driver.
<?xml version="1.0" encoding="UTF-8"?>
<!--
=====================================================================
-->
<!--
-->
<!-- JBoss Server Configuration
-->
<!--
-->
<!--
=====================================================================
-->
<server>
<!--
==================================================================== -->
<!-- ConnectionManager setup for xa Microsoft SQL Server 2000, using
-->
<!-- Microsoft's JDBC driver.
-->
<!--
==================================================================== -->
<mbean
code="org.jboss.resource.connectionmanager.XATxConnectionManager"
name="jboss.jca:service=XATxCM,name=MSSQLXaDS">
<!--make the rar deploy! hack till better deployment-->
<depends>jboss.jca:service=RARDeployer</depends>
<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->
<mbean code="org.jboss.resource.connectionmanager.RARDeployment"
name="jboss.jca:service=XATxDS,name=MSSQLXaDS">
<!--hack-->
<depends
optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployme
nt,name=Minerva JDBC XATransaction ResourceAdapter</depends>
<!--real attributes-->
<attribute name="ManagedConnectionFactoryProperties">
<properties>
<config-property>
<config-property-name>XADataSourceClass</config-property-name>
<config-property-type>java.lang.String</config-property-type>
<config-property-value>com.microsoft.jdbcx.sqlserver.SQLServerDataSource
</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>ServerName=yourserver;DatabaseName=yourdatabasena
me;SelectMethod=cursor</config-property-value>
</config-property>
</properties>
</attribute>
<attribute name="JndiName">MSSQLXaDS</attribute>
</mbean>
</depends>
<depends optional-attribute-name="ManagedConnectionPool">
<!--embedded mbean-->
<mbean
code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool"
name="jboss.jca:service=XATxPool,name=MSSQLXaDS">
<attribute name="MinSize">0</attribute>
<attribute name="MaxSize">50</attribute>
<attribute name="BlockingTimeoutMillis">5000</attribute>
<attribute name="IdleTimeoutMinutes">15</attribute>
<!--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)-->
<attribute name="Criteria">ByContainer</attribute>
</mbean>
</depends>
<depends
optional-attribute-name="CachedConnectionManager">jboss.jca:service=Cach
edConnectionManager</depends>
<!-- Include a login module configuration named MSSQLXaDbRealm.
Update your login-conf.xml, here is an example for a
ConfiguredIdentityLoginModule:
<application-policy name = "MSSQLXaDbRealm">
<authentication>
<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=MSSQLXaDS</
module-option>
</login-module>
</authentication>
</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 MSSQLXaDbRealm
above
<attribute name="SecurityDomainJndiName">MSSQLXaDbRealm</attribute>
-->
<depends
optional-attribute-name="JaasSecurityManagerService">jboss.security:name
=JaasSecurityManager</depends>
<attribute
name="TransactionManager">java:/TransactionManager</attribute>
</mbean>
</server>
----------------------------------------------------------------------------
Bringing you mounds of caffeinated joy
>>> http://thinkgeek.com/sf <<<
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
