If I understand correctly, you want to have more initial connections to the
database.
<!-- Maximum number of dB connections in pool. Make sure you
configure your mysqld max_connections large enough to handle
all of your db connections. Set to 0 for no limit.
-->
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<!-- Maximum number of idle dB connections to retain in pool.
Set to 0 for no limit.
-->
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
taken from
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html
--- Madocke TomCat users <[EMAIL PROTECTED]> wrote:
> Hi guys,
>
> I realize this might be slightly off-topic, but I've got no other place to
> turn. I'm using Tomcat's default connection pool using the mm.mysql JDBC
> driver. It seems that my program creates a little too many database
> connections when I load about 20-30 pages at the same time. My temporary
> solution to fix this problem would be to increase the number of connections
> the dbpool maintains, but I can't seem to find how many connections Tomcat
> maintains standard. I can't seem to find anything at all about that come to
> think about it. Any input on the issue would be greatly appreciated.
>
> My server.xml:
>
> <Context path="" docBase="site" debug="0">
> <Resource name="jdbc/PrivaCmsDB" auth="Container"
> type="javax.sql.DataSource"/> <ResourceParams
> name="jdbc/PrivaCmsDB">
> <parameter>
> <name>user</name>
> <value>********</value>
> </parameter>
> <parameter>
> <name>password</name>
> <value>********</value>
> </parameter>
> <parameter>
> <name>driverClassName</name>
> <value>org.gjt.mm.mysql.Driver</value>
> </parameter>
> <parameter>
> <name>driverName</name>
>
> <value>jdbc:mysql://localhost:3306/dbDefault</value>
> </parameter>
> </ResourceParams>
> </Context>
>
> Thanks in advance guys.
>
=====
http://dhtmlkitchen.com/
JSP | Servlets | DHTML
Garrett Needs A Job
__________________________________________________
Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos
http://launch.yahoo.com/u2
--
To unsubscribe, e-mail: <mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>
