Not clear how to use ErrorLoggingEventListener

[cowwoc]

I want P6Spy to log SQL warnings/exceptions. I ran across ErrorLoggingEventListener whose Javadoc recommends:

add com.p6spy.engine.logging.ErrorLoggingEventListener to the file
src/main/resources/META-INF/services/com.p6spy.engine.logging.LoggingEventListener

However, when I do this nothing gets logged. Is it possible to add error logging without disabling the default event listener?

[cowwoc]

The only way I found to make this work is using the following spy.properties configuration:

modulelist=com.p6spy.engine.logging.P6LogFactory,com.p6spy.engine.outage.P6OutageFactory,\ foobar.LogExceptionsFactory

where foobar.LogExceptionsFactory is defined as:

public final class LogExceptionsFactory implements P6Factory
{
	private static final ErrorLoggingEventListener ERROR_LOGGING_INSTANCE = new ErrorLoggingEventListener();

	@Override
	public JdbcEventListener getJdbcEventListener()
	{
		return ERROR_LOGGING_INSTANCE;
	}

	@Override
	public P6LoadableOptions getOptions(P6OptionsRepository optionsRepository)
	{
		return new P6LogOptions(optionsRepository);
	}
}

Please document the use of EventListeners. This was much harder than it should have been :)