how do I turn off logging in java c3p0 connection pooling lib?

Question

hey all, I'm just getting started with c3p0 for database connection pooling. It's attaching itself to my log4j output currently. How do I set logging off or at least to SEVERE level only for c3p0? I tried tweaking the properties file but not sure it's being picked up properly.

any ideas on how best to turn it off?

thanks

UPDATE: this seems to work in the log4j.properties file

log4j.logger.com.mchange.v2.c3p0.impl=INFO

log4j.logger.com.mchange=INFO

Philippe Carriere · Answer 1 · 2015-07-20T14:47:45.310

41

For those who are NOT using a configuration file, just to add the following in the code, before loading the connection pool.

Properties p = new Properties(System.getProperties());
p.put("com.mchange.v2.log.MLog", "com.mchange.v2.log.FallbackMLog");
p.put("com.mchange.v2.log.FallbackMLog.DEFAULT_CUTOFF_LEVEL", "OFF"); // Off or any other level
System.setProperties(p);

edited Jul 20 '15 at 14:47

answered May 16 '11 at 15:54

Philippe Carriere

3,712
4
25
46

1

`import java.util.Properties;` – thatWiseGuy Apr 22 '17 at 19:59

score 23 · Accepted Answer · edited Apr 28 '15 at 13:10

23

If you use a log4j.xml file you can simple define a logger for the c3po package:

<logger name="com.mchange.v2.c3p0">
    <level value="SEVERE"/>
</logger>

There are analogous methods for log4j.properties. I think it's just:

log4j.logger.com.mchange.v2.c3p0=SEVERE

edited Apr 28 '15 at 13:10

Stijn Geukens

15,454
8
66
101

answered Jun 04 '10 at 17:25

fasseg

17,504
8
62
73

1

I'm currently using a log4j.properties file, any idea how to do it in there? – James Jun 04 '10 at 17:27
2

added a log4j.properties logger example – fasseg Jun 04 '10 at 17:30
thanks! I had to tweak it a little but the log4j.properties file worked :) – James Jun 04 '10 at 17:39
@James how would this looks like in log4j2 properties file? – Wortig Nov 04 '21 at 10:23
How to do this in log4j2.properties? – mercury Mar 30 '22 at 22:53

score 4 · Answer 3 · answered Feb 12 '13 at 19:15

I was getting messages like the following:

Tue Feb 12 13:42:01 EST 2013 INFO: Profiler Event: [FETCH]  at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) duration: 0 ms, connection-id: 67, statement-id: 23, resultset-id: 27

This made me think that C3P0 was logging these messages. Actually the message is coming from the mysql connector because I enabled profiling by using a connection string like this:

jdbc:mysql://localhost/database?profileSQL=true

Remove ?profileSQL=true to make it stop logging these messages.

score 2 · Answer 4 · answered Feb 21 '11 at 08:48

2

I fixed problem with line of code:

com.mchange.v2.log.MLog.getLogger().setLevel(MLevel.INFO);

I am using log4j in my app.

answered Feb 21 '11 at 08:48

crimean

21
1

score 1 · Answer 5 · edited Mar 19 '15 at 22:26

1

I am working on clojure, through korma and for the life of my I could not get any properties files to load (I am new to clojure so I blame myself). If you are in a similar boat, the following might help you out.

(System/setProperties 
  (doto (java.util.Properties. (System/getProperties))
    (.put "com.mchange.v2.log.MLog" "com.mchange.v2.log.FallbackMLog")
    (.put "com.mchange.v2.log.FallbackMLog.DEFAULT_CUTOFF_LEVEL" "OFF")))

The is basically a clojure port of Philippe Carriere's answer above, thank you so much!

edited Mar 19 '15 at 22:26

boechat107

1,654
14
24

answered Jan 28 '15 at 18:17

a4word

74
3

1

Using Korma I needed to use this code before requiring its namespaces. – boechat107 Mar 19 '15 at 20:56
Yes, sorry forgot to mention that. If Korma is loaded, then the defaults so the lines above won't overwrite what is already set. – a4word Mar 20 '15 at 21:52

score 1 · Answer 6 · edited Nov 30 '11 at 17:09

1

You can set log level by adding following lines in log4j.xml Logging at least at Error level is desired.

< category name="com.mchange" additivity="false"> 
        < priority value="ERROR"/>
        < appender-ref ref="ASYNC"/>
     </ category>

If you really want to turn off c3P0 logging set property com.mchange.v2.log.FallbackMLog.DEFAULT_CUTOFF_LEVEL=OFF

in c3p0-Config.properties

or you can directly set this in code as an System property System.setProperty("com.mchange.v2.log.FallbackMLog.DEFAULT_CUTOFF_LEVEL",MLevel.OFF);

edited Nov 30 '11 at 17:09

CoolBeans

20,654
10
86
101

answered Jan 14 '11 at 15:25

Prashant Pandey

37
2

Adding one more additional line in properties file worked for me , `com.mchange.v2.log.MLog=com.mchange.v2.log.FallbackMLog` – Sabir Khan Aug 09 '16 at 08:12

score 0 · Answer 7 · answered May 15 '23 at 07:14

0

If you are using Spring, you can disable c3p0 logging by configuring it in application.properties:

logging.level.com.mchange.v2.c3p0=off

answered May 15 '23 at 07:14

Bieber Taylor

17
3

how do I turn off logging in java c3p0 connection pooling lib?

7 Answers7

Linked