Hi

I'm using Hibernate with c3p0 (0.8.5pre9) in a fat client. At startup, when the database connection is not available (DB down, wrong URL etc), I would like the application to fail rather quick. However, from looking at the complete stacktrace, it seems there are several attempts at initializing the connection pool.

It looks to me as if net.sf.hibernate.cfg.Configuration.buildSessionFactory() or something deeper inside this method somehow hides SQLExceptions when they occur and does not propagate them. Could someone confirm this behaviour, or mention a way to tell hibernate to propagate an exception from inside this method immediately?

Note that I've already used "c3p0.acquireRetryAttempts=5", which reduces the pain a bit (since the default is 30 attempts), but it still takes too long to report the error. As can be seen from the stacktrace below (rather long, sorry), the following message appears several times, called from different areas of my code (I'm not hiding any hibernate exceptions): " Acquisition Attempt Failed!!! Clearing pending aquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (5)."

thanks in advance for any help
Peter


Hibernate version: 2.1.6

Full stack trace of any exception that occurs: (snippet)

...
[java] INFO: Mapping collection: ch.unizh.oas.hibernate.Area.chronoAreaLink
s -> chrono_area_link
[java] 01.02.2005 13:40:11 net.sf.hibernate.cfg.Configuration secondPassCom
pile
[java] INFO: processing one-to-one association property references
[java] 01.02.2005 13:40:11 net.sf.hibernate.cfg.Configuration secondPassCom
pile
[java] INFO: processing foreign key constraints
[java] 01.02.2005 13:40:11 net.sf.hibernate.dialect.Dialect <init>
[java] INFO: Using dialect: net.sf.hibernate.dialect.MySQLDialect
[java] 01.02.2005 13:40:11 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: Maximim outer join fetch depth: 1
[java] 01.02.2005 13:40:11 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: Use outer join fetching: true
[java] 01.02.2005 13:40:11 net.sf.hibernate.connection.ConnectionProviderFa
ctory newConnectionProvider
[java] INFO: Initializing connection provider: net.sf.hibernate.connection.
C3P0ConnectionProvider
[java] 01.02.2005 13:40:11 net.sf.hibernate.connection.C3P0ConnectionProvid
er configure
[java] INFO: C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://
localhost/oasuni2?useUnicode=true&characterEncoding=UTF-8
[java] 01.02.2005 13:40:11 net.sf.hibernate.connection.C3P0ConnectionProvid
er configure
[java] INFO: Connection properties: {user=oas2, password=oas2}
[java] 01.02.2005 13:40:11 net.sf.hibernate.transaction.TransactionManagerL
ookupFactory getTransactionManagerLookup
[java] INFO: No TransactionManagerLookup configured (in JTA environment, us
e of process level read-write cache is not recommended)
[java] Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@1
db5ec [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDat
aSource@b1a4e2 [ acquireIncrement -> 2, acquireRetryAttempts -> 5, acquireRetryD
elay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfter
AcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.
mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forc
eIgnoreUnresolvedTransactions -> false, idleConnectionTestPeriod -> 3000, initia
lPoolSize -> 2, maxIdleTime -> 5000, maxPoolSize -> 2, maxStatements -> 100, max
StatementsPerConnection -> 0, minPoolSize -> 2, nestedDataSource -> com.mchange.
v2.c3p0.DriverManagerDataSource@1be2893 [ description -> null, driverClass -> nu
ll, factoryClassLocation -> null, jdbcUrl -> jdbc:mysql://localhost/oasuni2?useU
nicode=true&characterEncoding=UTF-8, properties -> {user=******, password=******
} ] , preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin
-> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies ->
false ] , factoryClassLocation -> null, numHelperThreads -> 3, poolOwnerIdentit
yToken -> 1db5ec ]
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@8c5ea2 --
Acquisition Attempt Failed!!! Clearing pending acquires.
[java] While trying to acquire a needed new resource, we failed
[java] to succeed more than the maximum number of allowed
[java] acquisition attempts (5).
[java] 01.02.2005 13:40:25 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] WARNUNG: Could not obtain connection metadata
[java] java.sql.SQLException: An SQLException was provoked by the following
failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool coul
d not acquire a resource from its primary factory or source.
[java] at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:68)
[java] at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:57)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPoo
ledConnection(C3P0PooledConnectionPool.java:213)
[java] at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBa
ckedDataSource.java:64)
[java] at net.sf.hibernate.connection.C3P0ConnectionProvider.getConnect
ion(C3P0ConnectionProvider.java:33)
[java] at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFa
ctory.java:73)
[java] at net.sf.hibernate.cfg.Configuration.buildSettings(Configuratio
n.java:1155)
[java] at ch.unizh.oas.hibernate.helper.HibernatePersistencyHelper$MyCo
nfiguration.buildSettings(HibernatePersistencyHelper.java:404)
[java] at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Config
uration.java:789)
[java] at ch.unizh.oas.hibernate.helper.HibernatePersistencyHelper.init
(HibernatePersistencyHelper.java:89)
[java] at ch.unizh.oas.service.ServiceLocator.init(ServiceLocator.java:
67)
[java] at ch.unizh.oas.service.MainModel.initServices(MainModel.java:94
)
[java] at ch.unizh.oas.gui.general.MainFrame.main(MainFrame.java:184)
[java] Caused by: com.mchange.v2.resourcepool.ResourcePoolException: A Reso
urcePool could not acquire a resource from its primary factory or source.
[java] at com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(Ba
sicResourcePool.java:872)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResourc
e(BasicResourcePool.java:203)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPoo
ledConnection(C3P0PooledConnectionPool.java:209)
[java] ... 10 more
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@14b6bed --
Acquisition Attempt Failed!!! Clearing pending acquires.
[java] 01.02.2005 13:40:25 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: Use scrollable result sets: false
[java] While trying to acquire a needed new resource, we failed
[java] to succeed more than the maximum number of allowed
[java] 01.02.2005 13:40:25 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: Use JDBC3 getGeneratedKeys(): false
[java] 01.02.2005 13:40:25 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: Optimize cache for minimal puts: false
[java] acquisition attempts (5).
[java] 01.02.2005 13:40:25 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: Query language substitutions: {no='N', true=1, yes='Y', false=
0}
[java] 01.02.2005 13:40:25 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: cache provider: net.sf.hibernate.cache.EhCacheProvider
[java] 01.02.2005 13:40:25 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: query cache factory: net.sf.hibernate.cache.StandardQueryCache
Factory
[java] 01.02.2005 13:40:25 net.sf.hibernate.cfg.Configuration configureCach
es
[java] INFO: instantiating and configuring caches
[java] 01.02.2005 13:40:25 net.sf.hibernate.impl.SessionFactoryImpl <init>
[java] INFO: building session factory
[java] 01.02.2005 13:40:27 net.sf.hibernate.impl.SessionFactoryObjectFactor
y addInstance
[java] INFO: Not binding factory to JNDI, no JNDI name configured
[java] 01.02.2005 13:40:27 net.sf.hibernate.cache.UpdateTimestampsCache <in
it>
[java] INFO: starting update timestamps cache at region: net.sf.hibernate.c
ache.UpdateTimestampsCache
[java] 01.02.2005 13:40:27 net.sf.hibernate.cache.EhCache <init>
[java] WARNUNG: Could not find configuration for net.sf.hibernate.cache.Upd
ateTimestampsCache. Configuring using the defaultCache settings.
[java] 01.02.2005 13:40:27 net.sf.hibernate.cache.StandardQueryCache <init>

