solar_sea

<?xml version="1.0" encoding="UTF-8"?>
<!--
 *
 * Microsoft SQL Server XA DataSource for BIS/AS with jTDS driver.
 *
 * $Id: JTDS_SeeAS-xa-ds.xml.template,v 1.6 2007/06/13 11:34:00 pollaehn Exp $
 *
 * Based on
 * software/resources/jboss-mssql/template/JTDS_SeeAS-xa-ds-xml.template
 *
 * Copyright (c) 2005 SEEBURGER AG, Germany. All rights reserved.
-->

<!-- This file is automatically generated by register-jboss-mssql.xml -->

<datasources>
  <xa-datasource>
    <!-- The jndi name of the DataSource, it is prefixed with java:/
         Datasources are not available outside the virtual machine -->
    <!-- TODO: JNDI Name -Ec -->
    <jndi-name>WORKFLOWDB</jndi-name>
    <track-connection-by-tx>true</track-connection-by-tx>
    <isSameRM-override-value>false</isSameRM-override-value>
    <xa-datasource-class>net.sourceforge.jtds.jdbcx.JtdsDataSource</xa-datasource-class>
    <xa-datasource-property name="ServerName">localhost</xa-datasource-property>
    <xa-datasource-property name="PortNumber">1433</xa-datasource-property>
    <xa-datasource-property name="DatabaseName">b632tl_uc</xa-datasource-property>
    <xa-datasource-property name="Tds">8.0</xa-datasource-property>
    <security-domain>WORKFLOWDBlogin</security-domain>
    <!--transaction isolation-->
    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
    <!--pooling parameters-->
    <min-pool-size>5</min-pool-size>
    <max-pool-size>100</max-pool-size>
    <blocking-timeout-millis>60000</blocking-timeout-millis>
    <idle-timeout-minutes>15</idle-timeout-minutes>

    <!-- Track statements. Use nowarn for producion and true for testing -->
    <track-statements>true</track-statements>
    -->
    <!-- HA
    <valid-connection-sql>SELECT 1</valid-connection-sql>
    -->
    <!-- <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.*</valid-connection-checker-class-name> -->

    <!-- You are recommended to use prepareSql=2 with true distributed transactions.
         If a temp stored procedure is created and then the container rolls back the
         transaction, the driver's procedure cache will be out of line with the server. -->
    <xa-datasource-property name="PrepareSql">2</xa-datasource-property>
    <!-- Set this property to true to cause the driver to emulate distributed transactions.
         False option only works for SQL Server 2000 with MSDTC and JtdsXA.DLL installed. -->
    <xa-datasource-property name="XaEmulation">true</xa-datasource-property>
    <!-- set this property to true if and only if the database uses unicode column types
         like nvarchar. Otherwise set it to false -->
    <xa-datasource-property name="SendStringParametersAsUnicode">false</xa-datasource-property>
    <!-- Use this property to enable logging but NB: jTDS produces lots of output!
    <xa-datasource-property name="LogFile">${bisas.log}/jboss-SEEASDB0.txt</xa-datasource-property>
    -->
      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
      <metadata>
         <type-mapping>MS SQLSERVER2000</type-mapping>
      </metadata>
  </xa-datasource>

</datasources>