DB관련/MySQL

[JSP]DB컨넥션풀 snaq.net

saltdoll 2008. 2. 1. 11:27
반응형

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.



출처
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 




반응형
도움이 되셨다면 하트모양의 "♡ 공감"을 눌러주시면 큰 격려가 됩니다.
(로그인하지 않으셔도 가능)