[java] INFO: starting query cache at region: net.sf.hibernate.cache.Standar
dQueryCache
[java] 01.02.2005 13:40:27 net.sf.hibernate.cache.EhCache <init>
[java] WARNUNG: Could not find configuration for net.sf.hibernate.cache.Sta
ndardQueryCache. Configuring using the defaultCache settings.
[java] 01.02.2005 13:40:27 net.sf.hibernate.cfg.Configuration secondPassCom
pile
[java] INFO: processing one-to-many association mappings
[java] 01.02.2005 13:40:27 net.sf.hibernate.cfg.Configuration secondPassCom
pile
[java] INFO: processing one-to-one association property references
[java] 01.02.2005 13:40:27 net.sf.hibernate.cfg.Configuration secondPassCom
pile
[java] INFO: processing foreign key constraints
[java] 01.02.2005 13:40:27 net.sf.hibernate.dialect.Dialect <init>
[java] INFO: Using dialect: net.sf.hibernate.dialect.MySQLDialect
[java] 01.02.2005 13:40:27 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: Maximim outer join fetch depth: 1
[java] 01.02.2005 13:40:27 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: Use outer join fetching: true
[java] 01.02.2005 13:40:27 net.sf.hibernate.connection.ConnectionProviderFa
ctory newConnectionProvider
[java] INFO: Initializing connection provider: net.sf.hibernate.connection.
C3P0ConnectionProvider
[java] 01.02.2005 13:40:27 net.sf.hibernate.connection.C3P0ConnectionProvid
er configure
[java] INFO: C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://
localhost/oasuni2?useUnicode=true&characterEncoding=UTF-8
[java] 01.02.2005 13:40:27 net.sf.hibernate.connection.C3P0ConnectionProvid
er configure
[java] INFO: Connection properties: {user=oas2, password=oas2}
[java] 01.02.2005 13:40:28 net.sf.hibernate.transaction.TransactionManagerL
ookupFactory getTransactionManagerLookup
[java] INFO: No TransactionManagerLookup configured (in JTA environment, us
e of process level read-write cache is not recommended)
[java] Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@1
9050a0 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDa
taSource@140fee [ acquireIncrement -> 2, acquireRetryAttempts -> 5, acquireRetry
Delay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfte
rAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com
.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, for
ceIgnoreUnresolvedTransactions -> false, idleConnectionTestPeriod -> 3000, initi
alPoolSize -> 2, maxIdleTime -> 5000, maxPoolSize -> 2, maxStatements -> 100, ma
xStatementsPerConnection -> 0, minPoolSize -> 2, nestedDataSource -> com.mchange
.v2.c3p0.DriverManagerDataSource@1dfc8a0 [ description -> null, driverClass -> n
ull, factoryClassLocation -> null, jdbcUrl -> jdbc:mysql://localhost/oasuni2?use
Unicode=true&characterEncoding=UTF-8, properties -> {user=******, password=*****
*} ] , preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin
-> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -
> false ] , factoryClassLocation -> null, numHelperThreads -> 3, poolOwnerIdenti
tyToken -> 19050a0 ]
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@156e5ed --
Acquisition Attempt Failed!!! Clearing pending acquires.
[java] While trying to acquire a needed new resource, we failed
[java] to succeed more than the maximum number of allowed
[java] acquisition attempts (5).
[java] 01.02.2005 13:40:41 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] WARNUNG: Could not obtain connection metadata
[java] java.sql.SQLException: An SQLException was provoked by the following
failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool coul
d not acquire a resource from its primary factory or source.
[java] at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:68)
[java] at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:57)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPoo
ledConnection(C3P0PooledConnectionPool.java:213)
[java] at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBa
ckedDataSource.java:64)
[java] at net.sf.hibernate.connection.C3P0ConnectionProvider.getConnect
ion(C3P0ConnectionProvider.java:33)
[java] at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFa
ctory.java:73)
[java] at net.sf.hibernate.cfg.Configuration.buildSettings(Configuratio
n.java:1155)
[java] at ch.unizh.oas.hibernate.helper.HibernatePersistencyHelper$MyCo
nfiguration.buildSettings(HibernatePersistencyHelper.java:404)
[java] at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Config
uration.java:789)
[java] at ch.unizh.oas.hibernate.helper.HibernatePersistencyHelper.init
(HibernatePersistencyHelper.java:90)
[java] at ch.unizh.oas.service.ServiceLocator.init(ServiceLocator.java:
67)
[java] at ch.unizh.oas.service.MainModel.initServices(MainModel.java:94
)
[java] at ch.unizh.oas.gui.general.MainFrame.main(MainFrame.java:184)
[java] Caused by: com.mchange.v2.resourcepool.ResourcePoolException: A Reso
urcePool could not acquire a resource from its primary factory or source.
[java] at com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(Ba
sicResourcePool.java:872)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResourc
e(BasicResourcePool.java:203)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPoo
ledConnection(C3P0PooledConnectionPool.java:209)
[java] ... 10 more
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] 01.02.2005 13:40:41 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: Use scrollable result sets: false
[java] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@114b17 --
Acquisition Attempt Failed!!! Clearing pending acquires.
[java] While trying to acquire a needed new resource, we failed
[java] 01.02.2005 13:40:41 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: Use JDBC3 getGeneratedKeys(): false
[java] to succeed more than the maximum number of allowed
[java] 01.02.2005 13:40:41 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: Optimize cache for minimal puts: false
[java] acquisition attempts (5).
[java] 01.02.2005 13:40:41 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: Query language substitutions: {no='N', true=1, yes='Y', false=
0}
[java] 01.02.2005 13:40:41 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: cache provider: net.sf.hibernate.cache.EhCacheProvider
[java] 01.02.2005 13:40:41 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: query cache factory: net.sf.hibernate.cache.StandardQueryCache
Factory
[java] 01.02.2005 13:40:41 net.sf.hibernate.cfg.Configuration configureCach
es
[java] INFO: instantiating and configuring caches
[java] 01.02.2005 13:40:41 net.sf.hibernate.impl.SessionFactoryImpl <init>
[java] INFO: building session factory
[java] 01.02.2005 13:40:42 net.sf.hibernate.impl.SessionFactoryObjectFactor
y addInstance
[java] INFO: Not binding factory to JNDI, no JNDI name configured
[java] 01.02.2005 13:40:42 net.sf.hibernate.cache.UpdateTimestampsCache <in
it>
[java] INFO: starting update timestamps cache at region: net.sf.hibernate.c
ache.UpdateTimestampsCache
[java] 01.02.2005 13:40:42 net.sf.hibernate.cache.StandardQueryCache <init>

