You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Jose María Zaragoza <de...@gmail.com> on 2013/03/27 13:34:07 UTC
Tomcat JDBC connection pool + JMX
Hello:
I'm using tomcat-jdbc as a connection pool in a standalone application.
I would like monitorize this pool by JMX .
How I can do that ?
What is the name of MBean ?
Thanks and regards
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat JDBC connection pool + JMX
Posted by Christopher Schultz <ch...@christopherschultz.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Jose,
On 3/27/13 8:34 AM, Jose María Zaragoza wrote:
> I'm using tomcat-jdbc as a connection pool in a standalone
> application.
>
> I would like monitorize this pool by JMX .
>
> How I can do that ? What is the name of MBean ?
http://wiki.apache.org/tomcat/FAQ/Monitoring
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
iQIcBAEBCAAGBQJRUvwiAAoJEBzwKT+lPKRYNJsP/3e32ZCoz2dwL0ND1It7+LJm
cgcqU83hRKSXys0PpeO3mJQMPIP6kTDvfVK81V9fk8IhOUihYCVxtikeRVdUU9x+
HH663kGPVca1KCED2LDRcMVeqJreS/+8BQV9yM/ESg1rD2pOccQMQSbZtPgsjwpX
Xamh/p49yhiYWQD3KCoZMBpytlNGoJB1neW6Nbe/3C/UB+jFnzPd0F5C1H3p5bvD
AZfuk8FBezykB24YeLM3tGua8mz1EfMsIUcE83iCT9r7KCDmJMWkluOQJvWKaRxr
WbPvdfeRcqaJlmArFKkCORI566DbODqPd0mFLjwml3PoudTt1FnwKfrB9OstkGIy
/N/kwQEK40WBfoWhT198fbJse9+6hALSAccTa9oXNVYPmPPaJQqJJ+FT9nJnGzRm
l4KYL/ChItEOKctRe9oeNR1eYle4QxNxB7PAxO8fgvBKOUywhGJ9N1go/iNydT5g
JlLY9mwQL5ZM59FG1p036e8TdAZP+VGVQ0LScmMyo9p1Eobvwz5ouMFYZLDiuCol
RUMMKPRUvpKSFMQhJvA4O28rO8AwAd82D+HBwwk+dd/agOiFJ8ZqdAXX6lKT8PMR
S3n4zZ2z65Dn+ajkf4Oox3WHo40pEQBHUr24pnzOhnoNGgIjlLvCSE2xidXl5wjc
mF4l88uu361edqqAqLFc
=iE5g
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat JDBC connection pool + JMX
Posted by Jose María Zaragoza <de...@gmail.com>.
2013/3/27 Charles Richard <ch...@thelearningbar.com>:
> Hi,
>
> There might be better ways but I monitor the c3p0 connection pool using
> jmxterm (my jar jmxterm-1.0-alpha-4-uber.jar).
>
> For c3p0, the mbean is com.mchange.Pooled...
>
> Hope this helps a little!
Thanks.
I use cmdline-jmxclient-0.10.3.jar
But I need to know the path where MBean's Tomcat JDBC connection pool
is registered to monitorize
Remember is a standalone application
For example, Tomcat's datasource MBean is registered in
Catalina:type=DataSource,path=$paths,host=localhost,class=javax.sql
.DataSource,name="$name"
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat JDBC connection pool + JMX
Posted by Charles Richard <ch...@thelearningbar.com>.
Hi,
There might be better ways but I monitor the c3p0 connection pool using
jmxterm (my jar jmxterm-1.0-alpha-4-uber.jar).
For c3p0, the mbean is com.mchange.Pooled...
Hope this helps a little!
Cheers,
Charles
On Wed, Mar 27, 2013 at 9:34 AM, Jose María Zaragoza
<de...@gmail.com>wrote:
> Hello:
>
>
> I'm using tomcat-jdbc as a connection pool in a standalone application.
>
> I would like monitorize this pool by JMX .
>
> How I can do that ?
> What is the name of MBean ?
>
>
> Thanks and regards
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
Re: Tomcat JDBC connection pool + JMX
Posted by Daniel Mikusa <dm...@vmware.com>.
On Mar 27, 2013, at 9:23 AM, Jose María Zaragoza wrote:
>> Here's what I see when I look at a Tomcat server with a tomcat-jdbc connection pool defined.
>>
>> tomcat.jdbc:name="<jndi-path>",type=ConnectionPool,class=org.apache.tomcat.jdbc.pool.DataSource
>>
>> I think this might also work (although it appears read-only).
>>
>> Catalina:type=DataSource,class=javax.sql.DataSource,name="<jndi-path>"
>>
>
>
> Thanks
> But I don't define any JDNI name ( I don't need it )
> This is my code ( Spring )
This is exactly why you should open jconsole or jvisualvm and take a look for yourself.
Dan
>
> <bean id="dataSource" class="org.apache.tomcat.jdbc.pool.DataSource"
> destroy-method="close">
> <property name="driverClassName" value="${database.driver}" />
> <property name="url" value="${database.url}" />
> <property name="username" value="${database.username}" />
> <property name="password" value="${database.password}" />
> <property name="maxActive" value="${database.maxactive}" />
> <property name="removeAbandoned" value="${database.removeabandoned}" />
> <property name="validationQuery" value="${database.validationquery}" />
>
> </bean>
>
> Regards
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat JDBC connection pool + JMX
Posted by Jose María Zaragoza <de...@gmail.com>.
> Here's what I see when I look at a Tomcat server with a tomcat-jdbc connection pool defined.
>
> tomcat.jdbc:name="<jndi-path>",type=ConnectionPool,class=org.apache.tomcat.jdbc.pool.DataSource
>
> I think this might also work (although it appears read-only).
>
> Catalina:type=DataSource,class=javax.sql.DataSource,name="<jndi-path>"
>
Thanks
But I don't define any JDNI name ( I don't need it )
This is my code ( Spring )
<bean id="dataSource" class="org.apache.tomcat.jdbc.pool.DataSource"
destroy-method="close">
<property name="driverClassName" value="${database.driver}" />
<property name="url" value="${database.url}" />
<property name="username" value="${database.username}" />
<property name="password" value="${database.password}" />
<property name="maxActive" value="${database.maxactive}" />
<property name="removeAbandoned" value="${database.removeabandoned}" />
<property name="validationQuery" value="${database.validationquery}" />
</bean>
Regards
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat JDBC connection pool + JMX
Posted by Daniel Mikusa <dm...@vmware.com>.
On Mar 27, 2013, at 8:34 AM, Jose María Zaragoza wrote:
> Hello:
>
>
> I'm using tomcat-jdbc as a connection pool in a standalone application.
>
> I would like monitorize this pool by JMX .
>
> How I can do that ?
Any number of ways. There are utilities like jmxsh, you could create custom code or even use monitoring software like Nagios or Hyperic.
> What is the name of MBean ?
Here's what I see when I look at a Tomcat server with a tomcat-jdbc connection pool defined.
tomcat.jdbc:name="<jndi-path>",type=ConnectionPool,class=org.apache.tomcat.jdbc.pool.DataSource
I think this might also work (although it appears read-only).
Catalina:type=DataSource,class=javax.sql.DataSource,name="<jndi-path>"
Probably best to take a look at your app with jconsole and jvisualvm and confirm.
Dan
>
>
> Thanks and regards
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org