Hi there!

I need some help changing form the built-in connection pool to c3p0.
I use HibernateUtil and I can't do:
session = HibernateUtil.currentSession();
session.beginTransaction();
You can see the result in the debug log. It seems like the c3p0 connection is closed somewhere in SchemaUpdate.

Everything is working just fine with the built-in connection pool.

Thanks in advance for any hint.
regards
Markus

PS: I just realized that Hibernate 3.1 final is out. I just tried it and the result is the same. c3p0 0.9.0.2 doesn't make a difference either.

INFO - Hibernate 3.1 rc3
INFO - hibernate.properties not found
INFO - using CGLIB reflection optimizer
INFO - using JDK 1.4 java.sql.Timestamp handling
INFO - configuring from resource: /hibernate.cfg.xml
INFO - Configuration resource: /hibernate.cfg.xml
[...]
INFO - Configured SessionFactory: null
INFO - processing extends queue
INFO - processing collection mappings
INFO - processing association property references
INFO - processing foreign key constraints
INFO - C3P0 using driver: org.firebirdsql.jdbc.FBDriver at URL: jdbc:firebirdsql://127.0.0.1:3050/E:/workspace_neu/vnetservices/vnetservices/WEB-INF/vnetservices.gdb
INFO - Connection properties: {user=sysdba, password=****}
INFO - autocommit mode: false
INFO - MLog clients using log4j logging.
INFO - Initializing c3p0-0.9.0 [built 11-July-2005 00:43:29 -0400; debug? true; trace: 10]
INFO - Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@129df8a [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@14e40da [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 14e40da, idleConnectionTestPeriod -> 100, initialPoolSize -> 10, maxIdleTime -> 100, maxPoolSize -> 100, maxStatements -> 100, maxStatementsPerConnection -> 0, minPoolSize -> 10, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@eac7c8 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> eac7c8, jdbcUrl -> jdbc:firebirdsql://127.0.0.1:3050/E:/workspace_neu/vnetservices/vnetservices/WEB-INF/vnetservices.gdb, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ], factoryClassLocation -> null, identityToken -> 129df8a, numHelperThreads -> 3 ]
INFO - RDBMS: Firebird 1.5, version: WI-V1.5.2.4731 Firebird 1.5,WI-V1.5.2.4731 Firebird 1.5/tcp (valula)/P10
INFO - JDBC driver: JayBird JCA/JDBC driver, version: 2.0
INFO - Using dialect: org.hibernate.dialect.FirebirdDialect
INFO - Automatic flush during beforeCompletion(): disabled
INFO - Automatic session close at end of transaction: disabled
INFO - Scrollable result sets: enabled
INFO - JDBC3 getGeneratedKeys(): disabled
INFO - Connection release mode: auto
INFO - Default batch fetch size: 1
INFO - Generate SQL with comments: disabled
INFO - Order SQL updates by primary key: disabled
INFO - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
INFO - Using ASTQueryTranslatorFactory
INFO - Query language substitutions: {}
INFO - Second-level cache: enabled
INFO - Query cache: disabled
INFO - Cache provider: org.hibernate.cache.NoCacheProvider
INFO - Optimize cache for minimal puts: disabled
INFO - Structured second-level cache entries: disabled
INFO - Echoing all SQL to stdout
INFO - Statistics: disabled
INFO - Deleted entity synthetic identifier rollback: disabled
INFO - Default entity-mode: POJO
INFO - building session factory
INFO - Not binding factory to JNDI, no JNDI name configured
INFO - processing extends queue
INFO - processing collection mappings
INFO - processing association property references
INFO - processing foreign key constraints
INFO - Checking 0 named HQL queries
INFO - Checking 0 named SQL queries

2005-12-15 11:59:05,163: INFO [http-8443-Processor25] org.hibernate.cfg.Configuration - processing extends queue
2005-12-15 11:59:05,163: INFO [http-8443-Processor25] org.hibernate.cfg.Configuration - processing collection mappings
2005-12-15 11:59:05,163: INFO [http-8443-Processor25] org.hibernate.cfg.Configuration - processing association property references
2005-12-15 11:59:05,163: INFO [http-8443-Processor25] org.hibernate.cfg.Configuration - processing foreign key constraints
2005-12-15 11:59:05,163: DEBUG [http-8443-Processor25] org.hibernate.cfg.Configuration - resolving reference to class: vnet.ws.objects.FileExchangeProperty
2005-12-15 11:59:05,163: DEBUG [http-8443-Processor25] org.hibernate.cfg.Configuration - resolving reference to class: vnet.ws.objects.User
2005-12-15 11:59:05,163: DEBUG [http-8443-Processor25] org.hibernate.cfg.Configuration - resolving reference to class: vnet.ws.objects.DomainMapping
2005-12-15 11:59:05,163: DEBUG [http-8443-Processor25] org.hibernate.cfg.Configuration - resolving reference to class: vnet.ws.objects.User
2005-12-15 11:59:05,163: DEBUG [http-8443-Processor25] org.hibernate.cfg.Configuration - resolving reference to class: vnet.ws.objects.ForwardMapping
2005-12-15 11:59:05,163: DEBUG [http-8443-Processor25] org.hibernate.cfg.Configuration - resolving reference to class: vnet.ws.objects.User
2005-12-15 11:59:05,163: DEBUG [http-8443-Processor25] org.hibernate.cfg.Configuration - resolving reference to class: vnet.ws.objects.RoleName
2005-12-15 11:59:05,805: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
2005-12-15 11:59:05,805: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.impl.NewPooledConnection - A Throwable occurred while trying to reset the typeMap property of our Connection to Collections.EMPTY_MAP!
org.firebirdsql.jdbc.FBDriverNotCapableException: Not yet implemented.
at org.firebirdsql.jdbc.AbstractConnection.setTypeMap(AbstractConnection.java:938)
at com.mchange.v2.c3p0.impl.NewPooledConnection.reset(NewPooledConnection.java:290)
at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:247)
at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1148)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:174)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:295)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1152)
at vnet.ws.common.HibernateUtil.<clinit>(HibernateUtil.java:18)
at vnet.ws.jaas.DBLogin.validateUser(DBLogin.java:54)
at vnet.ws.jaas.VnetLoginShared.login(VnetLoginShared.java:92)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at javax.security.auth.login.LoginContext.invoke(Unknown Source)
at javax.security.auth.login.LoginContext.access$000(Unknown Source)
at javax.security.auth.login.LoginContext$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.login.LoginContext.invokePriv(Unknown Source)
at javax.security.auth.login.LoginContext.login(Unknown Source)
at org.apache.catalina.realm.JAASRealm.authenticate(JAASRealm.java:365)
at org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:180)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:485)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
2005-12-15 11:59:05,805: DEBUG [http-8443-Processor25] com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@b4d39c [managed: 10, unused: 9, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@9f3e95)
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - ENTER METHOD: closeAll( org.firebirdsql.jdbc.FBConnection@13f5841 )! -- num_connections: 0
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - Set of statements for connection: null
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - closeAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@b4d39c [managed: 9, unused: 9, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@9f3e95)
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - ENTER METHOD: closeAll( org.firebirdsql.jdbc.FBConnection@48fbc0 )! -- num_connections: 0
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - Set of statements for connection: null
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - closeAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@b4d39c [managed: 8, unused: 8, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@9f3e95)
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - ENTER METHOD: closeAll( org.firebirdsql.jdbc.FBConnection@3461d1 )! -- num_connections: 0
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - Set of statements for connection: null
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - closeAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@b4d39c [managed: 7, unused: 7, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@9f3e95)
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - ENTER METHOD: closeAll( org.firebirdsql.jdbc.FBConnection@18837f1 )! -- num_connections: 0
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - Set of statements for connection: null
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - closeAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@b4d39c [managed: 6, unused: 6, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@9f3e95)
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - ENTER METHOD: closeAll( org.firebirdsql.jdbc.FBConnection@10f0a0 )! -- num_connections: 0
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - Set of statements for connection: null
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - closeAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@b4d39c [managed: 5, unused: 5, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@9f3e95)
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - ENTER METHOD: closeAll( org.firebirdsql.jdbc.FBConnection@25bd56 )! -- num_connections: 0
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - Set of statements for connection: null
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - closeAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@b4d39c [managed: 4, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@9f3e95)
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - ENTER METHOD: closeAll( org.firebirdsql.jdbc.FBConnection@1b18235 )! -- num_connections: 0
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - Set of statements for connection: null
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - closeAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@b4d39c [managed: 3, unused: 3, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@9f3e95)
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - ENTER METHOD: closeAll( org.firebirdsql.jdbc.FBConnection@db95a1 )! -- num_connections: 0
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - Set of statements for connection: null
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - closeAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@b4d39c [managed: 2, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@9f3e95)
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - ENTER METHOD: closeAll( org.firebirdsql.jdbc.FBConnection@3c9616 )! -- num_connections: 0
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - Set of statements for connection: null
2005-12-15 11:59:05,821: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - closeAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
2005-12-15 11:59:05,837: DEBUG [http-8443-Processor25] com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@b4d39c [managed: 1, unused: 1, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@9f3e95)
2005-12-15 11:59:05,837: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - ENTER METHOD: closeAll( org.firebirdsql.jdbc.FBConnection@1fcca7b )! -- num_connections: 0
2005-12-15 11:59:05,837: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - Set of statements for connection: null
2005-12-15 11:59:05,837: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.stmt.GooGooStatementCache - closeAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0
2005-12-15 11:59:05,837: DEBUG [http-8443-Processor25] com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@b4d39c [managed: 0, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@9f3e95)
2005-12-15 11:59:05,837: DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] com.mchange.v2.async.ThreadPoolAsynchronousRunner - Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main] interrupted. Shutting down.
2005-12-15 11:59:05,837: DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] com.mchange.v2.async.ThreadPoolAsynchronousRunner - Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main] interrupted. Shutting down.
2005-12-15 11:59:05,837: DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] com.mchange.v2.async.ThreadPoolAsynchronousRunner - Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main] interrupted. Shutting down.
2005-12-15 11:59:05,837: DEBUG [http-8443-Processor25] com.mchange.v2.c3p0.PoolBackedDataSource - com.mchange.v2.c3p0.PoolBackedDataSource@129df8a has been closed. force_destroy == false
java.lang.Exception: Debug -- PoolBackedDataSource.close() stack trace.
at com.mchange.v2.c3p0.PoolBackedDataSource.close(PoolBackedDataSource.java:214)
at com.mchange.v2.c3p0.DataSources.destroy(DataSources.java:259)
at com.mchange.v2.c3p0.DataSources.destroy(DataSources.java:226)
at org.hibernate.connection.C3P0ConnectionProvider.close(C3P0ConnectionProvider.java:118)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:175)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:295)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1152)
at vnet.ws.common.HibernateUtil.<clinit>(HibernateUtil.java:18)
at vnet.ws.jaas.DBLogin.validateUser(DBLogin.java:54)
at vnet.ws.jaas.VnetLoginShared.login(VnetLoginShared.java:92)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at javax.security.auth.login.LoginContext.invoke(Unknown Source)
at javax.security.auth.login.LoginContext.access$000(Unknown Source)
at javax.security.auth.login.LoginContext$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.login.LoginContext.invokePriv(Unknown Source)
at javax.security.auth.login.LoginContext.login(Unknown Source)
at org.apache.catalina.realm.JAASRealm.authenticate(JAASRealm.java:365)
at org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:180)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:485)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig - Checking context[/host-manager] redeploy resource D:\Programme\Tomcat5.5.14\conf\Catalina\localhost\host-manager.xml
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig - Checking context[/host-manager] redeploy resource D:\Programme\Tomcat5.5.14\server\webapps\host-manager
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig - Checking context[/host-manager] reload resource D:\Programme\Tomcat5.5.14\conf\context.xml
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig - Checking context[/host-manager] reload resource D:\Programme\Tomcat5.5.14\conf\Catalina\localhost\host-manager.xml
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig - Checking context[/tomcat-docs] redeploy resource D:\Programme\Tomcat5.5.14\webapps\tomcat-docs
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig - Checking context[/tomcat-docs] redeploy resource D:\Programme\Tomcat5.5.14\webapps\tomcat-docs\META-INF\context.xml
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig - Checking context[/tomcat-docs] reload resource D:\Programme\Tomcat5.5.14\webapps\tomcat-docs\WEB-INF\web.xml
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig - Checking context[/tomcat-docs] reload resource D:\Programme\Tomcat5.5.14\conf\context.xml
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig - Checking context[/vnetservices] redeploy resource D:\Programme\Tomcat5.5.14\conf\Catalina\localhost\vnetservices.xml
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig - Checking context[/vnetservices] redeploy resource E:\workspace_neu\vnetservices\vnetservices
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig - Checking context[/vnetservices] reload resource D:\Programme\Tomcat5.5.14\conf\context.xml
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig - Checking context[/vnetservices] reload resource D:\Programme\Tomcat5.5.14\conf\Catalina\localhost\vnetservices.xml
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig - Checking context[] redeploy resource D:\Programme\Tomcat5.5.14\webapps\ROOT
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig - Checking context[] redeploy resource D:\Programme\Tomcat5.5.14\webapps\ROOT\META-INF\context.xml
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig - Checking context[] reload resource D:\Programme\Tomcat5.5.14\conf\context.xml
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig - Checking context[] reload resource D:\Programme\Tomcat5.5.14\webapps\ROOT\WEB-INF\web.xml
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig - Checking context[/manager] redeploy resource D:\Programme\Tomcat5.5.14\conf\Catalina\localhost\manager.xml
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig - Checking context[/manager] redeploy resource D:\Programme\Tomcat5.5.14\server\webapps\manager
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig - Checking context[/manager] reload resource D:\Programme\Tomcat5.5.14\conf\Catalina\localhost\manager.xml
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig - Checking context[/manager] reload resource D:\Programme\Tomcat5.5.14\conf\context.xml
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.loader.WebappClassLoader - modified()
2005-12-15 11:59:05,852: DEBUG [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.loader.WebappClassLoader - Failed tracking modifications of '/WEB-INF/lib'
2005-12-15 11:59:05,868: INFO [http-8443-Processor25] org.hibernate.impl.SessionFactoryImpl - Checking 0 named HQL queries
2005-12-15 11:59:05,868: INFO [http-8443-Processor25] org.hibernate.impl.SessionFactoryImpl - Checking 0 named SQL queries
2005-12-15 11:59:05,868: INFO [http-8443-Processor25] root - SessionFactory successfully built!
2005-12-15 11:59:05,868: INFO [http-8443-Processor25] root - currentSession!

2005-12-15 11:59:05,915: DEBUG [http-8443-Processor25] org.hibernate.impl.SessionImpl - opened session at timestamp: 11346443458
2005-12-15 11:59:05,931: DEBUG [http-8443-Processor25] org.hibernate.util.JDBCExceptionReporter - Cannot open connection [???]
java.sql.SQLException: com.mchange.v2.c3p0.PoolBackedDataSource@129df8a [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@14e40da [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 14e40da, idleConnectionTestPeriod -> 100, initialPoolSize -> 10, maxIdleTime -> 100, maxPoolSize -> 100, maxStatements -> 100, maxStatementsPerConnection -> 0, minPoolSize -> 10, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@eac7c8 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> eac7c8, jdbcUrl -> jdbc:firebirdsql://127.0.0.1:3050/E:/workspace_neu/vnetservices/vnetservices/WEB-INF/vnetservices.gdb, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ], factoryClassLocation -> null, identityToken -> 129df8a, numHelperThreads -> 3 ] has been closed() -- you can no longer use it.
at com.mchange.v2.c3p0.PoolBackedDataSource.assertCpds(PoolBackedDataSource.java:234)
at com.mchange.v2.c3p0.PoolBackedDataSource.getPoolManager(PoolBackedDataSource.java:246)
at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:94)
at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:35)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:304)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:109)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:134)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1167)
at vnet.ws.jaas.DBLogin.validateUser(DBLogin.java:55)
at vnet.ws.jaas.VnetLoginShared.login(VnetLoginShared.java:92)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at javax.security.auth.login.LoginContext.invoke(Unknown Source)
at javax.security.auth.login.LoginContext.access$000(Unknown Source)
at javax.security.auth.login.LoginContext$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.login.LoginContext.invokePriv(Unknown Source)
at javax.security.auth.login.LoginContext.login(Unknown Source)
at org.apache.catalina.realm.JAASRealm.authenticate(JAASRealm.java:365)
at org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:180)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:485)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
2005-12-15 11:59:05,931: WARN [http-8443-Processor25] org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
2005-12-15 11:59:05,931: ERROR [http-8443-Processor25] org.hibernate.util.JDBCExceptionReporter - com.mchange.v2.c3p0.PoolBackedDataSource@129df8a [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@14e40da [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 14e40da, idleConnectionTestPeriod -> 100, initialPoolSize -> 10, maxIdleTime -> 100, maxPoolSize -> 100, maxStatements -> 100, maxStatementsPerConnection -> 0, minPoolSize -> 10, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@eac7c8 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> eac7c8, jdbcUrl -> jdbc:firebirdsql://127.0.0.1:3050/E:/workspace_neu/vnetservices/vnetservices/WEB-INF/vnetservices.gdb, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ], factoryClassLocation -> null, identityToken -> 129df8a, numHelperThreads -> 3 ] has been closed() -- you can no longer use it.
2005-12-15 11:59:05,931: ERROR [http-8443-Processor25] vnet.ws.jaas.DBLogin - org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:307)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:109)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:134)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1167)
at vnet.ws.jaas.DBLogin.validateUser(DBLogin.java:55)
at vnet.ws.jaas.VnetLoginShared.login(VnetLoginShared.java:92)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at javax.security.auth.login.LoginContext.invoke(Unknown Source)
at javax.security.auth.login.LoginContext.access$000(Unknown Source)
at javax.security.auth.login.LoginContext$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.login.LoginContext.invokePriv(Unknown Source)
at javax.security.auth.login.LoginContext.login(Unknown Source)
at org.apache.catalina.realm.JAASRealm.authenticate(JAASRealm.java:365)
at org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:180)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:485)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: com.mchange.v2.c3p0.PoolBackedDataSource@129df8a [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@14e40da [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 14e40da, idleConnectionTestPeriod -> 100, initialPoolSize -> 10, maxIdleTime -> 100, maxPoolSize -> 100, maxStatements -> 100, maxStatementsPerConnection -> 0, minPoolSize -> 10, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@eac7c8 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> eac7c8, jdbcUrl -> jdbc:firebirdsql://127.0.0.1:3050/E:/workspace_neu/vnetservices/vnetservices/WEB-INF/vnetservices.gdb, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ], factoryClassLocation -> null, identityToken -> 129df8a, numHelperThreads -> 3 ] has been closed() -- you can no longer use it.
at com.mchange.v2.c3p0.PoolBackedDataSource.assertCpds(PoolBackedDataSource.java:234)
at com.mchange.v2.c3p0.PoolBackedDataSource.getPoolManager(PoolBackedDataSource.java:246)
at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:94)
at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:35)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:304)
... 29 more

2005-12-15 11:59:05,931: DEBUG [http-8443-Processor25] org.hibernate.impl.SessionImpl - closing session
2005-12-15 11:59:05,946: WARN [http-8443-Processor25] org.apache.catalina.realm.JAASRealm - Login exception authenticating username "vnetadmin"

Newer versions of c3P0 have a bug in the code that handles optional methods. c3p0 checks whether that method exists by using reflection but not whether you can really call it without getting a exception. This problem with getTypeMap() occurs with quite many JDBC drivers (i had it with DB2). Try using a older version like 0.0.9.0. This works for me[/quote]

[/quote]

I was using 0.9.0. Should I try an even older version? The newest version 0.9.0.2 didn't make a difference.