[java] INFO: starting query cache at region: net.sf.hibernate.cache.Standar
dQueryCache
[java] 01.02.2005 13:40:42 net.sf.hibernate.dialect.Dialect <init>
[java] INFO: Using dialect: net.sf.hibernate.dialect.MySQLDialect
[java] 01.02.2005 13:40:42 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: Maximim outer join fetch depth: 1
[java] 01.02.2005 13:40:42 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: Use outer join fetching: true
[java] 01.02.2005 13:40:42 net.sf.hibernate.connection.ConnectionProviderFa
ctory newConnectionProvider
[java] INFO: Initializing connection provider: net.sf.hibernate.connection.
C3P0ConnectionProvider
[java] 01.02.2005 13:40:42 net.sf.hibernate.connection.C3P0ConnectionProvid
er configure
[java] INFO: C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://
localhost/oasuni2?useUnicode=true&characterEncoding=UTF-8
[java] 01.02.2005 13:40:42 net.sf.hibernate.connection.C3P0ConnectionProvid
er configure
[java] INFO: Connection properties: {user=oas2, password=oas2}
[java] 01.02.2005 13:40:42 net.sf.hibernate.transaction.TransactionManagerL
ookupFactory getTransactionManagerLookup
[java] INFO: No TransactionManagerLookup configured (in JTA environment, us
e of process level read-write cache is not recommended)
[java] Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@b
fbbe3 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDat
aSource@1c85444 [ acquireIncrement -> 2, acquireRetryAttempts -> 5, acquireRetry
Delay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfte
rAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com
.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, for
ceIgnoreUnresolvedTransactions -> false, idleConnectionTestPeriod -> 3000, initi
alPoolSize -> 2, maxIdleTime -> 5000, maxPoolSize -> 2, maxStatements -> 100, ma
xStatementsPerConnection -> 0, minPoolSize -> 2, nestedDataSource -> com.mchange
.v2.c3p0.DriverManagerDataSource@8de972 [ description -> null, driverClass -> nu
ll, factoryClassLocation -> null, jdbcUrl -> jdbc:mysql://localhost/oasuni2?useU
nicode=true&characterEncoding=UTF-8, properties -> {user=******, password=******
} ] , preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin
-> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies ->
false ] , factoryClassLocation -> null, numHelperThreads -> 3, poolOwnerIdentit
yToken -> bfbbe3 ]
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.
run(ThreadPoolAsynchronousRunner.java:354)
[java] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1adb7b8 --
Acquisition Attempt Failed!!! Clearing pending acquires.
[java] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@3e5a91 --
Acquisition Attempt Failed!!! Clearing pending acquires.
[java] While trying to acquire a needed new resource, we failed
[java] While trying to acquire a needed new resource, we failed
[java] to succeed more than the maximum number of allowed
[java] to succeed more than the maximum number of allowed
[java] acquisition attempts (5).
[java] acquisition attempts (5).
[java] 01.02.2005 13:40:56 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] WARNUNG: Could not obtain connection metadata
[java] java.sql.SQLException: An SQLException was provoked by the following
failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool coul
d not acquire a resource from its primary factory or source.
[java] at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:68)
[java] at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:57)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPoo
ledConnection(C3P0PooledConnectionPool.java:213)
[java] at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBa
ckedDataSource.java:64)
[java] at net.sf.hibernate.connection.C3P0ConnectionProvider.getConnect
ion(C3P0ConnectionProvider.java:33)
[java] at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFa
ctory.java:73)
[java] at net.sf.hibernate.cfg.Configuration.buildSettings(Configuratio
n.java:1155)
[java] at ch.unizh.oas.hibernate.helper.HibernatePersistencyHelper$MyCo
nfiguration.buildSettings(HibernatePersistencyHelper.java:404)
[java] at ch.unizh.oas.hibernate.helper.HibernatePersistencyHelper.init
(HibernatePersistencyHelper.java:92)
[java] at ch.unizh.oas.service.ServiceLocator.init(ServiceLocator.java:
67)
[java] at ch.unizh.oas.service.MainModel.initServices(MainModel.java:94
)
[java] at ch.unizh.oas.gui.general.MainFrame.main(MainFrame.java:184)
[java] Caused by: com.mchange.v2.resourcepool.ResourcePoolException: A Reso
urcePool could not acquire a resource from its primary factory or source.
[java] at com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(Ba
sicResourcePool.java:872)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResourc
e(BasicResourcePool.java:203)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPoo
ledConnection(C3P0PooledConnectionPool.java:209)
[java] ... 9 more
[java] 01.02.2005 13:40:56 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: Use scrollable result sets: false
[java] 01.02.2005 13:40:56 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: Use JDBC3 getGeneratedKeys(): false
[java] 01.02.2005 13:40:56 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: Optimize cache for minimal puts: false
[java] 01.02.2005 13:40:56 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: Query language substitutions: {no='N', true=1, yes='Y', false=
0}
[java] 01.02.2005 13:40:56 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: cache provider: net.sf.hibernate.cache.EhCacheProvider
[java] 01.02.2005 13:40:56 net.sf.hibernate.cfg.SettingsFactory buildSettin
gs
[java] INFO: query cache factory: net.sf.hibernate.cache.StandardQueryCache
Factory
[java] 01.02.2005 13:40:56 ch.unizh.oas.hibernate.helper.HibernatePersisten
cyHelper init
[java] INFO: finished initialization of hibernate.
[java] 01.02.2005 13:40:56 ch.unizh.oas.service.DataService loadAreasAndSub
Areas
[java] INFO: loading areas for language de...
[java] java.sql.SQLException: Unable to connect to any hosts due to excepti
on: java.net.ConnectException: Connection refused: connect
[java] at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
[java] at com.mysql.jdbc.Connection.<init>(Connection.java:562)
[java] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:361)
[java] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Dri
verManagerDataSource.java:68)
[java] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooled
Connection(WrapperConnectionPoolDataSource.java:87)
[java] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireRe
source(C3P0PooledConnectionPool.java:83)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResou
rce(BasicResourcePool.java:886)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(Ba
sicResourcePool.java:603)
[java] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(Basi
cResourcePool.java:31)
[java] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run
(BasicResourcePool.java:1071)
[java] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.

This is expected and intended behavior.

If you want to fail early, open a session and do something.

Hi Gavin

thanks for the quick feedback, I'll try this. Is this (expected and intended behaviour) documented somewhere?

regards, Peter

Hi.

At the c3p0 level, if you want Connection acquisition to fail faster and harder, you can use the following parameters (in a c3p0.properties file):

c3p0.acquireRetryAttempts=... (something smaller than the default 30)
c3p0.acquireRetryDelay=... (something smaller than the default 1000 ms)
c3p0.breakAfterAcquireFailure=true

You've tried the first of these. The last parameter will cause a c3p0 DataSource to consider itself irrecoverably broken if it fails a full round of Connection acquisition attempts (where the length and duration of a "full round" is defined by the two parameters above). Any attempt to use a DataSource after it has declared itself broken will provoke an immediate Exception.

By default, c3p0 is now set up to be very tolerant of Connection acquisition failures, so that DataSources eventually recover from network or database outtages. But, this means c3p0 remains ever hopeful under its default configuration, taking its time to declare bad database-connection information bad, and forever willing to give it another shot.

smiles,
Steve (c3p0 guy)