jboss-as-7.1.1.Final 配置Oracle数据源

馥954

一：加入Oracle驱动
 
在将Oracle驱动加入到${jboss_home}\module\com\oracle\main目录下（如果目录没有自行创建）
 
二：创建module.xml文件
 
 
在${jboss_home}\module\com\oracle\main目录下创建module.xml文件，文件内容为
 

<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.1" name="com.oracle">
<resources>
<resource-root path="ojdbc6-11.2.0.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
<module name="javax.servlet.api" optional="true"/>
</dependencies>
</module>

 
 
三：修改配置文件
打开${jboss_home}/standalone/configuration/standalone.xml文件
找到<datasources>节点，在该节点下添加如下内容：
 

<datasource jta="false" jndi-name="java:jboss/datasources/opsDS" pool-name="opsDS">
<connection-url>jdbc:oracle:thin:@192.168.0.110:1521:testdb</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver>oracle</driver>
<new-connection-sql>SELECT 1 FROM DUAL</new-connection-sql>
<pool>
<min-pool-size>10</min-pool-size>
<max-pool-size>100</max-pool-size>
<prefill>true</prefill>
</pool>
<security>
<security-domain>OPS</security-domain>
<!--
如果数据库密码不需要加密用下面配置
<user-name>paff</user-name>
<password>paff</password>
-->
</security>
<validation>
<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>
<check-valid-connection-sql>SELECT 1 FROM DUAL</check-valid-connection-sql>
<validate-on-match>false</validate-on-match>
<exception-sorter class-name="org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter"/>
</validation>
<timeout>
<blocking-timeout-millis>10000</blocking-timeout-millis>
<idle-timeout-minutes>1</idle-timeout-minutes>
</timeout>
<statement>
<track-statements>true</track-statements>
</statement>
</datasource>
<drivers>
<driver name="oracle" module="com.oracle">
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<xa-datasource-class>oracle.jdbc.xa.OracleXADataSource</xa-datasource-class>
</driver>
</drivers>
 Datasource其他参数配置见：http://www.jboss.org/schema/jbossas/jboss-as-datasources_1_0.xsd
 
 如果用到了security-domain配置，在${jboss_home}/standalone/configuration/standalone.xml文件中找到
<subsystem xmlns="urn:jboss:domain:security:1.1">节点，在 <security-domains>节点下，添加

<security-domain name="OPS">
<authentication>
<login-module code="SecureIdentity" flag="required">
<module-option name="username" value="paff"/>
<module-option name="password" value="-7009ff471602d737"/>
</login-module>
</authentication>
</security-domain>
 
四：密码加密生成

java -cp ${jboss_home}/modules/org/picketbox/main/picketbox-4.0.7.final.jar;${jboss_home}/modules/org/jboss/logging/main/jboss-logging-3.1.0.GA.jar org.picketbox.datasource.security.SecureIdentityLoginModule paff