光子CI之旅

JBOSS_HOME
  +- modules
      +- com
          +- mysql
              +- main
                  +- module.xml
                  +- mysql-connector-java-5.1.15.jar   (mysql的jdbc驅(qū)動jar文件,版本根據(jù)各自情況而定)
                  +- mysql-connector-java-5.1.15.jar.index

<?xml version="1.0" encoding="UTF-8"?> 
<module xmlns="urn:jboss:module:1.0" name="com.mysql">
   <resources>
     <resource-root path="mysql-connector-java-5.1.15.jar"/>
   </resources>
   <dependencies>
     <module name="javax.api"/>
   </dependencies>
</module>

META-INF
META-INF/services com 
com/mysql com/mysql/jdbc 
com/mysql/jdbc/configs 
com/mysql/jdbc/exceptions 
com/mysql/jdbc/exceptions/jdbc4 
com/mysql/jdbc/interceptors 
com/mysql/jdbc/jdbc2 
com/mysql/jdbc/jdbc2/optional 
com/mysql/jdbc/jmx 
com/mysql/jdbc/log 
com/mysql/jdbc/profiler 
com/mysql/jdbc/util 
org 
org/gjt 
org/gjt/mm 
org/gjt/mm/mysql

<datasource jndi-name="java:jboss/datasources/MySqlDS" pool-name="MySqlDS" enabled="true" jta="true" use-java-context="true" use-ccm="true">
         <connection-url>
                 jdbc:mysql://192.168.1.150:3306/hospital?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=utf-8
         </connection-url>
         <driver>
                 com.mysql
         </driver>
         <transaction-isolation>
                 TRANSACTION_READ_COMMITTED
         </transaction-isolation>
         <pool>
                 <min-pool-size>
                         10
                 </min-pool-size>
                 <max-pool-size>
                         100
                 </max-pool-size>
                 <prefill>
                         true
                 </prefill>
                 <use-strict-min>
                         false
                 </use-strict-min>
                 <flush-strategy>
                         FailingConnectionOnly
                 </flush-strategy>
         </pool>
         <security>
                 <user-name>
                         runes
                 </user-name>
                 <password>
                         runes
                 </password>
         </security>
         <statement>
                 <prepared-statement-cache-size>
                         32
                 </prepared-statement-cache-size>
         </statement>
 </datasource>

<driver name="com.mysql" module="com.mysql">
         <xa-datasource-class>
                 com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
         </xa-datasource-class> 
</driver>