Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    text
    copied!<p>You can use log4j to output debug information like so:</p> <pre><code>log4j.logger.com.mchange=DEBUG, STDOUT ### direct log messages to stdout ### log4j.appender.STDOUT=org.apache.log4j.ConsoleAppender log4j.appender.STDOUT.Target=System.out log4j.appender.STDOUT.layout=org.apache.log4j.PatternLayout log4j.appender.STDOUT.layout.ConversionPattern=%t %d{dd/MMM/yyyy:H:mm:ssZ} %5p %c{1}:%L - %m%n </code></pre> <p>If you put the above in a file called <code>log4j.properties</code> and put that file in your classpath you should get tons of debug output from c3p0.</p> <p>Example output:</p> <pre><code>main 14/Dec/2009:13:24:49-0500 DEBUG BasicResourcePool:289 - com.mchange.v2.resourcepool.BasicResourcePool@16c06dd config: [start -&gt; 0; min -&gt; 0; max -&gt; 5; inc -&gt; 1; num_acq_attempts -&gt; 30; acq_attempt_delay -&gt; 1000; check_idle_resources_delay -&gt; 300000; mox_resource_age -&gt; 0; max_idle_time -&gt; 100000; excess_max_idle_time -&gt; 0; destroy_unreturned_resc_time -&gt; 0; expiration_enforcement_delay -&gt; 25000; break_on_acquisition_failure -&gt; false; debug_store_checkout_exceptions -&gt; false] main 14/Dec/2009:13:24:49-0500 DEBUG BasicResourcePool:538 - acquire test -- pool size: 0; target_pool_size: 0; desired target? 1 main 14/Dec/2009:13:24:49-0500 DEBUG BasicResourcePool:404 - incremented pending_acquires: 1 main 14/Dec/2009:13:24:49-0500 DEBUG BasicResourcePool:1291 - awaitAvailable(): [unknown] </code></pre> <p><a href="http://logging.apache.org/log4j/1.2/index.html" rel="nofollow noreferrer">log4j</a></p>
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload