package log4jdbc;import java.sql.Connection;import java.sql.PreparedStatement;import org.junit.Test;import com.mchange.v2.c3p0.ComboPooledDataSource;public class DataSourceTest {    @Test    public void testC3P0() {        try {            ComboPooledDataSource dataSource = new ComboPooledDataSource();            dataSource.setUser("root");            dataSource.setPassword("密码");            dataSource.setDriverClass("net.sf.log4jdbc.DriverSpy");            dataSource.setJdbcUrl("jdbc:log4jdbc:mysql://localhost:3306/实例名");            dataSource.setMaxPoolSize(50);            Connection conn = dataSource.getConnection();            String sql = "select * " + "from tb_person where id=?";            PreparedStatement ps = null;            ps = conn.prepareStatement(sql);            ps.setInt(1, 1);            ps.executeQuery();            ps.close();            conn.close();        } catch (Exception e) {            e.printStackTrace();        }    }}

log4j:ERROR No appender named [connection-appender] could be found.2015-09-22 22:40:38.933 DEBUG debug: ... log4jdbc initializing ...2015-09-22 22:40:38.934 DEBUG debug:   log4jdbc.properties not found on classpath2015-09-22 22:40:38.934 DEBUG debug: x log4jdbc.debug.stack.prefix is not defined2015-09-22 22:40:38.934 DEBUG debug: x log4jdbc.sqltiming.warn.threshold is not defined2015-09-22 22:40:38.934 DEBUG debug: x log4jdbc.sqltiming.error.threshold is not defined2015-09-22 22:40:38.934 DEBUG debug: x log4jdbc.dump.booleanastruefalse is not defined (using default value false)2015-09-22 22:40:38.934 DEBUG debug: x log4jdbc.dump.sql.maxlinelength is not defined (using default of 90)2015-09-22 22:40:38.934 DEBUG debug: x log4jdbc.dump.fulldebugstacktrace is not defined (using default value false)2015-09-22 22:40:38.934 DEBUG debug: x log4jdbc.statement.warn is not defined (using default value false)2015-09-22 22:40:38.934 DEBUG debug: x log4jdbc.dump.sql.select is not defined (using default value true)2015-09-22 22:40:38.934 DEBUG debug: x log4jdbc.dump.sql.insert is not defined (using default value true)2015-09-22 22:40:38.935 DEBUG debug: x log4jdbc.dump.sql.update is not defined (using default value true)2015-09-22 22:40:38.935 DEBUG debug: x log4jdbc.dump.sql.delete is not defined (using default value true)2015-09-22 22:40:38.935 DEBUG debug: x log4jdbc.dump.sql.create is not defined (using default value true)2015-09-22 22:40:38.935 DEBUG debug: x log4jdbc.dump.sql.addsemicolon is not defined (using default value false)2015-09-22 22:40:38.935 DEBUG debug: x log4jdbc.auto.load.popular.drivers is not defined (using default value true)2015-09-22 22:40:38.935 DEBUG debug: x log4jdbc.trim.sql is not defined (using default value true)2015-09-22 22:40:38.935 DEBUG debug: x log4jdbc.trim.sql.extrablanklines is not defined (using default value true)2015-09-22 22:40:38.935 DEBUG debug: x log4jdbc.suppress.generated.keys.exception is not defined (using default value false)2015-09-22 22:40:38.935 DEBUG debug: x log4jdbc.drivers is not defined2015-09-22 22:40:38.942 DEBUG debug:   FOUND DRIVER com.mysql.jdbc.Driver2015-09-22 22:40:38.945 DEBUG debug: ... log4jdbc initialized! ...

-----> 2015-09-22 22:40:39.241 
     
        com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:379)2. select * from tb_person where id=1