Configure slowQueryThreshold on JBoss 5.1.0 via Properties

[Rob Heim]

I have been playing around with this library today (jdbcdslog-1.0.5.jar) to try and trace SQL queries on my system (JBoss AS 5.1.0 using Microsoft SQL Server and Oracle).

Everything seems to be working with the exception of the slowQueryThreshold.

The only way I can get that parameter to be recognized is to include it as a JVM Startup parameter.

I have tried creating a simple jdbcdslog.properties file and placing it in various locations, but no matter where I put it the parameter is ignored.

Here is the contents of my file:

jdbcdslog.slowQueryThreshold=10

jdbcdslog.logText=false

jdbcdslog.printStackTrace=false

I have tried placing it in the SERVER\lib folder along with the library itself, as well as within several JBoss classpath locations, to no avail.

I'd really like to avoid having to use the startup parameter if at all possible.  Does anyone know what I might be doing incorrectly here?

Thanks in advance for your assistance.

--Rob 

[Rob Heim]

I found my own answer.  The properties file needs to go into the JBoss CONF directory.