（mysql,sqlserver,orcal）数据连接

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<!-- MYSQL -->
  <local-tx-datasource>
      <jndi-name>DefaultMySqlDs</jndi-name>
      <connection-url>jdbc:mysql:localhost:3306/foshanshop?useUnicode=true&amp;characterEncoding=GBK</connection-url>
      <driver-class>org.gjt.mm.sql.Driver</driver-class>
      <user-name>root</user-name>
      <password>000000</password>
      <min-pool-size>3</min-pool-size>
      <max-pool-size>32</max-pool-size>
      <blocking-imeout-millis>30000</blocking-imeout-millis>
      <idel-timeout-minutes>5</idel-timeout-minutes>
      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
      <metadate>
         <type-mapping>mySQL</type-mapping>
      </metadate>
  </local-tx-datasource>
 
 
  <!--SQL  -->
    <local-tx-datasource>
      <jndi-name>MSSQLDS</jndi-name>
      <connection-url>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=foshanshop</connection-url>
      <driver-class>com.microsoft.jdbc.sqlserver.SQLSserverDriver</driver-class>
      <user-name>sa</user-name>
      <password>000000</password>
      <min-pool-size>3</min-pool-size>
      <max-pool-size>32</max-pool-size>
      <blocking-imeout-millis>30000</blocking-imeout-millis>
      <idel-timeout-minutes>5</idel-timeout-minutes>
      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.SQLExceptionSorter</exception-sorter-class-name>
      <metadate>
         <type-mapping>MS SQLSERVER2000</type-mapping>
      </metadate>
  </local-tx-datasource>
 
 
    <!--ORALCE 9i  -->
    <local-tx-datasource>
      <jndi-name>OracleDS</jndi-name>
      <connection-url>jdbc:oracle:thin:@192.168.1.2:1521:FS</connection-url>
      <driver-class>oracle.jdbc.OracleDriver</driver-class>
      <user-name>sa</user-name>
      <password>000000</password>
      <min-pool-size>3</min-pool-size>
      <max-pool-size>32</max-pool-size>
      <blocking-imeout-millis>30000</blocking-imeout-millis>
      <idel-timeout-minutes>5</idel-timeout-minutes>
      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
      <metadate>
         <type-mapping>MS SQLSERVER2000</type-mapping>
      </metadate>
  </local-tx-datasource>
</datasources>