Javamelody and Oracle without datasource but using driver directly

[Vincenzo Lizio]

Hi,
I use Javamelody for monitoring my app.
I have Oracle db and using driver directly (no datasource, no jndi).
I haven't sql statistics.

[web.xml]
...
    <property name="hibernate.connection.driver_class">net.bull.javamelody.JdbcDriver</property>
    <property name="hibernate.connection.driver">oracle.jdbc.OracleDriver</property>
    <property name="hibernate.connection.url">jdbc:oracle:thin:@myserver:1521:mysid</property>
    <property name="hibernate.connection.username">myuser</property>
    <property name="hibernate.connection.password">mypassword</property>      

    <filter>
        <filter-name>monitoring</filter-name>
        <filter-class>net.bull.javamelody.MonitoringFilter</filter-class>
        <init-param>
            <!-- restrict access using HTTP basic authentication -->
            <param-name>authorized-users</param-name>
            <param-value>myuser:mypassword</param-value>
        </init-param>
        <init-param>
            <!-- enable/disable JavaMelody -->
            <param-name>disabled</param-name>
            <param-value>false</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>monitoring</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
    <listener>
        <listener-class>net.bull.javamelody.SessionListener</listener-class>
    </listener>
...

java class using oracle db example:
...
        try {
            String url = "jdbc:oracle:thin:@" + hst + ":" + prt + ":" + sid;
            OracleDataSource ods = new OracleDataSource();
            ods.setUser(uid);
            ods.setPassword(pwd);
            ods.setURL(url);
            dbConn = ods.getConnection();
            dbConn.setAutoCommit(false);
...
        try {
            sqlStmt = connection.createStatement();
            resultSet = sqlStmt.executeQuery(query);
...

Oracle user have grant to access to v$session

Many thank's
Vincenzo

[Vernat Emeric]

Hi Vincenzo,

If you have:
            dbConn = ods.getConnection();
then you can monitor sql requests and jdbc connections with:
            dbConn = net.bull.javamelody.JdbcWrapper.SINGLETON.createConnectionProxy(dbConn);

bye,
Emeric

--

---
You received this message because you are subscribed to the Google Groups "javamelody" group.
To unsubscribe from this group and stop receiving emails from it, send an email to javamelody+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.