Set up a pool using the DriverAdapterCPDS class in dbcp commons. And use a
SharedPoolDatasource also from dbcp. There is example in the dbcp javadocs
for the same.
----------
From: andy susanto [SMTP:[EMAIL PROTECTED]
Sent: Sunday, August 08, 2004 7:56 AM
To: [EMAIL PROTECTED]
Subject: Fw: problem
hai Partha Ranjan Das,
i am try your sugestion, but that error very quick to display.(I
have 10
client to test this new setting when i start the tomcat, after that
10
client have a transaction and that error show again but this time
very
quick)
I am use setting standard dbcp
this my setting:
<Resource auth="Container" name="MySQLDrv" scope="Shareable"
type="javax.sql.DataSource"/>
<ResourceParams name="MySQLDrv">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/spadb?autoReconnect=true</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
</ResourceParams>
what should i do, to disapper that error message
TIA,
andy
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in
the body
of the message "signoff SERVLET-INTEREST".
Archives:
http://archives.java.sun.com/archives/servlet-interest.html
Resources:
http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
*********************************************************************
Disclaimer: The information in this e-mail and any attachments is
confidential / privileged. It is intended solely for the addressee or
addressees. If you are not the addressee indicated in this message, you may
not copy or deliver this message to anyone. In such case, you should destroy
this message and kindly notify the sender by reply email. Please advise
immediately if you or your employer does not consent to Internet email for
messages of this kind.
*********************************************************************
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
