Skip to Main Content
Forums

New to Java

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem while using c3p0 connection pooling with hibernate

807600Oct 14 2007 — edited Oct 15 2007
Hi,
I am trying to run a java stand alone program with hibernate with c3p0 connection pooling. While the program runs fine with hibernate internal pooling but after i added the configuration to hibernate.cfg.xml for c3p0 connection pooling it gave me below error. Any ideas?

-----------------------------------------------
hibernate.cfg.xml
-----------------------------------------------
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

<session-factory>

<!-- Database connection settings -->
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost/firsthibernate</property>
<property name="connection.username">root</property>
<property name="connection.password">mysqladmin</property>
<property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>


<!-- configuration pool via c3p0 -->
<property name="c3p0.acquire_increment">2</property>
<property name="c3p0.idle_test_period">300</property> <!-- seconds -->
<property name="c3p0.max_size">100</property>
<property name="c3p0.max_statements">100</property>
<property name="c3p0.min_size">10</property>
<property name="c3p0.timeout">1000</property> <!-- seconds -->


<!-- JDBC connection pool (use the built-in)
<property name="connection.pool_size">1</property> -->

<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>

<!-- Enable Hibernate's automatic session context management -->
<property name="current_session_context_class">thread</property>

<!-- Disable the second-level cache -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>
<!-- Hibernate will generate comments inside the SQL, for easier debugging -->
<property name="hibernate.use_sql_comments">true</property>

<!-- Drop and re-create the database schema on startup -->
<property name="hbm2ddl.auto">create</property>

<mapping resource="events/Event.hbm.xml"/>
<!-- <mapping resource="events/Person.hbm.xml"/> -->
<mapping resource="events/Man.hbm.xml"/>
<mapping resource="events/Payment.hbm.xml"/>


</session-factory>

</hibernate-configuration>

