Oracle数据源配置
前提:
JBOSS_HOME=jboss的home目录(安装目录)
有测试JBoss4.2.0-GA版本
数据源的jndi名字为OracleDS
配置密码为明码的Oracle数据源
1 将%JBOSS_HOME%/docs/examples/jca/oracle-ds.xml copy
到%JBOSS_HOME%/server/default/deploy目录下
2 打开oracle-ds.xml,做如下编辑
A 修改jndi名字 <jndi-name>
OracleDS</jndi-name>
B 修改db url <connection-url>
jdbc:oracle:thin:@localhost:1521:yyaccp</connection-url>
C 修改驱动
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
D 修改用户名和密码
<user-name>noble</user-name>
<password>yyaccp</password>
3 打开 %JBOSS_HOME%/server/default/conf/standardjbosscmp-jdbc.xml
修改数据源
<datasource>java:/OracleDS</datasource>
4 打开 %JBOSS_HOME%/server/default/conf/ login-config.xml
将如下内容copy到文件最后
<application-policy name = "
OracleDbRealm">
<authentication>
<login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required">
<module-option name = "principal">OracleDS</module-option>
<module-option name = "userName">noble</module-option>
<module-option name = "password">yyaccp</module-option>
<module-option name = "managedConnectionFactoryName">
jboss.jca:service=LocalTxCM,name=
OracleDS
</module-option>
</login-module>
</authentication>
</application-policy>
5 将Oracle驱动程序,copy到 %JBOSS_HOME%/ server/default/lib目录下
6 完成Jboss 的Oracle数据源配置
如上操作,完成了jboss基本的数据源配置,但配置文件中有密码的明码,不安全,如下介绍是怎么对密码进行加密的配置
1 生成加密密码
A 进入dos命令行模式
B Set JBOSS_HOME环境变量
C java -cp
%JBOSS_HOME%/lib/jboss-jmx.jar;%JBOSS_HOME%/lib/jboss-common.jar;%JBOSS_HOME%/server/default/lib/jboss-jca.jar;%JBOSS_HOME%/server/default/lib/jbosssx.jar org.jboss.resource.security.SecureIdentityLoginModule yyaccp
D 生成yyaccp的加密密码: 7236463cd79f258f
2 按上面的配置一样重复配置
3 修改%JBOSS_HOME%/server/default/deploy/oracle-ds.xml
用 <security-domain>
EncryptDBPassword</security-domain> 替换以前的
<user-name>noble</user-name>
<password>yyaccp</password>
4 打开 %JBOSS_HOME%/server/default/conf/ login-config.xml
A 将<application-policy name = "OracleDbRealm">
改成
<application-policy name = "
EncryptDBPassword">
B 将<login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required"> 改成
<login-module code = "
org.jboss.resource.security.SecureIdentityLoginModule"
flag = "required">
C 将<module-option name = "password">yyaccp</module-option> 改成
<module-option name = "password">
7236463cd79f258f </module-option>
D 删除 <module-option name = "principal">OracleDS</module-option>
5 完成jboss加密密码的oracle数据源配置