2011. 3. 9.

mysql java 연동시 context.xml 설정

<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver"
logAbandoned="true"
maxActive="100"
maxIdle="10"
maxWait="180"
removeAbandoned="true"
removeAbandonedTimeout="60"
testOnBorrow="true"
testOnReturn="true"
validationQuery="SELECT 1"
type="javax.sql.DataSource"
url="jdbc:mysql://ipaddress/dbname?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8"
name="jdbc/MySQLDB"
password="pass"
username="username" />

댓글 없음: