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
Operations

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

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

Environment:

CentOs


Tags:
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="de.xyz.platform.sqllogger.SQLTraceListenerImpl" 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);

@Override
public void sqlTrace(SQLTraceRecord record) { logger.info(record); }

}

and the only thing I get in the server log is

[#|2012-05-10T10:41:31.922+0200|WARNING|glassfish3.1.1|javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors.util|_ThreadID=16;_ThreadName=Thread-2;|RAR7096: Exception null while trying to set the value de.xyz.platform.sqllogger.SQLTraceListenerImpl on property SqlTraceListeners |#]

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