java连接池hkai_阿里巴巴Druid连接池配置

Druid 是阿里巴巴的开源数据库连接池技术，相比dbcp、c3p0更优秀，具有密码加密、sql连接监控功能，无论在性能还是稳定性上表现都十分出色。

二、spring.xml配置： 在context.hibernate1.xml中进行配置，具体配置如下：

init-method="init" destroy-method="close">

###web.xml 中配置sql监控

DruidStatView

com.alibaba.druid.support.http.StatViewServlet

DruidStatView

/druid/*

###jdbc.properties

oracle.driver = oracle.jdbc.driver.OracleDriver

oracle.url = jdbc:oracle:thin:@localhost:1521:makecardcl

oracle.username = MakeCard_CL

oracle.password = ZWV95JNDIhKl90iz1hy0uc+n0Fav0LO/U/36PkO4AuXMnuz+MiXmkYDqeICk3ONeTeEDe/BctZ+pVwnB0sK51A==

oracle.publickey = MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAIQdIhCTaX4fSqZaKcaGDODShQ8x832eLgM9IWQPlCxYSxaSwhsy/mKtq8bLuodVBGrDLSWLLbAdb5PX/ShyBaECAwEAAQ==

druid.initialSize = 3

druid.maxActive = 10

druid.maxIdle=5

druid.minIdle = 2

druid.maxWait = 60000

druid.removeAbandoned = true

druid.removeAbandonedTimeout = 180

druid.timeBetweenEvictionRunsMillis = 60000

druid.minEvictableIdleTimeMillis = 300000

druid.validationQuery = SELECT 1 FROM DUAL

druid.testWhileIdle = false

druid.testOnBorrow = false

druid.testOnReturn = false

druid.poolPreparedStatements = true

druid.maxPoolPreparedStatementPerConnectionSize = 100

filters =stat

###使用druid.jar 包生成密码 通过cmd命令，生产publickey ,password

Java -cp druid-1.0.9.jar com.alibaba.druid.filter.config.ConfigTools you_password