-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 3 posts ] 
  Previous topic | Next topic 
Author Message
albabtain
 Post subject: c3p0 and hibernate 3.2.1 issue
PostPosted: Tue Dec 26, 2006 9:57 am 
Newbie

Joined: Wed Jun 15, 2005 12:23 pm
Posts: 7
Hibernate version:
3.2.1.ga
Mapping documents:
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
<session-factory>

<!-- Settings for a local MYSQL database. -->

<property name="dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost/mnews</property>
<property name="connection.username">****</property>
<property name="connection.password">****</property>
<property name="connection.useUnicode">true</property>
<property name="connection.characterEncoding">UTF8</property>

<!-- Use the C3P0 connection pool. -->
<property name="c3p0.min_size">3</property>
<property name="c3p0.max_size">5</property>
<property name="c3p0.timeout">1800</property>
<!-- Print SQL to stdout. -->
<property name="show_sql">true</property>
<property name="format_sql">true</property>

<!-- Drop and then re-create schema on SessionFactory build, for testing. -->
<property name="hbm2ddl.auto">update</property>

<!-- Bind the getCurrentSession() method to the thread. -->
<property name="current_session_context_class">thread</property>
<property name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>

<!-- Mapping files -->
<mapping resource="mapFilesMnews/Data.hbm.xml"/>
<mapping resource="mapFilesMnews/Source.hbm.xml"/>
<mapping resource="mapFilesMnews/DataTrack.hbm.xml"/>
<mapping resource="mapFilesMnews/Choice.hbm.xml"/>
<mapping resource="mapFilesMnews/Ncomment.hbm.xml"/>
<mapping resource="mapFilesMnews/Nuser.hbm.xml"/>
<mapping resource="mapFilesMnews/Tag.hbm.xml"/>
<mapping resource="mapFilesMnews/TagSet.hbm.xml"/>
<mapping resource="mapFilesMnews/Topic.hbm.xml"/>
<mapping resource="mapFilesMnews/TopicComment.hbm.xml"/>
<mapping resource="mapFilesMnews/TopicTrack.hbm.xml"/>
<mapping resource="mapFilesMnews/Vote.hbm.xml"/>

</session-factory>
</hibernate-configuration>
Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:
mysql 5
The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
DEBUG SocketServerInvokerThread-127.0.0.1-0 org.hibernate.exception.SQLExceptionConverterFactory - Using dialect defined converter
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Statistics: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.tool.hbm2ddl.TableMetadata - table found: mnews.topiccomment
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.tool.hbm2ddl.TableMetadata - columns: [topicid, createddate, lastupdateddate, nuserid, body, id]
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.tool.hbm2ddl.TableMetadata - foreign keys: [fk8d99aa50d5c87066, fk8d99aa50a27705fa]
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.tool.hbm2ddl.TableMetadata - indexes: [fk8d99aa50d5c87066, primary, fk8d99aa50a27705fa]
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.connection.C3P0ConnectionProvider - C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/mnews
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.connection.C3P0ConnectionProvider - Connection properties: {useUnicode=true, user=kenshin, password=****, characterEncoding=UTF8}
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.connection.C3P0ConnectionProvider - autocommit mode: false
DEBUG com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@1696452 [managed: 2, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@113108b)
DEBUG com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@7db937 [managed: 3, unused: 3, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@46a5c4)
INFO SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.c3p0.PoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@70898b [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@12cfd62 [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 12cfd62, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, maxIdleTime -> 1800, maxPoolSize -> 5, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@126fef6 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 126fef6, jdbcUrl -> jdbc:mysql://localhost/mnews, properties -> {useUnicode=true, user=******, password=******, characterEncoding=UTF8} ], preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ], factoryClassLocation -> null, identityToken -> 70898b, numHelperThreads -> 3 ]
DEBUG SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.resourcepool.BasicResourcePool - awaitAvailable(): [unknown]
DEBUG SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@1b80d9b [managed: 0, unused: 0, excluded: 0]
DEBUG com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@1696452 [managed: 3, unused: 3, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@113108b)
DEBUG com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@1b80d9b [managed: 1, unused: 1, excluded: 0]
DEBUG SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@34d75f ---> age: 0 max: 1800000 [com.mchange.v2.resourcepool.BasicResourcePool@1b80d9b]
DEBUG SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@1b80d9b [managed: 1, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@34d75f)
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - RDBMS: MySQL, version: 5.0.20-community-log
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.4 ( $Date: 2006-10-19 17:47:48 +0200 (Thu, 19 Oct 2006) $, $Revision: 5908 $ )
DEBUG SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@1b80d9b [managed: 1, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@34d75f)
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLInnoDBDialect
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.transaction.TransactionFactoryFactory - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - JDBC batch size: 15
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
DEBUG SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Wrap result sets: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): enabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Connection release mode: auto
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Maximum outer join fetch depth: 2
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Query cache: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Cache provider: org.hibernate.cache.NoCacheProvider
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
DEBUG SocketServerInvokerThread-127.0.0.1-0 org.hibernate.exception.SQLExceptionConverterFactory - Using dialect defined converter
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Statistics: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.tool.hbm2ddl.TableMetadata - table found: mnews.topictrack
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.tool.hbm2ddl.TableMetadata - columns: [topicid, createddate, lastupdateddate, nuserid, id]
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.tool.hbm2ddl.TableMetadata - foreign keys: [fk447bf57ca27705fa, fk447bf57cd5c87066]
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.tool.hbm2ddl.TableMetadata - indexes: [primary, fk447bf57ca27705fa, fk447bf57cd5c87066]
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.connection.C3P0ConnectionProvider - C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/mnews
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.connection.C3P0ConnectionProvider - Connection properties: {useUnicode=true, user=kenshin, password=****, characterEncoding=UTF8}
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.connection.C3P0ConnectionProvider - autocommit mode: false
INFO SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.c3p0.PoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@1562c67 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@13d7254 [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 13d7254, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, maxIdleTime -> 1800, maxPoolSize -> 5, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@198ee2f [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 198ee2f, jdbcUrl -> jdbc:mysql://localhost/mnews, properties -> {useUnicode=true, user=******, password=******, characterEncoding=UTF8} ], preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ], factoryClassLocation -> null, identityToken -> 1562c67, numHelperThreads -> 3 ]
DEBUG SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.resourcepool.BasicResourcePool - awaitAvailable(): [unknown]
DEBUG SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@140243b [managed: 0, unused: 0, excluded: 0]
DEBUG com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@1b80d9b [managed: 2, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@34d75f)
DEBUG com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@140243b [managed: 1, unused: 1, excluded: 0]
DEBUG com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@1b80d9b [managed: 3, unused: 3, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@34d75f)
DEBUG com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@140243b [managed: 2, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1a8bd74)
DEBUG SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@1a8bd74 ---> age: 16 max: 1800000 [com.mchange.v2.resourcepool.BasicResourcePool@140243b]
DEBUG SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@140243b [managed: 2, unused: 1, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1a8bd74)
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - RDBMS: MySQL, version: 5.0.20-community-log
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.4 ( $Date: 2006-10-19 17:47:48 +0200 (Thu, 19 Oct 2006) $, $Revision: 5908 $ )
DEBUG SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@140243b [managed: 2, unused: 1, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1a8bd74)
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLInnoDBDialect
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.transaction.TransactionFactoryFactory - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - JDBC batch size: 15
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
DEBUG SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Wrap result sets: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): enabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Connection release mode: auto
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Maximum outer join fetch depth: 2
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Query cache: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Cache provider: org.hibernate.cache.NoCacheProvider
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
DEBUG SocketServerInvokerThread-127.0.0.1-0 org.hibernate.exception.SQLExceptionConverterFactory - Using dialect defined converter
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Statistics: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
DEBUG com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@140243b [managed: 3, unused: 3, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1a8bd74)
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.tool.hbm2ddl.TableMetadata - table found: mnews.userdata
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.tool.hbm2ddl.TableMetadata - columns: [indexed, title, enabled, createddate, lastupdateddate, charset, sourceid, body, id]
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.tool.hbm2ddl.TableMetadata - foreign keys: [fk2063ca82b8ff84f3f0d635]
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.tool.hbm2ddl.TableMetadata - indexes: [primary, fk2063ca82b8ff84f3f0d635, body]
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.connection.C3P0ConnectionProvider - C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/mnews
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.connection.C3P0ConnectionProvider - Connection properties: {useUnicode=true, user=kenshin, password=****, characterEncoding=UTF8}
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.connection.C3P0ConnectionProvider - autocommit mode: false
INFO SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.c3p0.PoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@c3d31c [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@1b4cd65 [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1b4cd65, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, maxIdleTime -> 1800, maxPoolSize -> 5, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@5e9d7a [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 5e9d7a, jdbcUrl -> jdbc:mysql://localhost/mnews, properties -> {useUnicode=true, user=******, password=******, characterEncoding=UTF8} ], preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ], factoryClassLocation -> null, identityToken -> c3d31c, numHelperThreads -> 3 ]
DEBUG SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.resourcepool.BasicResourcePool - awaitAvailable(): [unknown]
DEBUG SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@d713fe [managed: 0, unused: 0, excluded: 0]
DEBUG com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@d713fe [managed: 1, unused: 1, excluded: 0]
DEBUG SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@1627b8b ---> age: 0 max: 1800000 [com.mchange.v2.resourcepool.BasicResourcePool@d713fe]
DEBUG SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@d713fe [managed: 1, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1627b8b)
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - RDBMS: MySQL, version: 5.0.20-community-log
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.4 ( $Date: 2006-10-19 17:47:48 +0200 (Thu, 19 Oct 2006) $, $Revision: 5908 $ )
DEBUG SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@d713fe [managed: 1, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1627b8b)
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLInnoDBDialect
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.transaction.TransactionFactoryFactory - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - JDBC batch size: 15
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
DEBUG SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Wrap result sets: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): enabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Connection release mode: auto
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Maximum outer join fetch depth: 2
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Query cache: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Cache provider: org.hibernate.cache.NoCacheProvider
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
DEBUG SocketServerInvokerThread-127.0.0.1-0 org.hibernate.exception.SQLExceptionConverterFactory - Using dialect defined converter
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Statistics: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.tool.hbm2ddl.TableMetadata - table found: mnews.vote
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.tool.hbm2ddl.TableMetadata - columns: [dataid, createddate, lastupdateddate, nuserid, choiceid, id]
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.tool.hbm2ddl.TableMetadata - foreign keys: [fk28c70aa27705fa, fk28c70a6beba110]
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.tool.hbm2ddl.TableMetadata - indexes: [fk28c70aa27705fa, primary, fk28c70a6beba110]
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.connection.C3P0ConnectionProvider - C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/mnews
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.connection.C3P0ConnectionProvider - Connection properties: {useUnicode=true, user=kenshin, password=****, characterEncoding=UTF8}
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.connection.C3P0ConnectionProvider - autocommit mode: false
INFO SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.c3p0.PoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@4d6b1a [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@106b56a [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 106b56a, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, maxIdleTime -> 1800, maxPoolSize -> 5, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@f84b0a [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> f84b0a, jdbcUrl -> jdbc:mysql://localhost/mnews, properties -> {useUnicode=true, user=******, password=******, characterEncoding=UTF8} ], preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ], factoryClassLocation -> null, identityToken -> 4d6b1a, numHelperThreads -> 3 ]
DEBUG SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.resourcepool.BasicResourcePool - awaitAvailable(): [unknown]
DEBUG SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@3e97cd [managed: 0, unused: 0, excluded: 0]
DEBUG com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@d713fe [managed: 2, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1627b8b)
DEBUG com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@3e97cd [managed: 1, unused: 1, excluded: 0]
DEBUG SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@1eb9fde ---> age: 15 max: 1800000 [com.mchange.v2.resourcepool.BasicResourcePool@3e97cd]
DEBUG SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@3e97cd [managed: 1, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1eb9fde)
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - RDBMS: MySQL, version: 5.0.20-community-log
INFO SocketServerInvokerThread-127.0.0.1-0 org.hibernate.cfg.SettingsFactory - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.4 ( $Date: 2006-10-19 17:47:48 +0200 (Thu, 19 Oct 2006) $, $Revision: 5908 $ )
DEBUG com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@d713fe [managed: 3, unused: 3, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1627b8b)
DEBUG SocketServerInvokerThread-127.0.0.1-0 com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@3e97cd [



I recently switched from hibernate 3.1.3 to 3.2.1 , everything worked fine but I had an issue with the the c3p0 pool . it kept on creating more connections that it should have. no code has been changed at all. when I put 3.1.3 jars back in the classpath and remove the 3.2.1 ones , everything is fine .... Is anyone having problems with 3.2.1 and c3p0 ?
Top
 Profile  
 
swaldman
 Post subject:
PostPosted: Wed Dec 27, 2006 12:15 am 
C3P0 Developer
C3P0 Developer

Joined: Tue Jan 06, 2004 8:58 pm
Posts: 145
Hi.

I think there is an issue with schema update in hibernate 3.2.1 and c3p0. See http://opensource.atlassian.com/projects/hibernate/browse/HHH-2032 . You may be able to work around it (by turning off schema update or by using c3p0-0.9.1's unreturnedConnectionTimeout, for example), but it may make more sense just to wait for a fix, which is apparently already implemented.

smiles,
Steve
Top
 Profile  
 
albabtain
 Post subject:
PostPosted: Wed Dec 27, 2006 2:02 am 
Newbie

Joined: Wed Jun 15, 2005 12:23 pm
Posts: 7
yeah , I will wait for the next release. I am in no hurry , and the current version is fine for now. thanks for your help
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 3 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.