Hello,

I'm having the following exception since I migrated from hibernate 2.1 to 3.1.3. I'm using c3p0 v0.9.0.

Hibernate version:
3.1.3

Full stack trace of any exception that occurs:
[java] 2006-11-08 23:51:10,622 (org.hibernate.impl.SessionImpl:219) 141022 DEBUG - opened session at timestamp: 4763755604467712
[java] 2006-11-08 23:51:10,622 (org.hibernate.transaction.JDBCTransaction:54) 141022 DEBUG - begin
[java] 2006-11-08 23:51:10,622 (org.hibernate.jdbc.ConnectionManager:415) 141022 DEBUG - opening JDBC connection
[java] 2006-11-08 23:51:10,632 (com.mchange.v2.resourcepool.BasicResourcePool:1081) 141032 DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@4eb471 ---> age: 25426 max: 100000 [com.mchange.v2.resourcepool.BasicResourcePool@185fe0c]
[java] 2006-11-08 23:51:10,632 (com.mchange.v2.resourcepool.BasicResourcePool:1159) 141032 DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@185fe0c [managed: 10, unused: 9, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@caf083)
[java] 2006-11-08 23:51:10,632 (org.hibernate.transaction.JDBCTransaction:59) 141032 DEBUG - current autocommit status: false
[java] 2006-11-08 23:51:10,632 (org.hibernate.jdbc.JDBCContext:194) 141032 DEBUG - after transaction begin
[java] 2006-11-08 23:51:10,632 (org.hibernate.engine.query.QueryPlanCache:75) 141032 DEBUG - located HQL query plan in cache (
[java] from Match match where match.nbButs1 >= 3 and match.tournoi.saison.numero = :numero order by match.nbButs1 desc, match.nbButs2 asc
[java] )
[java] 2006-11-08 23:51:10,632 (org.hibernate.transaction.JDBCTransaction:103) 141032 DEBUG - commit
[java] 2006-11-08 23:51:10,632 (org.hibernate.impl.SessionImpl:332) 141032 DEBUG - automatically flushing session
[java] 2006-11-08 23:51:10,632 (org.hibernate.jdbc.JDBCContext:185) 141032 DEBUG - before transaction completion
[java] 2006-11-08 23:51:10,632 (org.hibernate.impl.SessionImpl:388) 141032 DEBUG - before transaction completion
[java] 2006-11-08 23:51:10,632 (org.hibernate.transaction.JDBCTransaction:116) 141032 DEBUG - committed JDBC Connection
[java] 2006-11-08 23:51:10,632 (org.hibernate.jdbc.JDBCContext:199) 141032 DEBUG - after transaction completion
[java] 2006-11-08 23:51:10,642 (org.hibernate.jdbc.ConnectionManager:398) 141042 DEBUG - aggressively releasing JDBC connection
[java] 2006-11-08 23:51:10,642 (org.hibernate.jdbc.ConnectionManager:435) 141042 DEBUG - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
[java] 2006-11-08 23:51:10,642 (com.mchange.v2.c3p0.impl.NewPooledConnection:294) 141042 DEBUG - A Throwable occurred while trying to reset the typeMap property of our Connection to Collections.EMPTY_MAP!
[java] java.sql.SQLException: This function is not supported
[java] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
[java] at org.hsqldb.jdbc.Util.notSupported(Unknown Source)
[java] at org.hsqldb.jdbc.jdbcConnection.setTypeMap(Unknown Source)
[java] at com.mchange.v2.c3p0.impl.NewPooledConnection.reset(NewPooledConnection.java:290)
[java] at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:247)
[java] at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1148)
[java] at org.hibernate.connection.C3P0ConnectionProvider.closeConnection(C3P0ConnectionProvider.java:42)
[java] at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:445)
[java] at org.hibernate.jdbc.ConnectionManager.aggressiveRelease(ConnectionManager.java:400)
[java] at org.hibernate.jdbc.ConnectionManager.afterTransaction(ConnectionManager.java:287)
[java] at org.hibernate.jdbc.JDBCContext.afterTransactionCompletion(JDBCContext.java:205)
[java] at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:119)
[java] at com.pescorer.model.table.MeilleursResultats.setModel(Unknown Source)
[java] at com.pescorer.model.table.MeilleursResultats.update(Unknown Source)
[java] at com.pescorer.ihm.main.tabbedpane.CompetitionTab$1.mouseClicked(Unknown Source)
[java] at java.awt.AWTEventMulticaster.mouseClicked(Unknown Source)
[java] at java.awt.Component.processMouseEvent(Unknown Source)
[java] at java.awt.Component.processEvent(Unknown Source)
[java] at java.awt.Container.processEvent(Unknown Source)
[java] at java.awt.Component.dispatchEventImpl(Unknown Source)
[java] at java.awt.Container.dispatchEventImpl(Unknown Source)
[java] at java.awt.Component.dispatchEvent(Unknown Source)
[java] at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
[java] at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
[java] at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
[java] at java.awt.Container.dispatchEventImpl(Unknown Source)
[java] at java.awt.Window.dispatchEventImpl(Unknown Source)
[java] at java.awt.Component.dispatchEvent(Unknown Source)
[java] at java.awt.EventQueue.dispatchEvent(Unknown Source)
[java] at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
[java] at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
[java] at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
[java] at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
[java] at java.awt.EventDispatchThread.run(Unknown Source)

Name and version of the database you are using:
HSQLDB v1.8.0

For each transaction, I have this stack trace. It bothers me but the operations to the DB are done successfully.

speedster,

this issue is harmless, but long-ago fixed. upgrade, either to c3p0-0.9.0.4 or c3p0-0.9.1-pre10 (both series are quite mature now).

smiles,
steve

Thank you.
I will upgrade c3p0. I had updated the hsql driver but I did not think about c3p0.