配置jboss的oracle,mysql数据源

jboss下配置MySql数据库：
1。将MySql的JDBC驱动程序放到CLASSPATH中；
2。将MySql的JDBC驱动程序放到jboss安装目录\server\default\lib 下；
3。将\docs \example\jca\mysql——ds.xml文件复制到\server\default\deploy下，下一步修改此文件；
4。修改mysql-ds.xml
   设置 :
    <?xml version="1.0" encoding="UTF-8"?>
 
  <!-- $Id: mysql-ds.xml 63175 2007-05-21 16:26:06Z rrajesh $ -->
  <!--  Datasource config for MySQL using 3.0.9 available from:
  http://www.mysql.com/downloads/api-jdbc-stable.html
  -->
 
  <datasources>
    <local-tx-datasource>
     <jndi-name>MySqlDS</jndi-name>
     <connection-url>jdbc:mysql://10.1.13.321:3306/cciccyx</connection-url>
     <driver-class>com.mysql.jdbc.Driver</driver-class>
     <user-name>用户名</user-name>
     <password>密码</password>
     <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
     <!-- should only be used on drivers after 3.22.1 with "ping" support
     <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
     -->
     <!-- sql to call when connection is created
     <new-connection-sql>some arbitrary sql</new-connection-sql>
       -->
     <!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers
     <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
       -->
 
     <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml -->
     <metadata>
        <type-mapping>mySQL</type-mapping>
     </metadata>
   </local-tx-datasource>
 </datasources>
   修改oracle-ds.xml 修改oracle-ds.xml

   设置 :

<?xml version="1.0" encoding="UTF-8"?>

<!-- ===================================================================== -->
<!--                                                                       -->
<!--  JBoss Server Configuration                                           -->
<!--                                                                       -->
<!-- ===================================================================== -->

<!-- $Id: oracle-ds.xml 63175 2007-05-21 16:26:06Z rrajesh $ -->
<!-- ==================================================================== -->
<!--  Datasource config for Oracle originally from Steven Coy             -->
<!-- ==================================================================== -->

<datasources>
  <local-tx-datasource>
    <jndi-name>OracleDS</jndi-name>
    <connection-url>jdbc:oracle:thin:@10.1.13.123:1521:dev</connection-url>
 <!--

  Here are a couple of the possible OCI configurations.
  For more information, see http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96654/toc.htm

 <connection-url>jdbc:oracle:oci:@youroracle-tns-name</connection-url>
  or
 <connection-url>jdbc:oracle:oci:@(description=(address=(host=youroraclehost)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=yourservicename)))</connection-url>

  Clearly, its better to have TNS set up properly.
  -->
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <user-name>用户名</user-name>
    <password>密码</password>
    <min-pool-size>0</min-pool-size>
    <max-pool-size>20</max-pool-size>
    <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
    <!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name-->
    <!-- Checks the Oracle error codes and messages for fatal errors -->
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
        <!-- sql to call when connection is created
        <new-connection-sql>some arbitrary sql</new-connection-sql>
        -->

        <!-- sql to call on an existing pooled connection when it is obtained from pool - the OracleValidConnectionChecker is prefered
        <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
        -->

      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml -->
      <metadata>
         <type-mapping>Oracle9i</type-mapping>
      </metadata>
  </local-tx-datasource>

</datasources>

5。修改hibernate.cfg.xml

mysql设置：
 <property name="connection.datasource">java:/MySqlDS</property>
    <property name="show_sql">false</property>
    <property name="hibernate.hbm2ddl.auto">update</property>
    <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
 <property name="hibernate.query.factory_class">
  org.hibernate.hql.classic.ClassicQueryTranslatorFactory
 </property>
 <property name="current_session_context_class">thread</property>
 
 
 oralce设置：
 <property name="connection.datasource">java:/OracleDS</property>
    <property name="show_sql">false</property>
    <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
    <property name="hibernate.query.factory_class">
  org.hibernate.hql.classic.ClassicQueryTranslatorFactory
 </property>
 <property name="current_session_context_class">thread</property>
 <property name="hibernate.connection.release_mode">auto</property>