Folks,
I'm working on a java appication using Hibernate. After switching from MySql to Oracle, I see a large number of warnings org.hibernate.connection.DriverManagerConnectionProvider - problem closing pooled connection.

This is not consistent in that sometime a run gives none of these, sometimes more than others.

Any idea what might be going on? Do you need anything else from me to help sorting this out?
Thanks,
Dave Godbey

Hibernate version:
3.2.1

Full stack trace of any exception that occurs:
2007-02-21 14:22:41,064 [Finalizer] WARN org.hibernate.connection.DriverManagerConnectionProvider - problem closing pooled connection
java.sql.SQLException: Io exception: Socket closed
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274)
at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:406)
at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:1083)
at org.hibernate.connection.DriverManagerConnectionProvider.close(DriverManagerConnectionProvider.java:152)
at org.hibernate.connection.DriverManagerConnectionProvider.finalize(DriverManagerConnectionProvider.java:142)
at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)
at java.lang.ref.Finalizer.access$100(Finalizer.java:14)
at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)
Name and version of the database you are using:
Oracle 10.2

hibernate.properties
######################
### Query Language ###
######################

## define query language constants / function names

hibernate.query.substitutions true 1, false 0, yes 'Y', no 'N'



#################
### Platforms ###
#################

## Oracle

hibernate.dialect org.hibernate.dialect.Oracle9Dialect
#hibernate.dialect org.hibernate.dialect.OracleDialect
hibernate.connection.driver_class oracle.jdbc.OracleDriver
hibernate.connection.username muves_dgodbey
hibernate.connection.password muvespasswd
hibernate.connection.url jdbc:oracle:thin:@fs1.arl.army.mil:1523:muvesdev

jdbc:microsoft:sqlserver://1E1;DatabaseName=test;SelectMethod=cursor

#################################
### Hibernate Connection Pool ###
#################################

hibernate.connection.pool_size 1000



###########################
### C3P0 Connection Pool###
###########################

#hibernate.c3p0.max_size 20
#hibernate.c3p0.min_size 1
#hibernate.c3p0.timeout 5
#hibernate.c3p0.max_statements 100
#hibernate.c3p0.validate false


###################################
### Apache DBCP Connection Pool ###
###################################

## connection pool

#hibernate.dbcp.maxActive 100
#hibernate.dbcp.whenExhaustedAction 1
#hibernate.dbcp.maxWait 120000
#hibernate.dbcp.maxIdle 10

## prepared statement cache

#hibernate.dbcp.ps.maxActive 100
#hibernate.dbcp.ps.whenExhaustedAction 1
#hibernate.dbcp.ps.maxWait 120000
#hibernate.dbcp.ps.maxIdle 10

## optional query to validate pooled connections:

#hibernate.dbcp.validationQuery select 1 from dual
#hibernate.dbcp.testOnBorrow true
#hibernate.dbcp.testOnReturn false




## the Transaction API abstracts application code from the underlying JTA or JDBC transactions

#hibernate.transaction.factory_class org.hibernate.transaction.JTATransactionFactory
hibernate.transaction.factory_class org.hibernate.transaction.JDBCTransactionFactory

##############################
### Miscellaneous Settings ###
##############################

## print all generated SQL to the console

#hibernate.show_sql true
hibernate.show_sql false


## auto schema export

#hibernate.hbm2ddl.auto create-drop
#hibernate.hbm2ddl.auto create
hibernate.hbm2ddl.auto update


## specify a JDBC isolation level

hibernate.connection.isolation 2


## set the JDBC fetch size

#hibernate.jdbc.fetch_size 25


## set the maximum JDBC 2 batch size (a nonzero value enables batching)

hibernate.jdbc.batch_size 10


## enable use of JDBC 2 scrollable ResultSets (specifying a Dialect will cause Hibernate to use a sensible default)

#hibernate.jdbc.use_scrollable_resultset true


## use streams when writing binary types to / from JDBC

hibernate.jdbc.use_streams_for_binary true




## enable outerjoin fetching (specifying a Dialect will cause Hibernate to use sensible default)

#hibernate.use_outer_join false


## set the maximum depth of the outer join fetch tree

hibernate.max_fetch_depth 1


## enable CGLIB reflection optimizer (enabled by default)

hibernate.bytecode.use_reflection_optimizer false


## enable the query cache

#hibernate.cache.use_query_cache true


## choose a cache implementation

#hibernate.cache.provider_class net.sf.ehcache.hibernate.Provider
#hibernate.cache.provider_class org.hibernate.cache.EmptyCacheProvider
#hibernate.cache.provider_class org.hibernate.cache.HashtableCacheProvider
#hibernate.cache.provider_class org.hibernate.cache.TreeCacheProvider
#hibernate.cache.provider_class org.hibernate.cache.OSCacheProvider
#hibernate.cache.provider_class org.hibernate.cache.JCSCacheProvider
#hibernate.cache.provider_class org.hibernate.cache.SwarmCacheProvider
[/code]