Bom dia a todos, gostaria de saber qual propriedade do cp30 que desabilita os logs que ele gera no console.
Talvez te ajude.
Tipo queria saber se tem uma propriedade das configurações do cp30 que desabilita isso.
Cara, c leu os links? O.o
Amigo funcionou não!
abaixo segue os logs que ele está gerando:
14:48:47.095 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] [C3P0PooledConnectionPool] - Successfully destroyed PooledConnection: com.mchange.v2.c3p0.impl.NewPooledConnection@eb724
14:48:47.095 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] [C3P0PooledConnectionPool] - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@eb724] on IDLE CHECK has SUCCEEDED.
14:48:47.095 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] [BasicResourcePool] - Successfully destroyed resource: com.mchange.v2.c3p0.impl.NewPooledConnection@eb724
14:48:47.126 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] [C3P0PooledConnectionPool] - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@1eb0.acquireResource() returning.
14:48:47.126 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] [BasicResourcePool] - trace com.mchange.v2.resourcepool.BasicResourcePool@36527f [managed: 5, unused: 5, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@4ac216)
14:48:47.126 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] [BasicResourcePool] - decremented pending_acquires: 0
14:48:47.987 DEBUG [Timer-0] [BasicResourcePool] - trace com.mchange.v2.resourcepool.BasicResourcePool@36527f [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@4ac216)
14:48:47.993 DEBUG [Timer-0] [BasicResourcePool] - trace com.mchange.v2.resourcepool.BasicResourcePool@36527f [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@4ac216)
14:48:47.994 INFO [Timer-0] [ComunicacaoTerminais] - DADOS DO PROCESSO =>>>> Partida [Fri Nov 25 14:38:46 BRST 2011] PID [2524] Memória utilizada [15936] Memória livre [11766] Memória total [253440].
14:48:47.994 DEBUG [Timer-0] [BasicResourcePool] - trace com.mchange.v2.resourcepool.BasicResourcePool@36527f [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@4ac216)
14:48:48.002 DEBUG [Timer-0] [BasicResourcePool] - trace com.mchange.v2.resourcepool.BasicResourcePool@36527f [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@4ac216)
14:49:12.086 DEBUG [Timer-1] [BasicResourcePool] - Checking for expired resources - Fri Nov 25 14:49:12 BRST 2011 [com.mchange.v2.resourcepool.BasicResourcePool@36527f]
14:49:12.086 DEBUG [Timer-1] [BasicResourcePool] - BEGIN check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@36527f]
14:49:12.086 DEBUG [Timer-1] [BasicResourcePool] - EXPIRED idle resource: com.mchange.v2.c3p0.impl.NewPooledConnection@12c4768 ---> idle_time: 124927; max_idle_time: 100000 [com.mchange.v2.resourcepool.BasicResourcePool@36527f]
14:49:12.086 DEBUG [Timer-1] [BasicResourcePool] - Removing expired resource: com.mchange.v2.c3p0.impl.NewPooledConnection@12c4768 [com.mchange.v2.resourcepool.BasicResourcePool@36527f]
14:49:12.086 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] [BasicResourcePool] - Preparing to destroy resource: com.mchange.v2.c3p0.impl.NewPooledConnection@12c4768
14:49:12.086 DEBUG [Timer-1] [BasicResourcePool] - trace com.mchange.v2.resourcepool.BasicResourcePool@36527f [managed: 4, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@4ac216)
14:49:12.086 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] [C3P0PooledConnectionPool] - Preparing to destroy PooledConnection: com.mchange.v2.c3p0.impl.NewPooledConnection@12c4768
14:49:12.087 DEBUG [Timer-1] [BasicResourcePool] - trace com.mchange.v2.resourcepool.BasicResourcePool@36527f [managed: 4, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@4ac216)
14:49:12.087 DEBUG [Timer-1] [BasicResourcePool] - EXPIRED idle resource: com.mchange.v2.c3p0.impl.NewPooledConnection@ab835a ---> idle_time: 124948; max_idle_time: 100000 [com.mchange.v2.resourcepool.BasicResourcePool@36527f]
14:49:12.087 DEBUG [Timer-1] [BasicResourcePool] - Removing expired resource: com.mchange.v2.c3p0.impl.NewPooledConnection@ab835a [com.mchange.v2.resourcepool.BasicResourcePool@36527f]
14:49:12.087 DEBUG [Timer-1] [BasicResourcePool] - trace com.mchange.v2.resourcepool.BasicResourcePool@36527f [managed: 3, unused: 3, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@4ac216)
14:49:12.087 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] [BasicResourcePool] - Preparing to destroy resource: com.mchange.v2.c3p0.impl.NewPooledConnection@ab835a
14:49:12.087 DEBUG [Timer-1] [BasicResourcePool] - trace com.mchange.v2.resourcepool.BasicResourcePool@36527f [managed: 3, unused: 3, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@4ac216)
14:49:12.087 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] [C3P0PooledConnectionPool] - Preparing to destroy PooledConnection: com.mchange.v2.c3p0.impl.NewPooledConnection@ab835a
14:49:12.087 DEBUG [Timer-1] [BasicResourcePool] - FINISHED check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@36527f]
14:49:12.088 DEBUG [Timer-1] [BasicResourcePool] - incremented pending_acquires: 1
14:49:12.088 DEBUG [Timer-1] [BasicResourcePool] - incremented pending_acquires: 2
14:49:12.091 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] [NewPooledConnection] - com.mchange.v2.c3p0.impl.NewPooledConnection@12c4768 closed by a client.
java.lang.Exception: DEBUG -- CLOSE BY CLIENT STACK TRACE
at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:566)
at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:234)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:470)
at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:964)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
14:49:12.092 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] [C3P0PooledConnectionPool] - Successfully destroyed PooledConnection: com.mchange.v2.c3p0.impl.NewPooledConnection@12c4768
14:49:12.092 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] [BasicResourcePool] - Successfully destroyed resource: com.mchange.v2.c3p0.impl.NewPooledConnection@12c4768
14:49:12.094 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] [NewPooledConnection] - com.mchange.v2.c3p0.impl.NewPooledConnection@ab835a closed by a client.
java.lang.Exception: DEBUG -- CLOSE BY CLIENT STACK TRACE
at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:566)
at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:234)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:470)
at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:964)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
14:49:12.095 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] [C3P0PooledConnectionPool] - Successfully destroyed PooledConnection: com.mchange.v2.c3p0.impl.NewPooledConnection@ab835a
14:49:12.095 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] [BasicResourcePool] - Successfully destroyed resource: com.mchange.v2.c3p0.impl.NewPooledConnection@ab835a
14:49:12.139 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] [C3P0PooledConnectionPool] - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@1eb0.acquireResource() returning.
14:49:12.139 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] [BasicResourcePool] - trace com.mchange.v2.resourcepool.BasicResourcePool@36527f [managed: 4, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@4ac216)
14:49:12.139 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] [BasicResourcePool] - decremented pending_acquires: 1
14:49:12.158 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] [C3P0PooledConnectionPool] - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@1eb0.acquireResource() returning.
14:49:12.159 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] [BasicResourcePool] - trace com.mchange.v2.resourcepool.BasicResourcePool@36527f [managed: 5, unused: 5, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@4ac216)
14:49:12.159 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] [BasicResourcePool] - decremented pending_acquires: 0São logs nesse estilo, porem não quero que ele gere esses logs pois minha aplicação perde desempenho. alguem pode me da um help ai?
A configuração do c3p0 esta da seguinte forma:
<!-- Configurando o pool de conexoes via JDBC -->
<!-- A quantidade máxima de conexões com o banco de dados do pool -->
<property name="hibernate.c3p0.max_size">200</property>
<!-- A quantidade mínima de conexões com o banco de dados do pool -->
<property name="hibernate.c3p0.min_size">2</property>
<!-- O tempo máximo de duração de um comando ao banco (segundos) -->
<property name="hibernate.c3p0.timeout">1000</property>
<!-- Número máximo de comandos simultâneos em execução -->
<property name="hibernate.c3p0.max_statements">100</property>
<!-- Tempo de espera antes que uma conexão em pool C3P0 seja validada. (segundos) -->
<property name="hibernate.c3p0.idle_test_period">200</property>
<!-- Número de conexões adquiridas quando o pool está esgotado. -->
<property name="hibernate.c3p0.acquire_increment">2</property>estou utilizando essa configuração dentro do hibernate.cfg