visan / javamelody

Automatically exported from code.google.com/p/javamelody
0 stars 0 forks source link

JDBC and SQL Stats are not showing up #452

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?

1. Add javamelody-1.54.0.jar and jrobin-1.5.9.jar to WEB-INF/lib

2. Add below listener as the first listener in web.xml file.
<listener>
      <listener-class>net.bull.javamelody.SessionListener</listener-class>
</listener>

3. Add this filter in web.xml file
<filter>
              <filter-name>monitoring</filter-name>
              <filter-class>net.bull.javamelody.MonitoringFilter</filter-class>
      </filter>
      <filter-mapping>
              <filter-name>monitoring</filter-name>
              <url-pattern>/*</url-pattern>
      </filter-mapping>

4. Add this param in the webapp's context.xml file
<Parameter name='javamelody.log' value='true' override='false'/>

5. My datasource resource is defined as below in server.xml file
<Resource auth="Container" driverClassName="oracle.jdbc.OracleDriver" 
name="com/xxxxxx/jdbc/DataSource" password="xxxxxxx" 
type="javax.sql.DataSource" url="jdbc:oracle:thin:@xxxxxxxxx:1521:site" 
username="xxxxxxxx"/>

6. Data source is defined in spring config file as below:
<bean id="dataSourceCareRadius" class="com.xxxxx.lib.jdbc.TraceDataSource">
        <property name="traceEnabled" value="false" />
        <property name="wrappedDataSource">
            <bean class="org.springframework.jndi.JndiObjectFactoryBean">
                <property name="jndiName" value="java:comp/env/com/xxxxxxxxxxxxxxx/jdbc/DataSource" />
                <property name="lookupOnStartup" value="false" />
                <property name="cache" value="true" />
                <property name="proxyInterface" value="javax.sql.DataSource" />
            </bean>
        </property>
    </bean>

I am not seeing any stats in JDBC and SQL charts. They are empty.

What is the expected output? What do you see instead?
I am expecting to see stats in JDBC and SQL charts but they are empty.

What version of the product are you using? On what application server, JDK,
operating system?
Environment:
1. Tomcat v6.0
2. Spring v4.0.5
3. java melody v1.54.0
4. We use myBatis as ORM. myBatis v2.3.2

OS: Windows 7 64 bit [I am trying to get stats on local workstation. prod 
version might be UNIX/Linux. So far I am worrying about getting all stats to 
show up on local environment.]

I would like to know if I am missing something in config or something I am 
doing wrong ? how do I get JDBC and SQL stats to show up with Spring and 
myBatis ?

Please provide any additional information below.

Original issue reported on code.google.com by koradesu...@gmail.com on 10 Jan 2015 at 1:44

GoogleCodeExporter commented 9 years ago
I ask myself why I have written a user guide. Anyway, you may read it since it 
contains the answers to the question.
https://code.google.com/p/javamelody/wiki/UserGuide#7._JDBC

The behaviour described is normal given configuration above. So this issue is 
invalid.

Original comment by evernat@free.fr on 10 Jan 2015 at 4:58