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.