Forums Register Login

I can't see the SQL stats.

+Pie Number of slices to send: Send
Hi everyone,

I have installed Jamon API and I code the following lines:

For monitor a method:

Monitor mon=MonitorFactory.start("ActionManager.retrieveEmployees
("+databaseDriver+" "+urlConnection+")");
...
mon.stop()

For monitor a SQL:

con = DriverManager.getConnection( urlConnection , username, password);
// START SQL Monitoring
monitoredConnection = MonProxyFactory.monitor( con );
...
monitoredConnection.close();

But in the jamonadmin.jsp, I only see the following line about the servlet that calls to my component.

com.jamonapi.http.JAMonTomcatValve.request.contextpath: /p3_web-webapp, ms. 1 10.436

The question is: What are the steps to get the sql stats into the jamonadmin.jsp?

I think I have followed the steps indicate in the documentation , but nothing. May anyone help me?

Thanks in Advance.
+Pie Number of slices to send: Send
"Lucke Skywalker", please check your private messages.
+Pie Number of slices to send: Send
You probably have jamon in your classpath at both the server level and in web-inf/lib. Remove it from web-inf/lib.


con = DriverManager.getConnection( urlConnection , username, password);
// START SQL Monitoring
monitoredConnection = MonProxyFactory.monitor( con );
...
monitoredConnection.close();


Also, you can use the jamon jdbc proxy driver and instead of monitoring jdbc connections directly. This isn't causing your problem however, just not the preferred practice.
+Pie Number of slices to send: Send
Lucke, Lucke, you're being naive. These are not the stats you're looking for.

(We give real answers to real people).
+Pie Number of slices to send: Send
Dear Steven,

That's right! That was the problem. My component had the jamon.jar and the tomcat lib too.

It's wonderful. This information is fantastic .
The JAMON api is a key for the performance.

Now I can see the MonProxy label and more...

MonProxy-Interface (class=com.mysql.jdbc.JDBC4Connection): public abstract java.sql.Statement java.sql.Connection.createStatement() throws java.sql.SQLException, ms. 3 0 0 0 0 0 0 0 1 1 1/10/08 14:04:48 1/10/08 14:08:58 true false false
MonProxy-Interface (class=com.mysql.jdbc.JDBC4Connection): public abstract void java.sql.Connection.close() throws java.sql.SQLException, ms. 6 0 0 0 0 0 0 0 1 1 1/10/08 14:05:04 1/10/08 14:09:14 true false false
MonProxy-Interface (class=com.mysql.jdbc.StatementImpl): public abstract java.sql.ResultSet java.sql.Statement.executeQuery(java.lang.String) throws java.sql.SQLException, ms. 3 172 515 54 234 140 234 0 1 1 1/10/08 14:04:48 1/10/08 14:08:58 true false false
MonProxy-Interface (class=com.mysql.jdbc.StatementImpl): public abstract void java.sql.Statement.close() throws java.sql.SQLException, ms. 6 0 0 0 0 0 0 0 1 1 1/10/08 14:05:04 1/10/08 14:09:14 true false false
MonProxy-SQL-Statement: SELECT empno,ename,sal,deptno FROM emp, ms.


Thank you very much.

PD. I beg your pardon , Tim Holloway. I didn't know the name rule. But I have changed and I have written my real name. I'm so sorry.
+Pie Number of slices to send: Send
No problem. Although we do have some people who deliberately flaunt it, I've always suspected that we don't post it prominently enough.
Seriously? That's what you're going with? I prefer this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1021 times.
Similar Threads
Profilers
JAMon 2.1 and Monitoring SQL/JDBC
Using Jamon for JSP Page
Using JAMon
DB Monitoring
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 16:02:24.