jboss4.0.2 sqlserver2000 配置多数据源，密码加密
mssql-ds.xml<datasources> <local-tx-datasource> <jndi-name>DSDB1</jndi-name> <connection-url>jdbc:microsoft:sqlserver://192.168.0.215:1433;DatabaseName=DB1;SelectMethod=Cursor;</connection-url> <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class> <min-pool-size>5</min-pool-size> <max-pool-size>20</max-pool-size> <security-domain>DSDB1PWD</security-domain> <metadata><type-mapping>MS SQLSERVER2000</type-mapping></metadata> </local-tx-datasource> <local-tx-datasource> <jndi-name>DSDB2</jndi-name> <connection-url>jdbc:microsoft:sqlserver://192.168.0.215:1433;DatabaseName=DB2;SelectMethod=Cursor;</connection-url> <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class> <min-pool-size>5</min-pool-size> <max-pool-size>20</max-pool-size> <security-domain>DSDB2PWD</security-domain> <metadata><type-mapping>MS SQLSERVER2000</type-mapping></metadata> </local-tx-datasource></datasources> login-config.xml
在文件最后，就是最后一个</policy>前面加入
<application-policy name="DSDB1PWD"> <authentication> <login-module code="org.jboss.resource.security.SecureIdentityLoginModule" flag="required"> <module-option name="username">sa</module-option> <module-option name="password">-2dd70546b2d4394b207a6df87216de44</module-option> <module-option name="managedConnectionFactoryName">jboss.jca:name=DSDB1,service=LocalTxCM</module-option> </login-module> </authentication> </application-policy><application-policy name="DSDB2PWD"> <authentication> <login-module code="org.jboss.resource.security.SecureIdentityLoginModule" flag="required"> <module-option name="username">sa</module-option> <module-option name="password">-2dd70546b2d4394b207a6df87216de44</module-option> <module-option name="managedConnectionFactoryName">jboss.jca:name=DSDB2,service=LocalTxCM</module-option> </login-module> </authentication> </application-policy>
页:
[1]