1.创建oracle驱动模块目录
$ cd $JBOSS_HOME/modules $ mkdir -p com/oracle/ojdbc14/main $ vi module.xml
将以下内容复制到新建的module.xml中
<module xmlns="urn:jboss:module:1.0" name="com.oracle.ojdbc14"> <resources> <resource-root path="ojdbc14.jar"/> </resources> <dependencies> <module name="javax.api"/> </dependencies> </module>
拷贝ojdbc14.jar到$JBOSS_HOME/modules/com/oracle/ojdbc14/main
2.配置数据源
打开$JBOSS_HOME/standalone/configuration/standalone.xml,找到<datasources>...</datasources>部分,修改中间部分为
<datasource enabled="true" jndi-name="myDataSource" jta="true" pool-name="OraclesqlDS" use-ccm="true" use-java-context="true"> <connection-url> jdbc:oracle:thin:@ip:sid </connection-url> <driver> oracle </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> user </user-name> <password> pwd </password> </security> </datasource> <drivers> <driver module="com.oracle.ojdbc14" name="oracle"> <driver-class>oracle.jdbc.OracleDriver</driver-class> <xa-datasource-class> oracle.jdbc.xa.client.OracleXADataSource </xa-datasource-class> </driver> </drivers>
这里要注意,因为ojdbc14.jar驱动不是jdbc4驱动,里面的META-INF中没有驱动描述和 一个叫java.sql.Driver的文件,所以我们要在<driver></dirver>中加入<diriver-class>oracle.jdbc.OracleDriver</driver-class>来指定(如果用oralce11的驱动就没必要了)