------------------------------------------------
Error log
-------------------------------------------------
23:04:11,781 INFO Environment:514 - Hibernate 3.2.5
23:04:11,781 INFO Environment:547 - hibernate.properties not found
23:04:11,781 INFO Environment:681 - Bytecode provider name : cglib
23:04:11,781 INFO Environment:598 - using JDK 1.4 java.sql.Timestamp handling
23:04:11,843 INFO Configuration:1426 - configuring from resource: /hibernate.cfg.xml
23:04:11,843 INFO Configuration:1403 - Configuration resource: /hibernate.cfg.xml
23:04:12,078 INFO Configuration:553 - Reading mappings from resource : events/Event.hbm.xml
23:04:12,187 INFO HbmBinder:300 - Mapping class: events.Event -> EVENTS
23:04:12,203 INFO HbmBinder:1422 - Mapping collection: events.Event.participants -> PERSON_EVENT
23:04:12,218 INFO Configuration:553 - Reading mappings from resource : events/Man.hbm.xml
23:04:12,250 INFO HbmBinder:300 - Mapping class: events.Man -> MAN
23:04:12,281 INFO HbmBinder:817 - Mapping subclass: events.Person -> MAN
23:04:12,281 INFO Configuration:553 - Reading mappings from resource : events/Payment.hbm.xml
23:04:12,312 INFO HbmBinder:300 - Mapping class: events.Payment -> PAYMENT
23:04:12,312 INFO HbmBinder:817 - Mapping subclass: events.CreditCardPayment -> PAYMENT
23:04:12,312 INFO HbmBinder:941 - Mapping class join: events.CreditCardPayment -> CREDIT_PAYMENT
23:04:12,328 INFO HbmBinder:817 - Mapping subclass: events.CashPayment -> PAYMENT
23:04:12,328 INFO HbmBinder:941 - Mapping class join: events.CashPayment -> CASH_PAYMENT
23:04:12,328 INFO HbmBinder:817 - Mapping subclass: events.ChequePayment -> PAYMENT
23:04:12,328 INFO HbmBinder:941 - Mapping class join: events.ChequePayment -> CHEQUE_PAYMENT
23:04:12,328 INFO Configuration:1541 - Configured SessionFactory: null
23:04:12,406 INFO C3P0ConnectionProvider:81 - C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/firsthibernate
23:04:12,406 INFO C3P0ConnectionProvider:82 - Connection properties: {user=root, password=****}
23:04:12,406 INFO C3P0ConnectionProvider:85 - autocommit mode: false
23:04:12,406 WARN C3P0ConnectionProvider:210 - Both hibernate-style property 'hibernate.c3p0.max_size' and c3p0-style property 'c3p0.max_size' have been set in hibernate.properties. Hibernate-style property 'hibernate.c3p0.max_size' will be used and c3p0-style property 'c3p0.max_size' will be ignored!
23:04:12,406 WARN C3P0ConnectionProvider:210 - Both hibernate-style property 'hibernate.c3p0.min_size' and c3p0-style property 'c3p0.min_size' have been set in hibernate.properties. Hibernate-style property 'hibernate.c3p0.min_size' will be used and c3p0-style property 'c3p0.min_size' will be ignored!
23:04:12,406 WARN C3P0ConnectionProvider:210 - Both hibernate-style property 'hibernate.c3p0.timeout' and c3p0-style property 'c3p0.timeout' have been set in hibernate.properties. Hibernate-style property 'hibernate.c3p0.timeout' will be used and c3p0-style property 'c3p0.timeout' will be ignored!
23:04:12,406 WARN C3P0ConnectionProvider:210 - Both hibernate-style property 'hibernate.c3p0.idle_test_period' and c3p0-style property 'c3p0.idle_test_period' have been set in hibernate.properties. Hibernate-style property 'hibernate.c3p0.idle_test_period' will be used and c3p0-style property 'c3p0.idle_test_period' will be ignored!
23:04:12,406 WARN C3P0ConnectionProvider:210 - Both hibernate-style property 'hibernate.c3p0.acquire_increment' and c3p0-style property 'c3p0.acquire_increment' have been set in hibernate.properties. Hibernate-style property 'hibernate.c3p0.acquire_increment' will be used and c3p0-style property 'c3p0.acquire_increment' will be ignored!
23:04:12,406 WARN C3P0ConnectionProvider:210 - Both hibernate-style property 'hibernate.c3p0.max_statements' and c3p0-style property 'c3p0.max_statements' have been set in hibernate.properties. Hibernate-style property 'hibernate.c3p0.max_statements' will be used and c3p0-style property 'c3p0.max_statements' will be ignored!
23:04:12,421 INFO MLog:80 - MLog clients using log4j logging.
23:04:12,578 INFO C3P0Registry:204 - Initializing c3p0-0.9.1 [built 16-January-2007 14:46:42; debug? true; trace: 10]
23:04:12,593 DEBUG DynamicPooledDataSourceManagerMBean:235 - MBean: com.mchange.v2.c3p0:type=PooledDataSource[1hge13e7p18a02r81ib5g04|1386918] registered.
23:04:12,609 DEBUG DynamicPooledDataSourceManagerMBean:231 - MBean: com.mchange.v2.c3p0:type=PooledDataSource[1hge13e7p18a02r81ib5g04|1386918] unregistered, in order to be reregistered after update.
23:04:12,625 DEBUG DynamicPooledDataSourceManagerMBean:235 - MBean: com.mchange.v2.c3p0:type=PooledDataSource[1hge13e7p18a02r81ib5g04|1386918] registered.
23:04:12,656 INFO AbstractPoolBackedDataSource:462 - Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@267a74b6 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@1fb70431 [ acquireIncrement -> 2, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge13e7p18a02r81ib5g04|17725c4, idleConnectionTestPeriod -> 300, initialPoolSize -> 10, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1000, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 100, maxStatements -> 100, maxStatementsPerConnection -> 0, minPoolSize -> 10, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@f75d5745 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 1hge13e7p18a02r81ib5g04|20be79, jdbcUrl -> jdbc:mysql://localhost/firsthibernate, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 1hge13e7p18a02r81ib5g04|1386918, numHelperThreads -> 3 ]
23:04:12,671 DEBUG BasicResourcePool:404 - incremented pending_acquires: 1
23:04:12,671 DEBUG BasicResourcePool:404 - incremented pending_acquires: 2
23:04:12,671 DEBUG BasicResourcePool:404 - incremented pending_acquires: 3
23:04:12,671 DEBUG BasicResourcePool:404 - incremented pending_acquires: 4
23:04:12,718 DEBUG BasicResourcePool:404 - incremented pending_acquires: 5
23:04:12,718 DEBUG BasicResourcePool:404 - incremented pending_acquires: 6
23:04:12,718 DEBUG BasicResourcePool:404 - incremented pending_acquires: 7
23:04:12,718 DEBUG BasicResourcePool:404 - incremented pending_acquires: 8
23:04:12,718 DEBUG BasicResourcePool:404 - incremented pending_acquires: 9
23:04:12,718 DEBUG BasicResourcePool:404 - incremented pending_acquires: 10
23:04:12,718 DEBUG BasicResourcePool:289 - com.mchange.v2.resourcepool.BasicResourcePool@139b78e config: [start -> 10; min -> 10; max -> 100; inc -> 2; num_acq_attempts -> 30; acq_attempt_delay -> 1000; check_idle_resources_delay -> 300000; mox_resource_age -> 0; max_idle_time -> 1000000; excess_max_idle_time -> 0; destroy_unreturned_resc_time -> 0; expiration_enforcement_delay -> 250000; break_on_acquisition_failure -> false; debug_store_checkout_exceptions -> false]
23:04:12,718 DEBUG BasicResourcePool:538 - acquire test -- pool size: 0; target_pool_size: 10; desired target? 1
23:04:12,718 DEBUG BasicResourcePool:1291 - awaitAvailable(): [unknown]
23:04:12,718 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@139b78e [managed: 0, unused: 0, excluded: 0]
23:04:12,859 DEBUG GooGooStatementCache:297 - checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
23:04:12,859 DEBUG C3P0PooledConnectionPool:217 - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@39ab89.acquireResource() returning.
23:04:12,859 DEBUG GooGooStatementCache:297 - checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
23:04:12,859 DEBUG C3P0PooledConnectionPool:217 - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@39ab89.acquireResource() returning.
23:04:12,859 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@139b78e [managed: 1, unused: 1, excluded: 0]
23:04:12,859 DEBUG GooGooStatementCache:297 - checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
23:04:12,859 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@139b78e [managed: 2, unused: 1, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@cb6009)
23:04:12,875 DEBUG C3P0PooledConnectionPool:217 - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@39ab89.acquireResource() returning.
23:04:12,875 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@139b78e [managed: 2, unused: 1, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@cb6009)
23:04:12,875 DEBUG BasicResourcePool:422 - decremented pending_acquires: 9
23:04:12,875 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@139b78e [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@cb6009)
23:04:12,875 DEBUG BasicResourcePool:422 - decremented pending_acquires: 8
23:04:12,875 DEBUG GooGooStatementCache:297 - checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
23:04:12,875 DEBUG BasicResourcePool:422 - decremented pending_acquires: 7
23:04:12,875 DEBUG C3P0PooledConnectionPool:217 - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@39ab89.acquireResource() returning.
23:04:12,875 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@139b78e [managed: 4, unused: 3, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@cb6009)
23:04:12,875 DEBUG BasicResourcePool:422 - decremented pending_acquires: 6
23:04:12,890 INFO SettingsFactory:89 - RDBMS: MySQL, version: 4.1.22-community-nt
23:04:12,890 INFO SettingsFactory:90 - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-3.0.17-ga ( $Date: 2005/04/06 14:12:56 $, $Revision: 1.27.2.47 $ )
23:04:12,890 DEBUG GooGooStatementCache:297 - checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
23:04:12,890 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@139b78e [managed: 4, unused: 3, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@cb6009)
23:04:12,937 DEBUG GooGooStatementCache:297 - checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
23:04:12,937 DEBUG C3P0PooledConnectionPool:217 - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@39ab89.acquireResource() returning.
23:04:12,937 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@139b78e [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@cb6009)
23:04:12,937 DEBUG BasicResourcePool:422 - decremented pending_acquires: 5
23:04:12,937 DEBUG GooGooStatementCache:297 - checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
23:04:12,937 DEBUG C3P0PooledConnectionPool:217 - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@39ab89.acquireResource() returning.
23:04:12,937 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@139b78e [managed: 6, unused: 5, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@cb6009)
23:04:12,937 DEBUG BasicResourcePool:422 - decremented pending_acquires: 4
23:04:12,953 DEBUG GooGooStatementCache:297 - checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
23:04:12,953 DEBUG C3P0PooledConnectionPool:217 - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@39ab89.acquireResource() returning.
23:04:12,953 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@139b78e [managed: 7, unused: 6, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@cb6009)
23:04:12,953 DEBUG BasicResourcePool:422 - decremented pending_acquires: 3
23:04:12,953 DEBUG GooGooStatementCache:297 - checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
23:04:12,953 DEBUG C3P0PooledConnectionPool:217 - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@39ab89.acquireResource() returning.
23:04:12,953 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@139b78e [managed: 8, unused: 7, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@cb6009)
23:04:12,953 DEBUG BasicResourcePool:422 - decremented pending_acquires: 2
23:04:12,953 DEBUG GooGooStatementCache:297 - checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
23:04:12,953 DEBUG GooGooStatementCache:297 - checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
23:04:12,953 DEBUG C3P0PooledConnectionPool:217 - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@39ab89.acquireResource() returning.
23:04:12,953 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@139b78e [managed: 9, unused: 9, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@cb6009)
23:04:12,953 DEBUG BasicResourcePool:422 - decremented pending_acquires: 1
23:04:12,968 INFO Dialect:152 - Using dialect: org.hibernate.dialect.MySQLDialect
23:04:12,968 DEBUG GooGooStatementCache:297 - checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
23:04:12,968 DEBUG C3P0PooledConnectionPool:217 - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@39ab89.acquireResource() returning.
23:04:12,968 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@139b78e [managed: 10, unused: 10, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@cb6009)
23:04:12,968 DEBUG BasicResourcePool:422 - decremented pending_acquires: 0
23:04:12,968 INFO TransactionFactoryFactory:34 - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
23:04:12,968 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
23:04:12,968 INFO SettingsFactory:143 - Automatic flush during beforeCompletion(): disabled
23:04:12,968 INFO SettingsFactory:147 - Automatic session close at end of transaction: disabled
23:04:12,968 INFO SettingsFactory:154 - JDBC batch size: 15
23:04:12,968 INFO SettingsFactory:157 - JDBC batch updates for versioned data: disabled
23:04:12,968 INFO SettingsFactory:162 - Scrollable result sets: enabled
23:04:12,968 INFO SettingsFactory:170 - JDBC3 getGeneratedKeys(): enabled
23:04:12,968 INFO SettingsFactory:178 - Connection release mode: auto
23:04:12,968 INFO SettingsFactory:202 - Maximum outer join fetch depth: 2
23:04:12,968 INFO SettingsFactory:205 - Default batch fetch size: 1
23:04:12,968 INFO SettingsFactory:209 - Generate SQL with comments: enabled
23:04:12,968 INFO SettingsFactory:213 - Order SQL updates by primary key: disabled
23:04:12,968 INFO SettingsFactory:217 - Order SQL inserts for batching: disabled
23:04:12,968 INFO SettingsFactory:386 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
23:04:12,984 INFO ASTQueryTranslatorFactory:24 - Using ASTQueryTranslatorFactory
23:04:12,984 INFO SettingsFactory:225 - Query language substitutions: {}
23:04:12,984 INFO SettingsFactory:230 - JPA-QL strict compliance: disabled
23:04:12,984 INFO SettingsFactory:235 - Second-level cache: enabled
23:04:12,984 INFO SettingsFactory:239 - Query cache: disabled
23:04:12,984 INFO SettingsFactory:373 - Cache provider: org.hibernate.cache.NoCacheProvider
23:04:12,984 INFO SettingsFactory:254 - Optimize cache for minimal puts: disabled
23:04:12,984 INFO SettingsFactory:263 - Structured second-level cache entries: disabled
23:04:12,984 INFO SettingsFactory:283 - Echoing all SQL to stdout
23:04:12,984 INFO SettingsFactory:290 - Statistics: disabled
23:04:12,984 INFO SettingsFactory:294 - Deleted entity synthetic identifier rollback: disabled
23:04:12,984 INFO SettingsFactory:309 - Default entity-mode: pojo
23:04:12,984 INFO SettingsFactory:313 - Named query checking : enabled
23:04:13,015 INFO SessionFactoryImpl:161 - building session factory
23:04:13,296 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
23:04:13,296 INFO SchemaExport:154 - Running hbm2ddl schema export
23:04:13,296 INFO SchemaExport:179 - exporting generated schema to database
23:04:13,296 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@139b78e [managed: 10, unused: 9, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@cb6009)
23:04:15,984 INFO SchemaExport:196 - schema export complete
23:04:15,984 DEBUG GooGooStatementCache:297 - checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
23:04:15,984 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@139b78e [managed: 10, unused: 9, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@cb6009)
23:04:15,984 DEBUG GooGooStatementCache:297 - checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
23:04:16,078 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@139b78e [managed: 10, unused: 9, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@cb6009)
23:04:16,093 DEBUG SQL:401 - /* insert events.CashPayment */ insert into PAYMENT (AMOUNT, PAYMENT_DATE, PAYMENT_TYPE) values (?, ?, 'CASH')
Hibernate: /* insert events.CashPayment */ insert into PAYMENT (AMOUNT, PAYMENT_DATE, PAYMENT_TYPE) values (?, ?, 'CASH')
23:04:16,109 DEBUG GooGooStatementCache:457 - cxnStmtMgr.statementSet( com.mysql.jdbc.Connection@6bade9 ).size(): 1
23:04:16,109 DEBUG GooGooStatementCache:196 - checkoutStatement: com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 1; checked out: 1; num connections: 1; num keys: 1
23:04:16,140 DEBUG GooGooStatementCache:271 - checkinStatement(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 1; checked out: 0; num connections: 1; num keys: 1
23:04:16,140 DEBUG SQL:401 - /* insert events.CashPayment */ insert into CASH_PAYMENT (CURRENCY_TYPE, PAYMENT_ID) values (?, ?)
Hibernate: /* insert events.CashPayment */ insert into CASH_PAYMENT (CURRENCY_TYPE, PAYMENT_ID) values (?, ?)
23:04:16,140 DEBUG GooGooStatementCache:457 - cxnStmtMgr.statementSet( com.mysql.jdbc.Connection@6bade9 ).size(): 2
23:04:16,140 DEBUG GooGooStatementCache:196 - checkoutStatement: com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 2; checked out: 1; num connections: 1; num keys: 2
23:04:16,140 DEBUG GooGooStatementCache:271 - checkinStatement(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 2; checked out: 0; num connections: 1; num keys: 2
23:04:16,218 DEBUG GooGooStatementCache:297 - checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 2; checked out: 0; num connections: 1; num keys: 2
23:04:16,218 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@139b78e [managed: 10, unused: 9, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@cb6009)
23:04:16,218 DEBUG GooGooStatementCache:297 - checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 2; checked out: 0; num connections: 1; num keys: 2
23:04:16,234 INFO SessionFactoryImpl:769 - closing
23:04:16,234 DEBUG ThreadPoolAsynchronousRunner:578 - Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main] interrupted. Shutting down.
23:04:16,234 DEBUG ActiveManagementCoordinator:133 - MBean: com.mchange.v2.c3p0:type=PooledDataSource[1hge13e7p18a02r81ib5g04|1386918] unregistered.
23:04:16,234 DEBUG ThreadPoolAsynchronousRunner:578 - Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main] interrupted. Shutting down.
23:04:16,234 DEBUG ActiveManagementCoordinator:85 - C3P0Registry mbean unregistered.
23:04:16,234 DEBUG ThreadPoolAsynchronousRunner:578 - Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main] interrupted. Shutting down.
23:04:16,234 DEBUG BasicResourcePool:962 - Preparing to destroy resource: com.mchange.v2.c3p0.impl.NewPooledConnection@be0e27
23:04:16,234 DEBUG C3P0PooledConnectionPool:468 - Preparing to destroy PooledConnection: com.mchange.v2.c3p0.impl.NewPooledConnection@be0e27
23:04:16,234 DEBUG AbstractPoolBackedDataSource:417 - com.mchange.v2.c3p0.PoolBackedDataSource@1386918 has been closed.
java.lang.Exception: DEBUG STACK TRACE for PoolBackedDataSource.close().
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.close(AbstractPoolBackedDataSource.java:417)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.close(AbstractPoolBackedDataSource.java:429)
at com.mchange.v2.c3p0.DataSources.destroy(DataSources.java:359)
at com.mchange.v2.c3p0.DataSources.destroy(DataSources.java:335)
at org.hibernate.connection.C3P0ConnectionProvider.close(C3P0ConnectionProvider.java:182)
at org.hibernate.impl.SessionFactoryImpl.close(SessionFactoryImpl.java:803)
at events.EventManager.main(EventManager.java:70)
23:04:16,234 DEBUG NewPooledConnection:491 - com.mchange.v2.c3p0.impl.NewPooledConnection@be0e27 closed by a client.
java.lang.Exception: DEBUG -- CLOSE BY CLIENT STACK TRACE
at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:491)
at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:191)
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.resourcepool.BasicResourcePool.destroyResource(BasicResourcePool.java:989)
at com.mchange.v2.resourcepool.BasicResourcePool.access$100(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$5.run(BasicResourcePool.java:1174)
23:04:16,234 DEBUG C3P0PooledConnectionPool:476 - Successfully destroyed PooledConnection: com.mchange.v2.c3p0.impl.NewPooledConnection@be0e27
23:04:16,234 DEBUG BasicResourcePool:967 - Successfully destroyed resource: com.mchange.v2.c3p0.impl.NewPooledConnection@be0e27
23:04:16,234 DEBUG BasicResourcePool:962 - Preparing to destroy resource: com.mchange.v2.c3p0.impl.NewPooledConnection@c9131c
23:04:16,234 DEBUG C3P0PooledConnectionPool:468 - Preparing to destroy PooledConnection: com.mchange.v2.c3p0.impl.NewPooledConnection@c9131c
23:04:16,234 DEBUG NewPooledConnection:491 - com.mchange.v2.c3p0.impl.NewPooledConnection@c9131c closed by a client.
java.lang.Exception: DEBUG -- CLOSE BY CLIENT STACK TRACE
at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:491)
at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:191)
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.resourcepool.BasicResourcePool.destroyResource(BasicResourcePool.java:989)
at com.mchange.v2.resourcepool.BasicResourcePool.access$100(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$5.run(BasicResourcePool.java:1174)
23:04:16,234 DEBUG C3P0PooledConnectionPool:476 - Successfully destroyed PooledConnection: com.mchange.v2.c3p0.impl.NewPooledConnection@c9131c
23:04:16,234 DEBUG BasicResourcePool:967 - Successfully destroyed resource: com.mchange.v2.c3p0.impl.NewPooledConnection@c9131c
23:04:16,234 DEBUG BasicResourcePool:962 - Preparing to destroy resource: com.mchange.v2.c3p0.impl.NewPooledConnection@193a66f
23:04:16,234 DEBUG C3P0PooledConnectionPool:468 - Preparing to destroy PooledConnection: com.mchange.v2.c3p0.impl.NewPooledConnection@193a66f
23:04:16,234 DEBUG NewPooledConnection:491 - com.mchange.v2.c3p0.impl.NewPooledConnection@193a66f closed by a client.
java.lang.Exception: DEBUG -- CLOSE BY CLIENT STACK TRACE
at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:491)
at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:191)
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.resourcepool.BasicResourcePool.destroyResource(BasicResourcePool.java:989)
at com.mchange.v2.resourcepool.BasicResourcePool.access$100(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$5.run(BasicResourcePool.java:1174)
23:04:16,234 DEBUG C3P0PooledConnectionPool:476 - Successfully destroyed PooledConnection: com.mchange.v2.c3p0.impl.NewPooledConnection@193a66f
23:04:16,234 DEBUG BasicResourcePool:967 - Successfully destroyed resource: com.mchange.v2.c3p0.impl.NewPooledConnection@193a66f
23:04:16,234 DEBUG BasicResourcePool:962 - Preparing to destroy resource: com.mchange.v2.c3p0.impl.NewPooledConnection@cb6009
23:04:16,234 DEBUG C3P0PooledConnectionPool:468 - Preparing to destroy PooledConnection: com.mchange.v2.c3p0.impl.NewPooledConnection@cb6009
23:04:16,234 DEBUG NewPooledConnection:491 - com.mchange.v2.c3p0.impl.NewPooledConnection@cb6009 closed by a client.
java.lang.Exception: DEBUG -- CLOSE BY CLIENT STACK TRACE
at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:491)
at com.mchange.v2.c3p0.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 12 2007
Added on Oct 14 2007
6 comments
11,626 views