You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by micky none <ha...@rediffmail.com> on 2005/01/19 16:35:32 UTC
ConnectionPooling
Hi Friends,
This is my first message on this list.I want to use the dbcp connection pooling.I set up the server.xml according to an example,but when i trying to use to BasicDataSource to see thw no. of active connections it's throwing errors.I tried searching a lot but to no use.If I go into the administrator tool,it shows nothing there?I am using tomcat5.0..please tell me ..where i am going wrong and if there is any other way to see the number of active connections.
Here's my server.xml,please tell me if there's anything wrong with it:
<Logger className="org.apache.catalina.logger.FileLogger" directory="logs" prefix="localhost_log." suffix=".txt" timestamp="true" />
<DefaultContext reloadable="true" />
<DefaultContext path="/database" docBase="database" debug="0" reloadable="true" />
- <DefaultContext>
- <ResourceParams name="jdbc/conversion">
- <parameter>
<name>username</name>
<value>xxxx</value>
</parameter>
- <parameter>
<name>password</name>
<value>xxxx</value>
</parameter>
- <parameter>
<name>driverClassName</name>
<value>com.ibm.db2.jcc.DB2Driver</value>
</parameter>
- <parameter>
<name>url</name>
<value>jdbc:db2j:netxxxx</value>
</parameter>
- <parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
- <parameter>
<name>removeAbandonedTimeout</name>
<value>0</value>
</parameter>
- <parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
- <parameter>
<name>maxActive</name>
<value>1</value>
</parameter>
- <parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
</ResourceParams>
<Resource name="jdbc/conversion" auth="Container" type="javax.sql.DataSource" />
</DefaultContext>
<Loader className="org.apache.catalina.loader.WebappLoader" loaderClass="org.apache.catalina.loader.WebappClassLoader" checkInterval="3" />
</Host>
please,please,please help me...its very urgent.
Re: ConnectionPooling
Posted by Viorel Dragomir <vd...@wylog.com>.
http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html
You must set a web reference into web.xml too.
And is better that your resource params from server.xml regarding the database conection to be written into META-INF/context.xml
Viorel Dragomir
.
..
-------------------------------------------------------------------
----- Original Message -----
From: micky none
To: Tomcat Users List
Sent: Wednesday, January 19, 2005 17:35
Subject: ConnectionPooling
Hi Friends,
This is my first message on this list.I want to use the dbcp connection pooling.I set up the server.xml according to an example,but when i trying to use to BasicDataSource to see thw no. of active connections it's throwing errors.I tried searching a lot but to no use.If I go into the administrator tool,it shows nothing there?I am using tomcat5.0..please tell me ..where i am going wrong and if there is any other way to see the number of active connections.
Here's my server.xml,please tell me if there's anything wrong with it:
<Logger className="org.apache.catalina.logger.FileLogger" directory="logs" prefix="localhost_log." suffix=".txt" timestamp="true" />
<DefaultContext reloadable="true" />
<DefaultContext path="/database" docBase="database" debug="0" reloadable="true" />
- <DefaultContext>
- <ResourceParams name="jdbc/conversion">
- <parameter>
<name>username</name>
<value>xxxx</value>
</parameter>
- <parameter>
<name>password</name>
<value>xxxx</value>
</parameter>
- <parameter>
<name>driverClassName</name>
<value>com.ibm.db2.jcc.DB2Driver</value>
</parameter>
- <parameter>
<name>url</name>
<value>jdbc:db2j:netxxxx</value>
</parameter>
- <parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
- <parameter>
<name>removeAbandonedTimeout</name>
<value>0</value>
</parameter>
- <parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
- <parameter>
<name>maxActive</name>
<value>1</value>
</parameter>
- <parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
</ResourceParams>
<Resource name="jdbc/conversion" auth="Container" type="javax.sql.DataSource" />
</DefaultContext>
<Loader className="org.apache.catalina.loader.WebappLoader" loaderClass="org.apache.catalina.loader.WebappClassLoader" checkInterval="3" />
</Host>
please,please,please help me...its very urgent.
Re: ConnectionPooling
Posted by Harry Mantheakis <ha...@mantheakis.freeserve.co.uk>.
This may not help, but try swapping the order of the <ResourceParams> and
<Resource> elements in your 'server.xml' file.
Also, you seem to be declaring the <DefaultContext> element three times (!)
which seems wrong.
HTH
Harry Mantheakis
> Hi Friends,
> This is my first message on this list.I want to use the dbcp connection
> pooling.I set up the server.xml according to an example,but when i trying to
> use to BasicDataSource to see thw no. of active connections it's throwing
> errors.I tried searching a lot but to no use.If I go into the administrator
> tool,it shows nothing there?I am using tomcat5.0..please tell me ..where i am
> going wrong and if there is any other way to see the number of active
> connections.
>
>
> Here's my server.xml,please tell me if there's anything wrong with it:
>
> <Logger className="org.apache.catalina.logger.FileLogger" directory="logs"
> prefix="localhost_log." suffix=".txt" timestamp="true" />
> <DefaultContext reloadable="true" />
> <DefaultContext path="/database" docBase="database" debug="0"
> reloadable="true" />
> - <DefaultContext>
> - <ResourceParams name="jdbc/conversion">
> - <parameter>
> <name>username</name>
> <value>xxxx</value>
> </parameter>
> - <parameter>
> <name>password</name>
> <value>xxxx</value>
> </parameter>
> - <parameter>
> <name>driverClassName</name>
> <value>com.ibm.db2.jcc.DB2Driver</value>
> </parameter>
> - <parameter>
> <name>url</name>
> <value>jdbc:db2j:netxxxx</value>
> </parameter>
> - <parameter>
> <name>removeAbandoned</name>
> <value>true</value>
> </parameter>
> - <parameter>
> <name>removeAbandonedTimeout</name>
> <value>0</value>
> </parameter>
> - <parameter>
> <name>logAbandoned</name>
> <value>true</value>
> </parameter>
> - <parameter>
> <name>maxActive</name>
> <value>1</value>
> </parameter>
> - <parameter>
> <name>factory</name>
> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
> </parameter>
> </ResourceParams>
> <Resource name="jdbc/conversion" auth="Container" type="javax.sql.DataSource"
> />
> </DefaultContext>
> <Loader className="org.apache.catalina.loader.WebappLoader"
> loaderClass="org.apache.catalina.loader.WebappClassLoader" checkInterval="3"
> />
> </Host>
>
> please,please,please help me...its very urgent.
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org