JDBC and SQL Stats are not showing up
Closed this issue · 1 comments
GoogleCodeExporter commented
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
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
- Changed state: Invalid