中文版在 http://vase.iteye.com/blog/1299425
Create oracle DataSource Steps :
- Install driver as core module
- Create folder at EAP_HOME/modules/
Name is main. |
我自己的module.xml
<?xml version="1.0" encoding="UTF-8"?> <module xmlns="urn:jboss:module:1.1" name="jdbc.oracle">
<resources> <resource-root path="ojdbc14.jar"/>
</resources> <dependencies> <module name="javax.api"/> <module name="javax.transaction.api"/> </dependencies> </module> |
2.Use CLI to install the driver 《这里是用JBOSS的CLI改的standalone.xml,也可参照最后直接改》
Under EAP_HOME/runtimes/jboss-eap/bin run jboss-cli.bat |
connect |
Copy and modify below content to cmd and run /subsystem =datasources/jdbc-driver=DRIVER_NAME:add(drivernam e=DRIVER_NAME,driver-m odule-nam e=MODULE_NAME,driver-xa-datasource-classnam e=XA_DATASOURCE_CLASS_NAME)
example: 《这里的driver-module-name与前面的module.xml里的name对应》 /subsystem =datasources/jdbc-driver=oracle:add(driver-name=oracle,driver-module-name=jdbc.oracle,driver-xa-datasource-class-name=oracle.jdbc.xa.client.OracleXADataSource) |
Return success means you have installed the driver |
Important (如果你用的是ORACLE 10G) 这里要注意,因为ojdbc14.jar驱动不是jdbc4驱动,里面的META-INF中没有驱动描述和 一个叫java.sql.Driver的文件,所以我们要在中加入oracle.jdbc.OracleDriver来指定(如果用oralce11的驱动就没必要了)
也就是说还要在 standalone.xml作一些修改(加入彩色部分): <driver name="oracle" module="jdbc.oracle"> <driver-class>oracle.jdbc.OracleDriver</driver-class> <xa-datasource-class> oracle.jdbc.xa.client.OracleXADataSource </xa-datasource-class> </driver>
《Refer to http://vase.iteye.com/blog/1299425 》 |
3.Install DataSource
Login in http://localhost:9990/console/App.html#datasources ,make sure you are in Profile tab (top-right Conner ) |
Add Jndi -------java:jboss/datasource/OracleDS connection-url----------jdbc:oracle:thin:@localhost:1521:xe |
Test at bottom connection tab |
改两个地方:
<datasource jta="false" jndi-name="java:jboss/datasource/OracleDS" pool-name="OracleDS" enabled="true" use-ccm="false"> <connection-url>jdbc:oracle:thin:@localhost:1521:xe</connection-url> <driver-class>oracle.jdbc.OracleDriver</driver-class> <driver>oracle</driver> <security> <user-name>xxx</user-name> <password>xxx</password> </security> <validation> <validate-on-match>false</validate-on-match> <background-validation>false</background-validation> </validation> <statement> <share-prepared-statements>false</share-prepared-statements> </statement> </datasource> --------------------------------------------------------------------------------------------------------- <drivers> <driver name="h2" module="com.h2database.h2"> <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class> </driver> <driver name="oracle" module="jdbc.oracle"> <driver-class>oracle.jdbc.OracleDriver</driver-class> <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class> </driver> </drivers>