似乎Hibernate对DBCP连接池支持的不太好,Hibernate3已经不支持DBCP了。我是在Tomcat的server.xml中配置DBCP的连接池的。如下:
[code]
<Context path="" docBase="C:\tomcat\webapps\ROOT" reloadable="false">
<Resource
name="jdbc/aaaaDB"
type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"
username="aaaa"
password="aaaa"
driverClassName="oracle.jdbc.driver.OracleDriver"
maxIdle="10"
maxWait="15000"
maxActive="50"
url="jdbc:oracle:thin:@10.0.0.3:1521:orcl"/>
</Context>
[/code]
Hibernate.cfg.xml如下:
[code]
<property name="connection.datasource">
java:comp/env/jdbc/aaaaDB
</property>
<!-- dialect for Oracle (any version) -->
<property name="dialect">
net.sf.hibernate.dialect.Oracle9Dialect
</property>
<property name="hibernate.connection.provider_class">
net.sf.hibernate.connection.DatasourceConnectionProvider
</property>
[/code]
[code]
<Context path="" docBase="C:\tomcat\webapps\ROOT" reloadable="false">
<Resource
name="jdbc/aaaaDB"
type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"
username="aaaa"
password="aaaa"
driverClassName="oracle.jdbc.driver.OracleDriver"
maxIdle="10"
maxWait="15000"
maxActive="50"
url="jdbc:oracle:thin:@10.0.0.3:1521:orcl"/>
</Context>
[/code]
Hibernate.cfg.xml如下:
[code]
<property name="connection.datasource">
java:comp/env/jdbc/aaaaDB
</property>
<!-- dialect for Oracle (any version) -->
<property name="dialect">
net.sf.hibernate.dialect.Oracle9Dialect
</property>
<property name="hibernate.connection.provider_class">
net.sf.hibernate.connection.DatasourceConnectionProvider
</property>
[/code]