<?xml version="1.0" encoding="UTF-8"?>
<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->
<!-- ======================================================================-->
<!-- New ConnectionManager setup for jTDS Sybase/Mcrosoft SQL Server driver-->
<!-- You may download the latest jTDS driver from *SourceForge* -->
<!-- http://jtds.sourceforge.net -->
<!-- ===================================================================== -->
<datasources>
<local-tx-datasource>
<jndi-name>his</jndi-name>
<connection-url>jdbc:sqlserver://127.0.0.1:1433;databaseName=HIS</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<user-name>sa</user-name>
<password>123456@byd</password>
<!-- <min-pool-size>5</min-pool-size>
<max-pool-size>5</max-pool-size>
-->
<prefill>true</prefill>
<!-- sql to call when connection is created-->
<!-- <new-connection-sql>select count(*) from dbo.Applog</new-connection-sql>
-->
<!-- sql to call on an existing pooled connection when it is obtained from pool -->
<!-- <check-valid-connection-sql>select count(*) from dbo.Applog</check-valid-connection-sql>
-->
<!----> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.SqlServerExceptionSorter</exception-sorter-class-name>
<min-pool-size>5</min-pool-size>
<max-pool-size>5</max-pool-size>
<idle-timeout-minutes>1</idle-timeout-minutes>
<prepared-statement-cache-size>32</prepared-statement-cache-size>
<check-valid-connection-sql>select 1 from HIS.dbo.TRP</check-valid-connection-sql>
<new-connection-sql>select 1 from HIS.dbo.TRP</new-connection-sql>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.SqlServerExceptionSorter</exception-sorter-class-name>
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.SqlServerValidConnectionChecker
</valid-connection-checker-class-name>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml -->
<metadata>
<type-mapping>MS SQLSERVER2005</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->
<!-- ======================================================================-->
<!-- New ConnectionManager setup for jTDS Sybase/Mcrosoft SQL Server driver-->
<!-- You may download the latest jTDS driver from *SourceForge* -->
<!-- http://jtds.sourceforge.net -->
<!-- ===================================================================== -->
<datasources>
<local-tx-datasource>
<jndi-name>his</jndi-name>
<connection-url>jdbc:sqlserver://127.0.0.1:1433;databaseName=HIS</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<user-name>sa</user-name>
<password>123456@byd</password>
<!-- <min-pool-size>5</min-pool-size>
<max-pool-size>5</max-pool-size>
-->
<prefill>true</prefill>
<!-- sql to call when connection is created-->
<!-- <new-connection-sql>select count(*) from dbo.Applog</new-connection-sql>
-->
<!-- sql to call on an existing pooled connection when it is obtained from pool -->
<!-- <check-valid-connection-sql>select count(*) from dbo.Applog</check-valid-connection-sql>
-->
<!----> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.SqlServerExceptionSorter</exception-sorter-class-name>
<min-pool-size>5</min-pool-size>
<max-pool-size>5</max-pool-size>
<idle-timeout-minutes>1</idle-timeout-minutes>
<prepared-statement-cache-size>32</prepared-statement-cache-size>
<check-valid-connection-sql>select 1 from HIS.dbo.TRP</check-valid-connection-sql>
<new-connection-sql>select 1 from HIS.dbo.TRP</new-connection-sql>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.SqlServerExceptionSorter</exception-sorter-class-name>
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.SqlServerValidConnectionChecker
</valid-connection-checker-class-name>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml -->
<metadata>
<type-mapping>MS SQLSERVER2005</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>