The DBCP documentation supports defaultCatalog (connection always returned with this catalog) and validationQuery (don't return connection unless this passes). However, attempting to use them in hibernate configuration they are ignored.

Does anyone know how to default a connection from the pool to a specific catalog?

Hibernate version:
2.1.8

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:
SQL Server 2000

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt: