spirng + tomcat 6 配置数据库连接池

上一篇 / 下一篇 2012-07-10 14:48:42 / 个人分类：java

1、在%tomcat%/conf/context.xml中添加如下

<Resource name="jdbc/monitorSQL"

auth="Container"

type="javax.sql.DataSource"

factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"

driverClassName="com.mysql.jdbc.Driver"

url="jdbc:mysql://IP:3306/pic_misc?useUnicode=true&characterEncoding=gbk"

username="root"

password="admin"

maxActive="100"

maxIdle="30"

maxWait="10000" />

2、spring里配置

<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"

<value>java:comp/env/jdbc/monitorSQL</value>

</property>

</bean>

3、将mysql的jar包放到%tomcat%/lib下

TAG: