Subject Re: [Firebird-Java] Jaybird with hibernate
Author Roman Rokytskyy
> "...JDBC type 4 driver with excellent support. DDL statements cannot be
> executed when there is more than one open JDBC connection.
> PreparedStatement caching is impossible! Firebird InterClient 2.01 is
> strongly recommended in preference to other versions of Interbase
> Interclient. Its also worth trying the latest pure Java "JayBird" driver.

> Can you tell me how current this information is in regards to the Latest
> Firebird / Jaybird combination? I am particularly interested in the
> PreparedStatement caching as it is a performance feature of Hibernate. I
> thought I remember reading that it was a major performance factor with
> Hibernate some time ago but I could not locate that resource to quote it.

Quite an outdated info. InterClient 2.01 is at least 6 year old technology
without any updates since original release as opensource. Jaybird had
already 4 releases behind it, approaching the 5th. The JDBC connection pool
that comes with Jaybird has PreparedStatement cache, but I think Hibernate
uses its own, there should be no issue there at all (but if there is, report
it here and we will fix it).

Roman