SQL Capture by Javamelody

Javamelody allows for the capturing of SQL executed by the portal for better performance analysis.

This capture is disabled by default. To enable it, the following changes must be made in the configuration file lumishibernate.cfg.xml:

• Add at the end of the property connection.url a string: ?driver=<driver class>, where <driver class> is the original driver class for the database (value of the property connection.driver_class).
• Change the value of the property connection.driver_class to net.bull.javamelody.JdbcDriver.

Example:
Suppose that Oracle is being used and that the configuration of lumishibernate.cfg.xml is:
<property name="dialect">lumis.portal.dao.hibernate.Oracle10gDialect</property> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <property name="connection.username">lumis_portaljava</property> <property name="connection.password">lumis_portaljava</property> <property name="connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property> <property name="connection.defaultRowPrefetch">50</property>
To enable SQL capture from Javamelody, the configuration would be:
<property name="dialect">lumis.portal.dao.hibernate.Oracle10gDialect</property> <property name="connection.driver_class">net.bull.javamelody.JdbcDriver</property> <property name="connection.username">lumis_portaljava</property> <property name="connection.password">lumis_portaljava</property> <property name="connection.url">jdbc:oracle:thin:@localhost:1521:orcl?driver=oracle.jdbc.driver.OracleDriver</property> <property name="connection.defaultRowPrefetch">50</property>
Note that connection.driver_class was changed from oracle.jdbc.driver.OracleDriver to net.bull.javamelody.JdbcDriver and connection.url was changed from jdbc:oracle:thin:@localhost:1521:orcl to jdbc:oracle:thin:@localhost:1521:orcl?driver=oracle.jdbc.driver.OracleDriver.