jboss配置oracle连接池

http://www.blogjava.net/zylrandom/articles/101501.html
http://wangrl.iteye.com/blog/1297770
http://hi.baidu.com/panqf/blog/item/120a4c0e30db91c87bcbe137.html
==============================================================


1、在$:\jboss-4.0.5.GA\server\default\deploy目录下添加Oracle-ds.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
  <local-tx-datasource>
    <jndi-name>OracleDS</jndi-name>
    <use-java-context>false</use-java-context>
    <connection-url>jdbc:oracle:thin:@192.168.100.65:1521:orcl</connection-url>
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <user-name>user_01</user-name>
    <password>123456</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
</exception-sorter-class-name>
      <metadata>
         <type-mapping>Oracle10g</type-mapping>
      </metadata>
  </local-tx-datasource>
</datasources>

注解：其中OracleDS是连接池的名称。192.168.100.65是数据库地址。orcl是数据库实例名

2、项目的web.xml中需要有
<resource-ref>
<res-ref-name>jdbc/zccxds</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>CONTAINER</res-auth>
</resource-ref>

3、jboss-web.xml中配置连接池映射
<jboss-web>
    <context-root>/zccx</context-root>
    <resource-ref>
        <res-ref-name>jdbc/zccxds</res-ref-name>
        <jndi-name>OracleDS</jndi-name>
    </resource-ref>
</jboss-web>

4、启用spring 连接池方式的datasource
<bean
id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean" >
<property name="jndiName">
<value>java:comp/env/jdbc/zccxds</value>
</property>
</bean>