JBOSS_JNDI数据源配置

1、在applicationContext.xml中配置如下

<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
  <property name="jndiName">
  <value>java:jdbc/CrmRs</value>
  </property>
 </bean>

 

2、在 JBOSS根目录/server/default/deploy下增加oracle-ds.xml，配置如下

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
  <local-tx-datasource>
    <jndi-name>jdbc/CrmRs</jndi-name>
    <connection-url>jdbc:oracle:thin:@192.168.0.26:1521:OIPS</connection-url>
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <user-name>system</user-name>
    <password>sys</password>

    <exception-sorter-class-name>

       org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter

    </exception-sorter-class-name>
    <metadata>
       <type-mapping>Oracle9i</type-mapping>
    </metadata>
  </local-tx-datasource>
</datasources>