1、dbcp
<bean id="bbsDataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>org.gjt.mm.mysql.Driver</value>
</property>
<property name="url">
<value>jdbc:mysql://localhost:3306/exampledb?useUnicode=true&characterEncoding=utf8</value>
</property>
<property name="username">
<value>exampleuser</value>
</property>
<property name="password">
<value>thepass</value>
</property>
<property name="maxActive">
<value>500</value>
</property>
<property name="maxIdle">
<value>100</value>
</property>
<property name="maxWait">
<value>20000</value>
</property>
<property name="defaultAutoCommit">
<value>true</value>
</property>
<property name="minIdle">
<value>50</value>
</property>
<property name="testOnBorrow">
<value>true</value>
</property>
<property name="testOnReturn">
<value>true</value>
</property>
<property name="testWhileIdle">
<value>truevalue>
</property>
<property name="validationQuery">
<value>select 1 from dual</value>
</property>
</bean>
<property name="driverClassName">
<value>org.gjt.mm.mysql.Driver</value>
</property>
<property name="url">
<value>jdbc:mysql://localhost:3306/exampledb?useUnicode=true&characterEncoding=utf8</value>
</property>
<property name="username">
<value>exampleuser</value>
</property>
<property name="password">
<value>thepass</value>
</property>
<property name="maxActive">
<value>500</value>
</property>
<property name="maxIdle">
<value>100</value>
</property>
<property name="maxWait">
<value>20000</value>
</property>
<property name="defaultAutoCommit">
<value>true</value>
</property>
<property name="minIdle">
<value>50</value>
</property>
<property name="testOnBorrow">
<value>true</value>
</property>
<property name="testOnReturn">
<value>true</value>
</property>
<property name="testWhileIdle">
<value>truevalue>
</property>
<property name="validationQuery">
<value>select 1 from dual</value>
</property>
</bean>
2、proxool
<bean id="bbsDataSource" class="org.logicalcobwebs.proxool.ProxoolDataSource" destroy-method="close">
<property name="driver">
<value>org.gjt.mm.mysql.Driver</value>
</property>
<property name="driverUrl">
<value>jdbc:mysql://localhost:3306/exampledb?useUnicode=true&characterEncoding=utf8</value>
</property>
<property name="user">
<value>exampleuser</value>
</property>
<property name="password">
<value>thepass</value>
</property>
<property name="alias">
<value>spring</value>
</property>
<property name="houseKeepingSleepTime">
<value>90000</value>
</property>
<property name="prototypeCount">
<value>5</value>
</property>
<property name="maximumConnectionCount">
<value>100</value>
</property>
<property name="minimumConnectionCount">
<value>10</value>
</property>
<property name="maximumActiveTime">
<value>1000</value>
</property>
<property name="trace">
<value>true</value>
</property>
<property name="verbose">
<value>true</value>
</property>
<property name="driver">
<value>org.gjt.mm.mysql.Driver</value>
</property>
<property name="driverUrl">
<value>jdbc:mysql://localhost:3306/exampledb?useUnicode=true&characterEncoding=utf8</value>
</property>
<property name="user">
<value>exampleuser</value>
</property>
<property name="password">
<value>thepass</value>
</property>
<property name="alias">
<value>spring</value>
</property>
<property name="houseKeepingSleepTime">
<value>90000</value>
</property>
<property name="prototypeCount">
<value>5</value>
</property>
<property name="maximumConnectionCount">
<value>100</value>
</property>
<property name="minimumConnectionCount">
<value>10</value>
</property>
<property name="maximumActiveTime">
<value>1000</value>
</property>
<property name="trace">
<value>true</value>
</property>
<property name="verbose">
<value>true</value>
</property>
</bean>
3、tomcat数据源
a、在tomcat的应用配置文件example.xml里配置数据源
<Context path="/example" reloadable="true" docBase="D:\eclipse\workspace\example" workDir="D:\eclipse\workspace\example\work" >
<Resource name="jdbc/exampleds" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/exampleds">
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/exampledb?useUnicode=true&characterEncoding=utf8</value>
</parameter>
<parameter>
<name>password</name>
<value>thepass</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>500</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>20000</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>username</name>
<value>exampleuser</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>100</value>
</parameter>
</ResourceParams>
<Resource name="jdbc/exampleds" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/exampleds">
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/exampledb?useUnicode=true&characterEncoding=utf8</value>
</parameter>
<parameter>
<name>password</name>
<value>thepass</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>500</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>20000</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>username</name>
<value>exampleuser</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>100</value>
</parameter>
</ResourceParams>
</Context>
b、Spring配置文件中配置:
<bean id="exampleDataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName">
<value>java:comp/env/jdbc/exampleds</value>
</property>
<property name="jndiName">
<value>java:comp/env/jdbc/exampleds</value>
</property>
</bean>
其它数据源网络上资料很多,不再赘述。
值得注意的是,如果配置tomcat数据源时出现报错内容为:url为null,driver为null的情况,可能是因为应用上下文配置里或者server.xml设置了 reloadable="true",此时tomcat不是完全启动,就无法找到url和driver。另外,数据库的驱动要放到tomcat的comon/lib下确保生效。经过多次测试,mysql-connector-java-3.0.16-ga-bin.jar驱动在使用hibernate时出现无法写数据库的bug,换成mysql-connector-java-3.1.12-bin.jar后一切正常。