You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by ne...@swisslab.de on 2007/02/19 14:40:31 UTC
DBCP Logging
Hello List,
I've configured DBCP on my Tomcat 5.5.20 Installation.
<Resource name="jdbc/myDB"
auth="Container"
type="javax.sql.DataSource"
maxActive="10"
maxIdle="2"
maxWait="10000"
username="aUser"
password="secret"
driverClassName="com.sybase.jdbc3.jdbc.SybDriver"
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
url="jdbc:sybase:Tds:194.111.13.30:5000/?charset=iso_1" />
This runs great and I'm really happy with it until it comes to logging
and/or monitoring.
What do I have to do if I want to know the state of the connection pool? How
can I see how many connections are currently in use? Or - more generally -
How can I set up logging for the pool?
Thanks!
Jan
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: DBCP Logging
Posted by Yannick Haudry <yh...@gmail.com>.
If your datasource is not managed through your container but
application driven, I guess Lambda probe (which is a great
application) will not be able to give you information about it ? Is
there a way to programmatically log the number of connections in use,
etc ... ?
Thanks
Yannick
On 2/19/07, David Delbecq <de...@oma.be> wrote:
> Lambda probe is a usefull webapplication you can deploy under tomcat and
> that, amongst many features, allows you to see the state of your
> connection pools.
>
> En l'instant précis du 02/19/07 14:40, news@swisslab.de s'exprimait en
> ces termes:
> > Hello List,
> >
> > I've configured DBCP on my Tomcat 5.5.20 Installation.
> > <Resource name="jdbc/myDB"
> > auth="Container"
> > type="javax.sql.DataSource"
> > maxActive="10"
> > maxIdle="2"
> > maxWait="10000"
> > username="aUser"
> > password="secret"
> > driverClassName="com.sybase.jdbc3.jdbc.SybDriver"
> > factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
> > url="jdbc:sybase:Tds:194.111.13.30:5000/?charset=iso_1" />
> >
> > This runs great and I'm really happy with it until it comes to logging
> > and/or monitoring.
> > What do I have to do if I want to know the state of the connection pool? How
> > can I see how many connections are currently in use? Or - more generally -
> > How can I set up logging for the pool?
> >
> > Thanks!
> >
> > Jan
> >
> > ---------------------------------------------------------------------
> > To start a new topic, e-mail: users@tomcat.apache.org
> > To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> > For additional commands, e-mail: users-help@tomcat.apache.org
> >
> >
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: DBCP Logging
Posted by David Delbecq <de...@oma.be>.
Lambda probe is a usefull webapplication you can deploy under tomcat and
that, amongst many features, allows you to see the state of your
connection pools.
En l'instant précis du 02/19/07 14:40, news@swisslab.de s'exprimait en
ces termes:
> Hello List,
>
> I've configured DBCP on my Tomcat 5.5.20 Installation.
> <Resource name="jdbc/myDB"
> auth="Container"
> type="javax.sql.DataSource"
> maxActive="10"
> maxIdle="2"
> maxWait="10000"
> username="aUser"
> password="secret"
> driverClassName="com.sybase.jdbc3.jdbc.SybDriver"
> factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
> url="jdbc:sybase:Tds:194.111.13.30:5000/?charset=iso_1" />
>
> This runs great and I'm really happy with it until it comes to logging
> and/or monitoring.
> What do I have to do if I want to know the state of the connection pool? How
> can I see how many connections are currently in use? Or - more generally -
> How can I set up logging for the pool?
>
> Thanks!
>
> Jan
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org