> From: Chris Wiley [mailto:[email protected]]
> Subject: RE: Database Connection Pooling initialization with dbcp
>
> As far as the initialSize parameter, do I just append those to the
> datasource under the Resource element in the web.xml?
Set the values as additional attributes in the <Resource> element. E.g.,
<Resource name="jdbc/TestDB" auth="Container"
type="javax.sql.DataSource"
initialSize="10" maxActive="100"
maxIdle="30" minIdle="10" maxWait="10000"
username="javauser" password="javadude"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/javatest?autoReconnect=true"/>
> will that actually create some initial connections in the pool?
It's broken if it doesn't.
You probably also want to specify validationQuery and testOnBorrow, in case the
DB (or intervening firewall) drops connections on you.
- Chuck
THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY
MATERIAL and is thus for use only by the intended recipient. If you received
this in error, please contact the sender and delete the e-mail and its
attachments from all computers.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
