Java开发网 - Tomcat5中DBCP怎么配置？不用server.xml

Topic: Tomcat5中DBCP怎么配置？不用server.xml

1.Tomcat5中DBCP怎么配置？不用server.xml

Posted by: rockerman
Posted on: 2005-03-08 17:27

We now set up the database connection pooling and sharing in both Tomcat and Hibernate. This means Tomcat will provide pooled JDBC connections (using its builtin DBCP pooling feature), Hibernate requests theses connections through JNDI. Tomcat binds the connection pool to JNDI, we add a resource declaration to Tomcats main configuration file, TOMCAT/conf/server.xml:

<Context path="/quickstart" docBase="quickstart">
<Resource name="jdbc/quickstart" scope="Shareable" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/quickstart">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>


<parameter>
<name>url</name>
<value>jdbc:postgresql://localhost/quickstart</value>
</parameter>
<parameter>
<name>driverClassName</name><value>org.postgresql.Driver</value>
</parameter>
<parameter>
<name>username</name>
<value>quickstart</value>
</parameter>
<parameter>
<name>password</name>
<value>secret</value>
</parameter>


<parameter>
<name>maxWait</name>
<value>3000</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>100</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
</ResourceParams>
</Context>

用这种方式可以配置用文件夹方式发布应用的Tomcat的数据库连接池。但是如果我是用war包方式发布的应用就没有办法识别啊，怎么处理？？

2.Re:Tomcat5中DBCP怎么配置？不用server.xml [Re: rockerman]	Copy to clipboard
Posted by: zaowei21 Posted on: 2005-03-16 11:20 可以配置在ＷＥＢ．ＸＭＬ里面的吧。好像还有个其它的方法，但我忘了怎么做了。你去网上找找

3.Re:Tomcat5中DBCP怎么配置？不用server.xml [Re: rockerman]	Copy to clipboard
Posted by: chinahyf Posted on: 2005-05-24 15:22 自己写个数据库连接池不就OK了，jive里有现成的

4.Re:Tomcat5中DBCP怎么配置？不用server.xml [Re: rockerman]	Copy to clipboard
Posted by: hitaco Posted on: 2005-05-24 15:49 好象hibernate doc推荐c3p0 or proxool, dbcp is not recommended for serious deployment

5.Re:Tomcat5中DBCP怎么配置？不用server.xml [Re: rockerman]

Copy to clipboard

Posted by: dot_xu
Posted on: 2005-07-19 09:37

把以上数据源声明放在server.xml的<Host><Context>%PooledConnection%</Context></Host>中，然后在hibernate.cfg.xml中这样写：

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>

<session-factory
name="java:comp/env/hibernate/SessionFactory">

<property
name="connection.datasource">java:comp/env/jdbc/quickstart</property>
<property
name="dialect">net.sf.hibernate.dialect.MySQLDialect</property>
<property name="show_sql">false</property>
<property name="use_outer_join">true</property>

<mapping resource="cat.hbm.xml"/>
</session-factory>
</hibernate-configuration>

我试过，可以的。
环境：Tomcat5.0.30+Hibernate2.1.2+MySQL4.1.7。

6.Re:Tomcat5中DBCP怎么配置？不用server.xml [Re: rockerman]	Copy to clipboard
Posted by: dot_xu Posted on: 2005-07-19 09:41 Tomcat5中DBCP怎么配置？不用server.xml ？？不好意思，没看清楚，