`
log_cd
  • 浏览: 1089854 次
  • 性别: Icon_minigender_1
  • 来自: 成都
社区版块
存档分类
最新评论

Tomcat下使用Druid配置JNDI数据源且数据库密码加密

阅读更多
1、生成公钥、私钥及加密密码
引用

java -cp  D:\JavaLib\druid\druid-1.1.6.jar com.alibaba.druid.filter.config.ConfigTools appuser


2、添加druid的jar包到【${Tomcat_home}/lib】目录
引用

如:D:\WebServer\tomcat-cdgys\lib\druid-1.1.6.jar


3、在【${Tomcat_home}/conf/server.xml】中增加jndi数据源
    <Resource name="jdbc/appuserDS" factory="com.alibaba.druid.pool.DruidDataSourceFactory" 
        auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver" 
        url="jdbc:oracle:thin:@cdgys.db:1521:cdgysorcl" username="appuser" 
        password="fK/JkrUrn12BPy9fIEFu4xHAFsi4OecK2QPWgAls7RuG2k0NK7byESluKxASLRjjfoH1TA3oe5wGJXovG6lykg==" 
        maxActive="50" 
        maxWait="10000" removeabandoned="true" removeabandonedtimeout="60" logabandoned="false" 
        filters="config,stat,wall"
        useGlobalDataSourceStat="true"
        validationQuery="SELECT SYSDATE FROM DUAL"
        connectionProperties="druid.stat.mergeSql=true;druid.stat.slowSqlMillis=2000;config.decrypt=true;config.decrypt.key=MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAIFMABzyEAysv1V/flaVj5G9KelAqzcq7lw9p7NdQkfzIJnJr/qRGADqttXg/RvdXoccV5cFnuZPReB5qfCnGtECAwEAAQ=="/> 


4、配置监控结果查看页面
    在该文件【${Tomcat_home}/conf/web.xml】中添加以下内容
	<servlet>
		<servlet-name>DruidStatView</servlet-name>
		<servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>
		<init-param>
			<param-name>resetEnable</param-name>
			<param-value>true</param-value>
        </init-param>
        <init-param>
			<param-name>loginUsername</param-name>
			<param-value>admin</param-value>
        </init-param>
        <init-param>
			<param-name>loginPassword</param-name>
			<param-value>admin</param-value>
		</init-param>
	</servlet>
	 
	<servlet-mapping>
		<servlet-name>DruidStatView</servlet-name>
		<url-pattern>/druid/*</url-pattern>
	</servlet-mapping>

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics