Both Hibernate Style property ...

pgl · **Posted:** Fri May 11, 2007 5:03 am

Hi everyone,

for some time now I'm getting the following warnings on the console:

Code:

[11.05.2007 10:43:20] WARN   [C3P0ConnectionProvider] 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!
[11.05.2007 10:43:20] WARN   [C3P0ConnectionProvider] 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!
[11.05.2007 10:43:20] WARN   [C3P0ConnectionProvider] 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!

My configuration file:

Code:

<?xml version="1.0" encoding="ISO-8859-1" ?>
<hibernate-configuration>

  <session-factory>

    [...]

    <property name="c3p0.min_size">0</property>
    <property name="c3p0.max_size">20</property>
    <property name="c3p0.timeout">30</property>

  </session-factory>

</hibernate-configuration>

Whst's the correct way of setting the properties?

Chris

Hibernate version: 3.2.4

adamgibbons · **Joined:** Sat Apr 21, 2007 11:01 pm **Posts:** 144

Well it looks like:
both
hibernate-style property 'hibernate.c3p0.max_size'
and
c3p0-style property 'c3p0.max_size'
have been set in hibernate.properties...

Post your whole config file, because you must be specifying them in some way twice. Prehaps in another config file?

pgl · **Posted:** Fri May 11, 2007 5:42 am

adamgibbons wrote:

Well it looks like: both hibernate-style property 'hibernate.c3p0.max_size' and c3p0-style property 'c3p0.max_size' have been set in hibernate.properties...

Well yeah, that's what the error message says and what I already know.

adamgibbons wrote:

Post your whole config file, because you must be specifying them in some way twice. Prehaps in another config file?

There is only one configuration file, the one I posted already. The part I left out only contains the dialect and connection properties.

adamgibbons · **Joined:** Sat Apr 21, 2007 11:01 pm **Posts:** 144

Turn Hibernate debug on and post the whole startup log. Also you could try doing a text search in your whole project for those settings, they must in there twice somewhere.

pgl · **Posted:** Fri May 11, 2007 7:40 am

adamgibbons wrote:

Turn Hibernate debug on and post the whole startup log. Also you could try doing a text search in your whole project for those settings, they must in there twice somewhere.

I can ensure you: There is no other place in the application where the properties are being set.

As a matter of fact, I found a simple testcase that duplicates the error:

DemoClass.hbm.xml

Code:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.manning.hq.ch03">
  <class name="test.DemoClass">
    <id name="id">
      <generator class="native"/>
    </id>
  </class>
</hibernate-mapping>

DemoClass.java

Code:

package test;

public class DemoClass {

  private Integer myId        = 0;

  public Integer getId() {
    return this.myId;
  }
  public void setId(Integer id) {
    this.myId = id;
  }

}

HibernatePropertiesDemo.cfg.xml

Code:

<?xml version="1.0" encoding="ISO-8859-1" ?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>

  <session-factory>

    <property name="dialect">org.hibernate.dialect.HSQLDialect</property>
    <property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
    <property name="connection.url">jdbc:hsqldb:C:/test.hsql</property>
    <property name="connection.username">sa</property>
    <property name="connection.password"></property>

    <property name="c3p0.min_size">0</property>
    <property name="c3p0.max_size">20</property>
    <property name="c3p0.timeout">30</property>

    <mapping resource="test/DemoClass.hbm.xml"/>

  </session-factory>

</hibernate-configuration>

HibernatePropertiesDemo.java

Code:

package test;

import org.apache.log4j.BasicConfigurator;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class HibernatePropertiesDemo {

  public static void main(String[] args) {

    BasicConfigurator.configure();
    Configuration cfg           = new Configuration();
    cfg.configure(HibernatePropertiesDemo.class.getResource("HibernatePropertiesDemo.cfg.xml"));
    SessionFactory factory      = cfg.buildSessionFactory();

  }

}

The logging output is (take a look at 857):

Code:

[main] INFO org.hibernate.cfg.Environment  - Hibernate 3.2.2
[main] INFO org.hibernate.cfg.Environment  - hibernate.properties not found
[main] INFO org.hibernate.cfg.Environment  - Bytecode provider name : cglib
[main] INFO org.hibernate.cfg.Environment  - using JDK 1.4 java.sql.Timestamp handling
[main] INFO org.hibernate.cfg.Configuration  - configuring from url: file:/C:/Development/projects/sandbox/red5test/bin/test/HibernatePropertiesDemo.cfg.xml
[main] DEBUG org.hibernate.util.DTDEntityResolver  - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd]
[main] DEBUG org.hibernate.util.DTDEntityResolver  - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
[main] DEBUG org.hibernate.util.DTDEntityResolver  - located [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd] in classpath
[main] DEBUG org.hibernate.cfg.Configuration  - dialect=org.hibernate.dialect.HSQLDialect
[main] DEBUG org.hibernate.cfg.Configuration  - connection.driver_class=org.hsqldb.jdbcDriver
[main] DEBUG org.hibernate.cfg.Configuration  - connection.url=jdbc:hsqldb:C:/test.hsql
[main] DEBUG org.hibernate.cfg.Configuration  - connection.username=sa
[main] DEBUG org.hibernate.cfg.Configuration  - connection.password=
[main] DEBUG org.hibernate.cfg.Configuration  - c3p0.min_size=0
[main] DEBUG org.hibernate.cfg.Configuration  - c3p0.max_size=20
[main] DEBUG org.hibernate.cfg.Configuration  - c3p0.timeout=30
[main] DEBUG org.hibernate.cfg.Configuration  - null<-org.dom4j.tree.DefaultAttribute@c2a132 [Attribute: name resource value "test/DemoClass.hbm.xml"]
[main] INFO org.hibernate.cfg.Configuration  - Reading mappings from resource : test/DemoClass.hbm.xml
[main] DEBUG org.hibernate.util.DTDEntityResolver  - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
[main] DEBUG org.hibernate.util.DTDEntityResolver  - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
[main] DEBUG org.hibernate.util.DTDEntityResolver  - located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
[main] INFO org.hibernate.cfg.HbmBinder  - Mapping class: test.DemoClass -> DemoClass
[main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: id -> id
[main] INFO org.hibernate.cfg.Configuration  - Configured SessionFactory: null
[main] DEBUG org.hibernate.cfg.Configuration  - properties: {hibernate.connection.password=, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\Programme\Java\jdk1.5.0_09\jre\bin, java.vm.version=1.5.0_09-b03, hibernate.connection.username=sa, c3p0.min_size=0, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=DE, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Development\projects\sandbox\red5test, c3p0.max_size=20, java.runtime.version=1.5.0_09-b03, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Programme\Java\jdk1.5.0_09\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOKUME~1\C8ACC~1.ROB\LOKALE~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.jnu.encoding=Cp1252, hibernate.c3p0.timeout=30, java.library.path=C:\Programme\Java\jdk1.5.0_09\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Programme\Java\jre1.6.0\bin\client;C:\Programme\Java\jre1.6.0\bin;c:\programme\imagemagick-6.2.7-q16;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Programme\Intel\DMIX;C:\Programme\ATI Technologies\ATI Control Panel;C:\Programme\Microsoft SQL Server\80\Tools\Binn\;C:\Programme\Gemeinsame Dateien\Sonic Shared;C:\Programme\GNU\cvsnt;C:\Programme\Bitvise Tunnelier;C:\Programme\ATI Technologies\ATI.ACE\;C:\Programme\QuickTime\QTSystem\;C:\Programme\Gemeinsame Dateien\GTK\2.0\bin;C:\Programme\ESTsoft\ALZip\;C:\Programme\ZipGenius 6\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Programme\UltraEdit;C:\Development\applications\apache-ant\bin;C:\Programme\svn-win32\bin;C:\Programme\MinGW\bin;C:\Development\applications\ffmpeg\bin;C:\Development\applications\flvtool2\bin;C:\Programme\ESTsoft\ALZip\, java.specification.name=Java Platform API Specification, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, os.version=5.1, connection.password=, user.home=C:\Dokumente und Einstellungen\xxx, user.timezone=, connection.username=sa, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.5, hibernate.c3p0.min_size=0, hibernate.connection.driver_class=org.hsqldb.jdbcDriver, user.name=xxx, java.class.path=C:\Development\projects\sandbox\red5test\bin;C:\Development\projects\sandbox\red5test\classes_red5;C:\Development\projects\yumaHead\util\bin;C:\Development\projects\yumaHead\util\lib\apache\axis\axis.jar;C:\Development\projects\yumaHead\util\lib\apache\axis\jaxrpc.jar;C:\Development\projects\yumaHead\util\lib\apache\axis\saaj.jar;C:\Development\projects\yumaHead\util\lib\apache\axis\wsdl4j-1.5.1.jar;C:\Development\projects\yumaHead\util\lib\apache\commons\commons-codec-1.3.jar;C:\Development\projects\yumaHead\util\lib\apache\commons\commons-collections-3.2.jar;C:\Development\projects\yumaHead\util\lib\apache\commons\commons-discovery-0.2.jar;C:\Development\projects\yumaHead\util\lib\apache\commons\commons-fileupload-1.1.1.jar;C:\Development\projects\yumaHead\util\lib\apache\commons\commons-httpclient-3.0.1.jar;C:\Development\projects\yumaHead\util\lib\apache\commons\commons-lang-2.2.jar;C:\Development\projects\yumaHead\util\lib\apache\commons\commons-logging-1.1.jar;C:\Development\projects\yumaHead\util\lib\apache\commons\commons-net-1.4.1.jar;C:\Development\projects\yumaHead\util\lib\apache\jakarta-oro-2.0.8.jar;C:\Development\projects\yumaHead\util\lib\apache\log4j-1.2.14.jar;C:\Development\projects\yumaHead\util\lib\apache\poi-2.5.1-final-20040804.jar;C:\Development\projects\yumaHead\util\lib\apache\velocity-1.4.jar;C:\Development\projects\yumaHead\util\lib\hibernate\antlr-2.7.6.jar;C:\Development\projects\yumaHead\util\lib\hibernate\asm.jar;C:\Development\projects\yumaHead\util\lib\hibernate\asm-attrs.jar;C:\Development\projects\yumaHead\util\lib\hibernate\cglib-2.1.3.jar;C:\Development\projects\yumaHead\util\lib\hibernate\ejb3-persistence.jar;C:\Development\projects\yumaHead\util\lib\hibernate\hibernate3.jar;C:\Development\projects\yumaHead\util\lib\hibernate\hibernate-annotations.jar;C:\Development\projects\yumaHead\util\lib\hibernate\jdbc2_0-stdext.jar;C:\Development\projects\yumaHead\util\lib\hibernate\jta.jar;C:\Development\projects\yumaHead\util\lib\jdbc\hsqldb.jar;C:\Development\projects\yumaHead\util\lib\jdbc\mysql-connector-java-5.0.4-bin.jar;C:\Development\projects\yumaHead\util\lib\xml\dom4j-1.6.1.jar;C:\Development\projects\yumaHead\util\lib\xml\xercesImpl.jar;C:\Development\projects\yumaHead\util\lib\activation.jar;C:\Development\projects\yumaHead\util\lib\httpunit.jar;C:\Development\projects\yumaHead\util\lib\junit-4.1.jar;C:\Development\projects\yumaHead\util\lib\mail.jar;C:\Development\projects\yumaHead\util\lib\Tidy.jar;C:\Development\projects\yumaHead\util\lib\htmlunit\htmlunit-1.10.jar;C:\Development\projects\yumaHead\util\lib\apache\commons\commons-vfs-1.0.jar;C:\Development\projects\yumaHead\util\lib\hibernate\ehcache-1.2.4.jar;C:\Development\projects\yumaHead\util\lib\jcommon-1.0.8.jar;C:\Development\projects\yumaHead\util\lib\jfreechart-1.0.3.jar;C:\Development\projects\yumaHead\util\lib\htmlunit\jdom.jar;C:\Development\projects\yumaHead\util\lib\htmlunit\jaxen-1.1-beta-11.jar;C:\Development\projects\yumaHead\util\lib\htmlunit\xmlParserAPIs-2.6.2.jar;C:\Development\projects\yumaHead\util\lib\pdfreport\avalon-framework-4.2.0.jar;C:\Development\projects\yumaHead\util\lib\pdfreport\batik.jar;C:\Development\projects\yumaHead\util\lib\pdfreport\fop.jar;C:\Development\projects\yumaHead\util\lib\pdfreport\fop-hyph.jar;C:\Development\projects\yumaHead\util\lib\pdfreport\xmlgraphics-commons-1.1-snapshot.jar;C:\Development\projects\yumaHead\util\lib\js.jar;C:\Development\projects\yumaHead\util\lib\nekohtml.jar;C:\Development\projects\yumaHead\util\lib\hibernate\c3p0-0.9.1.jar;C:\Development\projects\yumaHead\util\lib\apache\commons\commons-io-1.3.jar;C:\Development\projects\yumaHead\util\lib\jsch-0.1.31.jar, hibernate.bytecode.use_reflection_optimizer=false, java.vm.specification.version=1.0, java.home=C:\Programme\Java\jdk1.5.0_09\jre, sun.arch.data.model=32, hibernate.connection.url=jdbc:hsqldb:C:/test.hsql, hibernate.dialect=org.hibernate.dialect.HSQLDialect, user.language=de, java.specification.vendor=Sun Microsystems Inc., hibernate.c3p0.max_size=20, awt.toolkit=sun.awt.windows.WToolkit, c3p0.timeout=30, java.vm.info=mixed mode, sharing, java.version=1.5.0_09, java.ext.dirs=C:\Programme\Java\jdk1.5.0_09\jre\lib\ext, sun.boot.class.path=C:\Programme\Java\jdk1.5.0_09\jre\lib\rt.jar;C:\Programme\Java\jdk1.5.0_09\jre\lib\i18n.jar;C:\Programme\Java\jdk1.5.0_09\jre\lib\sunrsasign.jar;C:\Programme\Java\jdk1.5.0_09\jre\lib\jsse.jar;C:\Programme\Java\jdk1.5.0_09\jre\lib\jce.jar;C:\Programme\Java\jdk1.5.0_09\jre\lib\charsets.jar;C:\Programme\Java\jdk1.5.0_09\jre\classes, java.vendor=Sun Microsystems Inc., connection.driver_class=org.hsqldb.jdbcDriver, file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.desktop=windows, connection.url=jdbc:hsqldb:C:/test.hsql, dialect=org.hibernate.dialect.HSQLDialect, sun.cpu.isalist=}
[main] DEBUG org.hibernate.cfg.Configuration  - Preparing to build session factory with filters : {}
[main] DEBUG org.hibernate.cfg.Configuration  - processing extends queue
[main] DEBUG org.hibernate.cfg.Configuration  - processing collection mappings
[main] DEBUG org.hibernate.cfg.Configuration  - processing native query and ResultSetMapping mappings
[main] DEBUG org.hibernate.cfg.Configuration  - processing association property references
[main] DEBUG org.hibernate.cfg.Configuration  - processing foreign key constraints
[main] INFO org.hibernate.connection.C3P0ConnectionProvider  - C3P0 using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:C:/test.hsql
[main] INFO org.hibernate.connection.C3P0ConnectionProvider  - Connection properties: {user=sa, password=****}
[main] INFO org.hibernate.connection.C3P0ConnectionProvider  - autocommit mode: false
[main] WARN org.hibernate.connection.C3P0ConnectionProvider  - 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!
[main] WARN org.hibernate.connection.C3P0ConnectionProvider  - 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!
[main] WARN org.hibernate.connection.C3P0ConnectionProvider  - 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!
[main] INFO com.mchange.v2.log.MLog  - MLog clients using log4j logging.
[main] INFO com.mchange.v2.c3p0.C3P0Registry  - Initializing c3p0-0.9.1 [built 16-January-2007 14:46:42; debug? true; trace: 10]
[main] DEBUG com.mchange.v2.c3p0.management.DynamicPooledDataSourceManagerMBean  - MBean: com.mchange.v2.c3p0:type=PooledDataSource[1b606bm7my3vsvp1lblvbv|e91f5d] registered.
[main] DEBUG com.mchange.v2.c3p0.management.DynamicPooledDataSourceManagerMBean  - MBean: com.mchange.v2.c3p0:type=PooledDataSource[1b606bm7my3vsvp1lblvbv|e91f5d] unregistered, in order to be reregistered after update.
[main] DEBUG com.mchange.v2.c3p0.management.DynamicPooledDataSourceManagerMBean  - MBean: com.mchange.v2.c3p0:type=PooledDataSource[1b606bm7my3vsvp1lblvbv|e91f5d] registered.
[main] INFO com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource  - Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@82b56ed3 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@94f0a7b9 [ acquireIncrement -> 3, 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 -> 1b606bm7my3vsvp1lblvbv|16fe0f4, idleConnectionTestPeriod -> 0, initialPoolSize -> 0, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 30, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 20, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 0, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@48510210 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 1b606bm7my3vsvp1lblvbv|1ccce3c, jdbcUrl -> jdbc:hsqldb:C:/test.hsql, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 1b606bm7my3vsvp1lblvbv|e91f5d, numHelperThreads -> 3 ]
[main] DEBUG com.mchange.v2.resourcepool.BasicResourcePool  - com.mchange.v2.resourcepool.BasicResourcePool@cd5f8b config: [start -> 0; min -> 0; max -> 20; inc -> 3; num_acq_attempts -> 30; acq_attempt_delay -> 1000; check_idle_resources_delay -> 0; mox_resource_age -> 0; max_idle_time -> 30000; excess_max_idle_time -> 0; destroy_unreturned_resc_time -> 0; expiration_enforcement_delay -> 7500; break_on_acquisition_failure -> false; debug_store_checkout_exceptions -> false]
[main] DEBUG com.mchange.v2.resourcepool.BasicResourcePool  - acquire test -- pool size: 0; target_pool_size: 0; desired target? 1
[main] DEBUG com.mchange.v2.resourcepool.BasicResourcePool  - incremented pending_acquires: 1
[main] DEBUG com.mchange.v2.resourcepool.BasicResourcePool  - incremented pending_acquires: 2
[main] DEBUG com.mchange.v2.resourcepool.BasicResourcePool  - incremented pending_acquires: 3
[main] DEBUG com.mchange.v2.resourcepool.BasicResourcePool  - awaitAvailable(): [unknown]
[main] DEBUG com.mchange.v2.resourcepool.BasicResourcePool  - trace com.mchange.v2.resourcepool.BasicResourcePool@cd5f8b [managed: 0, unused: 0, excluded: 0]
[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool  - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@1484a05.acquireResource() returning. 
[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool  - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@1484a05.acquireResource() returning. 
[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool  - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@1484a05.acquireResource() returning. 
[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool  - trace com.mchange.v2.resourcepool.BasicResourcePool@cd5f8b [managed: 1, unused: 1, excluded: 0]
[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] DEBUG com.mchange.v2.resourcepool.BasicResourcePool  - trace com.mchange.v2.resourcepool.BasicResourcePool@cd5f8b [managed: 2, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1542a75)
[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] DEBUG com.mchange.v2.resourcepool.BasicResourcePool  - trace com.mchange.v2.resourcepool.BasicResourcePool@cd5f8b [managed: 3, unused: 3, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1542a75)
[main] DEBUG com.mchange.v2.resourcepool.BasicResourcePool  - trace com.mchange.v2.resourcepool.BasicResourcePool@cd5f8b [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1542a75)
[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool  - decremented pending_acquires: 2
[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] DEBUG com.mchange.v2.resourcepool.BasicResourcePool  - decremented pending_acquires: 1
[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] DEBUG com.mchange.v2.resourcepool.BasicResourcePool  - decremented pending_acquires: 0
[main] INFO org.hibernate.cfg.SettingsFactory  - RDBMS: HSQL Database Engine, version: 1.8.0
[main] INFO org.hibernate.cfg.SettingsFactory  - JDBC driver: HSQL Database Engine Driver, version: 1.8.0
[main] DEBUG com.mchange.v2.resourcepool.BasicResourcePool  - trace com.mchange.v2.resourcepool.BasicResourcePool@cd5f8b [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1542a75)
[main] INFO org.hibernate.dialect.Dialect  - Using dialect: org.hibernate.dialect.HSQLDialect
[main] INFO org.hibernate.transaction.TransactionFactoryFactory  - Using default transaction strategy (direct JDBC transactions)
[main] INFO org.hibernate.transaction.TransactionManagerLookupFactory  - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
[main] INFO org.hibernate.cfg.SettingsFactory  - Automatic flush during beforeCompletion(): disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Automatic session close at end of transaction: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - JDBC batch size: 15
[main] INFO org.hibernate.cfg.SettingsFactory  - JDBC batch updates for versioned data: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Scrollable result sets: enabled
[main] DEBUG org.hibernate.cfg.SettingsFactory  - Wrap result sets: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - JDBC3 getGeneratedKeys(): disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Connection release mode: auto
[main] INFO org.hibernate.cfg.SettingsFactory  - Default batch fetch size: 1
[main] INFO org.hibernate.cfg.SettingsFactory  - Generate SQL with comments: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Order SQL updates by primary key: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
[main] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory  - Using ASTQueryTranslatorFactory
[main] INFO org.hibernate.cfg.SettingsFactory  - Query language substitutions: {}
[main] INFO org.hibernate.cfg.SettingsFactory  - JPA-QL strict compliance: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Second-level cache: enabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Query cache: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Cache provider: org.hibernate.cache.NoCacheProvider
[main] INFO org.hibernate.cfg.SettingsFactory  - Optimize cache for minimal puts: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Structured second-level cache entries: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Statistics: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Deleted entity synthetic identifier rollback: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Default entity-mode: pojo
[main] INFO org.hibernate.cfg.SettingsFactory  - Named query checking : enabled
[main] INFO org.hibernate.impl.SessionFactoryImpl  - building session factory
[main] DEBUG org.hibernate.impl.SessionFactoryImpl  - Session factory constructed with filter configurations : {}
[main] DEBUG org.hibernate.impl.SessionFactoryImpl  - instantiating session factory with properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, hibernate.connection.password=, sun.boot.library.path=C:\Programme\Java\jdk1.5.0_09\jre\bin, java.vm.version=1.5.0_09-b03, hibernate.connection.username=sa, c3p0.min_size=0, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=DE, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Development\projects\sandbox\red5test, c3p0.max_size=20, java.runtime.version=1.5.0_09-b03, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Programme\Java\jdk1.5.0_09\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOKUME~1\C8ACC~1.ROB\LOKALE~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.jnu.encoding=Cp1252, hibernate.c3p0.timeout=30, java.library.path=C:\Programme\Java\jdk1.5.0_09\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Programme\Java\jre1.6.0\bin\client;C:\Programme\Java\jre1.6.0\bin;c:\programme\imagemagick-6.2.7-q16;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Programme\Intel\DMIX;C:\Programme\ATI Technologies\ATI Control Panel;C:\Programme\Microsoft SQL Server\80\Tools\Binn\;C:\Programme\Gemeinsame Dateien\Sonic Shared;C:\Programme\GNU\cvsnt;C:\Programme\Bitvise Tunnelier;C:\Programme\ATI Technologies\ATI.ACE\;C:\Programme\QuickTime\QTSystem\;C:\Programme\Gemeinsame Dateien\GTK\2.0\bin;C:\Programme\ESTsoft\ALZip\;C:\Programme\ZipGenius 6\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Programme\UltraEdit;C:\Development\applications\apache-ant\bin;C:\Programme\svn-win32\bin;C:\Programme\MinGW\bin;C:\Development\applications\ffmpeg\bin;C:\Development\applications\flvtool2\bin;C:\Programme\ESTsoft\ALZip\, java.specification.name=Java Platform API Specification, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, os.version=5.1, user.home=C:\Dokumente und Einstellungen\xxx, connection.password=, user.timezone=, java.awt.printerjob=sun.awt.windows.WPrinterJob, connection.username=sa, java.specification.version=1.5, file.encoding=Cp1252, hibernate.c3p0.min_size=0, hibernate.connection.driver_class=org.hsqldb.jdbcDriver, java.class.path=C:\Development\projects\sandbox\red5test\bin;C:\Development\projects\sandbox\red5test\classes_red5;C:\Development\projects\yumaHead\util\bin;C:\Development\projects\yumaHead\util\lib\apache\axis\axis.jar;C:\Development\projects\yumaHead\util\lib\apache\axis\jaxrpc.jar;C:\Development\projects\yumaHead\util\lib\apache\axis\saaj.jar;C:\Development\projects\yumaHead\util\lib\apache\axis\wsdl4j-1.5.1.jar;C:\Development\projects\yumaHead\util\lib\apache\commons\commons-codec-1.3.jar;C:\Development\projects\yumaHead\util\lib\apache\commons\commons-collections-3.2.jar;C:\Development\projects\yumaHead\util\lib\apache\commons\commons-discovery-0.2.jar;C:\Development\projects\yumaHead\util\lib\apache\commons\commons-fileupload-1.1.1.jar;C:\Development\projects\yumaHead\util\lib\apache\commons\commons-httpclient-3.0.1.jar;C:\Development\projects\yumaHead\util\lib\apache\commons\commons-lang-2.2.jar;C:\Development\projects\yumaHead\util\lib\apache\commons\commons-logging-1.1.jar;C:\Development\projects\yumaHead\util\lib\apache\commons\commons-net-1.4.1.jar;C:\Development\projects\yumaHead\util\lib\apache\jakarta-oro-2.0.8.jar;C:\Development\projects\yumaHead\util\lib\apache\log4j-1.2.14.jar;C:\Development\projects\yumaHead\util\lib\apache\poi-2.5.1-final-20040804.jar;C:\Development\projects\yumaHead\util\lib\apache\velocity-1.4.jar;C:\Development\projects\yumaHead\util\lib\hibernate\antlr-2.7.6.jar;C:\Development\projects\yumaHead\util\lib\hibernate\asm.jar;C:\Development\projects\yumaHead\util\lib\hibernate\asm-attrs.jar;C:\Development\projects\yumaHead\util\lib\hibernate\cglib-2.1.3.jar;C:\Development\projects\yumaHead\util\lib\hibernate\ejb3-persistence.jar;C:\Development\projects\yumaHead\util\lib\hibernate\hibernate3.jar;C:\Development\projects\yumaHead\util\lib\hibernate\hibernate-annotations.jar;C:\Development\projects\yumaHead\util\lib\hibernate\jdbc2_0-stdext.jar;C:\Development\projects\yumaHead\util\lib\hibernate\jta.jar;C:\Development\projects\yumaHead\util\lib\jdbc\hsqldb.jar;C:\Development\projects\yumaHead\util\lib\jdbc\mysql-connector-java-5.0.4-bin.jar;C:\Development\projects\yumaHead\util\lib\xml\dom4j-1.6.1.jar;C:\Development\projects\yumaHead\util\lib\xml\xercesImpl.jar;C:\Development\projects\yumaHead\util\lib\activation.jar;C:\Development\projects\yumaHead\util\lib\httpunit.jar;C:\Development\projects\yumaHead\util\lib\junit-4.1.jar;C:\Development\projects\yumaHead\util\lib\mail.jar;C:\Development\projects\yumaHead\util\lib\Tidy.jar;C:\Development\projects\yumaHead\util\lib\htmlunit\htmlunit-1.10.jar;C:\Development\projects\yumaHead\util\lib\apache\commons\commons-vfs-1.0.jar;C:\Development\projects\yumaHead\util\lib\hibernate\ehcache-1.2.4.jar;C:\Development\projects\yumaHead\util\lib\jcommon-1.0.8.jar;C:\Development\projects\yumaHead\util\lib\jfreechart-1.0.3.jar;C:\Development\projects\yumaHead\util\lib\htmlunit\jdom.jar;C:\Development\projects\yumaHead\util\lib\htmlunit\jaxen-1.1-beta-11.jar;C:\Development\projects\yumaHead\util\lib\htmlunit\xmlParserAPIs-2.6.2.jar;C:\Development\projects\yumaHead\util\lib\pdfreport\avalon-framework-4.2.0.jar;C:\Development\projects\yumaHead\util\lib\pdfreport\batik.jar;C:\Development\projects\yumaHead\util\lib\pdfreport\fop.jar;C:\Development\projects\yumaHead\util\lib\pdfreport\fop-hyph.jar;C:\Development\projects\yumaHead\util\lib\pdfreport\xmlgraphics-commons-1.1-snapshot.jar;C:\Development\projects\yumaHead\util\lib\js.jar;C:\Development\projects\yumaHead\util\lib\nekohtml.jar;C:\Development\projects\yumaHead\util\lib\hibernate\c3p0-0.9.1.jar;C:\Development\projects\yumaHead\util\lib\apache\commons\commons-io-1.3.jar;C:\Development\projects\yumaHead\util\lib\jsch-0.1.31.jar, user.name=xxx, hibernate.bytecode.use_reflection_optimizer=false, java.vm.specification.version=1.0, sun.arch.data.model=32, java.home=C:\Programme\Java\jdk1.5.0_09\jre, hibernate.dialect=org.hibernate.dialect.HSQLDialect, hibernate.connection.url=jdbc:hsqldb:C:/test.hsql, java.specification.vendor=Sun Microsystems Inc., user.language=de, awt.toolkit=sun.awt.windows.WToolkit, hibernate.c3p0.max_size=20, java.vm.info=mixed mode, sharing, c3p0.timeout=30, java.version=1.5.0_09, java.ext.dirs=C:\Programme\Java\jdk1.5.0_09\jre\lib\ext, sun.boot.class.path=C:\Programme\Java\jdk1.5.0_09\jre\lib\rt.jar;C:\Programme\Java\jdk1.5.0_09\jre\lib\i18n.jar;C:\Programme\Java\jdk1.5.0_09\jre\lib\sunrsasign.jar;C:\Programme\Java\jdk1.5.0_09\jre\lib\jsse.jar;C:\Programme\Java\jdk1.5.0_09\jre\lib\jce.jar;C:\Programme\Java\jdk1.5.0_09\jre\lib\charsets.jar;C:\Programme\Java\jdk1.5.0_09\jre\classes, java.vendor=Sun Microsystems Inc., file.separator=\, connection.driver_class=org.hsqldb.jdbcDriver, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.cpu.endian=little, sun.io.unicode.encoding=UnicodeLittle, sun.desktop=windows, connection.url=jdbc:hsqldb:C:/test.hsql, sun.cpu.isalist=, dialect=org.hibernate.dialect.HSQLDialect}
[main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  - Static SQL for entity: test.DemoClass
[main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  -  Version select: select id from DemoClass where id =?
[main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  -  Snapshot select: select democlass_.id from DemoClass democlass_ where democlass_.id=?
[main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  -  Insert 0: insert into DemoClass (id) values (?)
[main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  -  Update 0: null
[main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  -  Delete 0: delete from DemoClass where id=?
[main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  -  Identity insert: insert into DemoClass (id) values (null)
[main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity test.DemoClass: select democlass0_.id as id0_0_ from DemoClass democlass0_ where democlass0_.id=?
[main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity test.DemoClass: select democlass0_.id as id0_0_ from DemoClass democlass0_ where democlass0_.id=?
[main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity test.DemoClass: select democlass0_.id as id0_0_ from DemoClass democlass0_ where democlass0_.id=?
[main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity test.DemoClass: select democlass0_.id as id0_0_ from DemoClass democlass0_ where democlass0_.id=?
[main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity test.DemoClass: select democlass0_.id as id0_0_ from DemoClass democlass0_ where democlass0_.id=?
[main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for action ACTION_MERGE on entity test.DemoClass: select democlass0_.id as id0_0_ from DemoClass democlass0_ where democlass0_.id=?
[main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for action ACTION_REFRESH on entity test.DemoClass: select democlass0_.id as id0_0_ from DemoClass democlass0_ where democlass0_.id=?
[main] DEBUG org.hibernate.impl.SessionFactoryObjectFactory  - initializing class SessionFactoryObjectFactory
[main] DEBUG org.hibernate.impl.SessionFactoryObjectFactory  - registered: 297e8282127aed5201127aed54510000 (unnamed)
[main] INFO org.hibernate.impl.SessionFactoryObjectFactory  - Not binding factory to JNDI, no JNDI name configured
[main] DEBUG org.hibernate.impl.SessionFactoryImpl  - instantiated session factory
[main] DEBUG org.hibernate.impl.SessionFactoryImpl  - Checking 0 named HQL queries
[main] DEBUG org.hibernate.impl.SessionFactoryImpl  - Checking 0 named SQL queries

yeecn · **Joined:** Wed Oct 05, 2005 12:29 pm **Posts:** 22

I am getting the same warnings as well. I managed to get rid of the warnings by prefixing the property names wih 'hibernate.', like thus:

<property name="hibernate.c3p0.min_size">2</property>
<property name="hibernate.c3p0.max_size">20</property>
<property name="hibernate.c3p0.timeout">1800</property>
...

can someone confirm that this is the right way to do it?

regards.
yee

biermeester · **Joined:** Wed Jul 11, 2007 5:03 pm **Posts:** 1

Yes, that's correct. I was after the same warning message when I found this link: http://www.mchange.com/projects/c3p0/in ... e-specific