[JSP]DB컨넥션풀 snaq.net

DBPool - Java Database Connection Pooling

Copyright © Giles Winstanley
Last updated: 21st July 2006
Latest version: 4.8.3

Where can I get it?

Select one of the links below to download the version you require.

• Download DBPool as ZIP - contains JAR file & all documentation
• Download DBPool as JAR and DBPool_javadoc.zip
• Download DBPool source

출처
http://www.snaq.net/java/DBPool/index.html


[ MySQL dbpool.properties 내용 ]
#JDBC Driver
drivers=org.gjt.mm.mysql.Driver,com.microsoft.sqlserver.jdbc.SQLServerDriver
pool.url=jdbc:mysql://127.0.0.1:3306/디비명?useUnicode=true&characterEncoding=UTF-8
pool.user=유저명
pool.password=패스워드
pool.initsize=10
pool.maxpool=10 
pool.maxconn=30 
pool.expiry=180 
pool.validator=snaq.db.AutoCommitValidator 


[ MS-SQL dbpool.properties 내용 ]
pool2.url=jdbc:sqlserver://아이피:1433;databaseName=디비명
pool2.user=계정명
pool2.password=패스워드
pool2.initsize=1
pool2.maxpool=5
pool2.maxconn=5
pool2.expiry=180
pool2.validator=snaq.db.AutoCommitValidator