Hibernate version: 3.1

Name and version of the database you are using:
pgPool 2.6.5 & PostgreSQL 8.0.4

Hello,

we have some Problems with our actual Environment:

Hibernate 3.1
pgPool 2.6.5
PostgreSQL 8.0.4
OS SuSE Linux Enterprise Server 9 SP2
Java 1.4.2_09

We are using pgPool for failover and replication, but it doesn't work with Hibernate (using the C3P0-Connection-Pool). It is configured for two database servers.

If we try to access the database via pgPool the follwing errors occur:

org.hibernate.util.JDBCExceptionReporter;SQL Error: 0, SQLState: 42P05
dao.DAOException;unspezifiziert: could not execute query

The database error means that there are duplicate prepared statements?!?

These errors are occuring for simple queries like:

list = HibernateUtil.getCurrentSession().createCriteria(Verwaltung.class).add(
Expression.like("Unternehmensnummer", pId+"%")).list();
//.. do something with list
session().save(verwaltung);

When use a direct database-connection (without pgPool) - everthing works fine.

Can anybody help us with this problem?

An alternative we want to test is to use the C-JDBC-Driver instead of pgPool, but this would be only work for the Java-Parts of our System (we also have PHP- and C-Parts). So the pgPool-Solution would be preferred, but here's the question:

Does C-JDBC work fine with Hibernate and PostgreSQL?

Thanks in advance for the answers.