> This page says to always set prepared statement cache to 0 when
> using Firebird with Hibernate - but doesn't explicitly refer to
> Apache DBCP. It also doesn't say why to do this.
>
> http://www.hibernate.org/120.html?cmd=prntdoc

No clue why.

> A confirmation that I should turn off prepared statement caching
> with Apache DBCP or any further information on this issue would be
> appreicated very much!

What about posting a test here? We can then check why it fails.

One guess would be that those statements belong to different connections
running different transactions. But a confirmation is needed.

Roman