no SQL stats for JBoss EAP 6.1.0 ( JBoss Web/7.2.0.Final-redhat-1 )

[GoogleCodeExporter]

What steps will reproduce the problem?

1. Install JBoss EAP 6.1.0 (JDK 1.7.0_60 64bits)

2. Replace non-standard JNDI names for Data Sources inside standalone.xml :

...
<datasource jndi-name="java:/comp/env/jdbc/myDS" pool-name="jdbc/myDS" 
enabled="true" use-java-context="true">
                    <connection-url>jdbc:oracle:thin:@orcl:1521:orcl</connection-url>
                    <driver>oracle</driver>
                    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
                    <security>
                        <user-name>xxxx</user-name>
                        <password>xxxx</password>
                    </security>
                </datasource>

...

3. Deploy a JEE app with this web.xml:

    <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>
    <listener>
        <listener-class>net.bull.javamelody.SessionListener</listener-class>
    </listener>

What is the expected output? What do you see instead?

SQL stats! =)

What version of the product are you using? 
<dependency>
  <groupId>net.bull.javamelody</groupId>
  <artifactId>javamelody-core</artifactId>
  <version>1.51.0</version>
</dependency>

On what application server, JDK,
operating system?
 JBoss EAP 6.1.0 (  JBoss Web/7.2.0.Final-redhat-1 ) 
JDK 1.7.0_60 
Windows 7 64 bits

Please provide any additional information below.

JavaMelody 1.51.0 - Debugging logs

Fri Aug 08 10:23:09 BRT 2014     DEBUG     JavaMelody listener init started
Fri Aug 08 10:23:09 BRT 2014     DEBUG     datasources found in JNDI: []
Fri Aug 08 10:23:09 BRT 2014     DEBUG     JavaMelody listener init done in 19 
ms
Fri Aug 08 10:23:09 BRT 2014     DEBUG     JavaMelody filter init started
Fri Aug 08 10:23:09 BRT 2014     DEBUG     OS: Windows 7 , amd64/64
Fri Aug 08 10:23:09 BRT 2014     DEBUG     Java: Java(TM) SE Runtime 
Environment, 1.7.0_60-b19
Fri Aug 08 10:23:09 BRT 2014     DEBUG     Server: JBoss 
Web/7.2.0.Final-redhat-1
Fri Aug 08 10:23:09 BRT 2014     DEBUG     Webapp context: /AplicacaoExemplo
Fri Aug 08 10:23:09 BRT 2014     DEBUG     JavaMelody version: 1.51.0
Fri Aug 08 10:23:09 BRT 2014     DEBUG     JavaMelody classes loaded from: 
vfs:/C:/jboss-eap-6.1/bin/content/AplicacaoExemplo.war/WEB-INF/lib/javamelody-co
re-1.51.0.jar
Fri Aug 08 10:23:09 BRT 2014     DEBUG     Host: AK0039963@192.168.60.77
Fri Aug 08 10:23:09 BRT 2014     DEBUG     parameter defined: 
monitoring-path=/tms/monitoring
Fri Aug 08 10:23:09 BRT 2014     DEBUG     log listeners initialized
Fri Aug 08 10:23:09 BRT 2014     DEBUG     datasources found in JNDI: []
Fri Aug 08 10:23:09 BRT 2014     INFO     initialization of jsf action listener 
failed, skipping
Fri Aug 08 10:23:09 BRT 2014     DEBUG     counters initialized
Fri Aug 08 10:23:09 BRT 2014     DEBUG     counters data read from files in 
C:\Windows\TEMP\javamelody\AplicacaoExemplo_AK0039963
Fri Aug 08 10:23:09 BRT 2014     DEBUG     collect task scheduled every 60s
Fri Aug 08 10:23:10 BRT 2014     DEBUG     first collect of data done
Fri Aug 08 10:23:10 BRT 2014     DEBUG     JavaMelody filter init done in 1021 
ms

Original issue reported on code.google.com by boag...@gmail.com on 8 Aug 2014 at 2:07

[GoogleCodeExporter]

Hi
Have you tried using the "datasources" parameter, which allows you to list a 
comma separated list of datasources you want to monitor. You list the JNDI 
names.

Regards
Alf Høgemark

Original comment by alf.hoge...@gmail.com on 9 Aug 2014 at 12:49

[GoogleCodeExporter]

Hi,

If I send "datasources" parameters or put my datasource inside web.xml , I get 
an error regarding my Oracle driver module:

Caused by: java.lang.ClassNotFoundException: javax.transaction.xa.XAResource 
from [Module "com.oracle:main" from local module loader @37cc745e (finder: 
local module finder @4febe3f0 (roots: 
C:\jboss-eap-6.1\modules,C:\jboss-eap-6.1\modules\system\layers\base))]
        at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:196) [jboss-modules.jar:1.2.0.Final-redhat-1]
        at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:444) [jboss-modules.jar:1.2.0.Final-redhat-1]
... 41 more

Then I realized my module was wrong, this is the working version:

<module xmlns="urn:jboss:module:1.0" name="com.oracle">
  <resources>
    <resource-root path="ojdbc6.jar"/>
  </resources>
  <dependencies>
    <module name="javax.api"/>
    <module name="javax.transaction.api"/>
  </dependencies>
</module>

Now it's working fine! =)

Original comment by boag...@gmail.com on 12 Aug 2014 at 4:06

[GoogleCodeExporter]

ok

Original comment by evernat@free.fr on 12 Aug 2014 at 8:02

• Changed state: Invalid