Issue Details (XML | Word | Printable)

Key: GLASSFISH-18712
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: sfelts
Reporter: ztangm
Votes: 0
Watchers: 2

If you were logged in you would be able to see more operations.

SQLTraceListeners do not work

Created: 10/May/12 08:48 AM   Updated: Yesterday 04:51 AM
Component/s: jdbc
Affects Version/s: 3.1.1
Fix Version/s: None

Time Tracking:
Not Specified



Participants: sfelts, shreedhar_ganapathy and ztangm

 Description  « Hide

I define my db pool like

<jdbc-connection-pool validation-table-name="DUAL" datasource-classname="oracle.jdbc.pool.OracleConnectionPoolDataSource" is-isolation-level-guaranteed="false" res-type="javax.sql.ConnectionPoolDataSource" sql-trace-listeners="" name="OraclePool" is-connection-validation-required="true">

and define my sql tracer like

public class SQLTraceListenerImpl implements SQLTraceListener {

private final static Logger logger = Logger.getLogger(SQLTraceListenerImpl.class);

public void sqlTrace(SQLTraceRecord record) {; }


and the only thing I get in the server log is

[#|2012-05-10T10:41:31.922+0200|WARNING|glassfish3.1.1||_ThreadID=16;_ThreadName=Thread-2;|RAR7096: Exception null while trying to set the value on property SqlTraceListeners |#]

One thing would be to know what I did wrong and the other thing would be to improve this exception.