At 11:48 AM 3/03/2005 +1000, you wrote:

>http://www.hibernate.org/80.html details the following:
>
>"PreparedStatement caching is impossible!

Ignorant of Hibernate, I don't know what that means in
Hibernate-talk. Firebird caches prepared statements when clients ask it
to. Whether Jaybird supports it is a question for the firebird-java list
gurus.

>Firebird InterClient 2.01 is
>strongly recommended in preference to other versions of Interbase
>Interclient.

There is no "Firebird InterClient 2.01". The Interclient in the firebird
tree is just the bits and pieces that came through in the original IB 6
source tree. It has never been developed in Firebird. Firebird did its
Java interface completely from scratch - that is Jaybird.

>Its also worth trying the latest pure Java "JayBird" driver
>(http://www.ibphoenix.com)."

That is pretty dumb of Hibernate, too. Jaybird has its own patch of ground
in the development area of the Firebird website. On the top (red) menu,
click Development > JDBC Driver. (*Memo* I need to remove InterClient from
this menu: it is delusionary!)

When you get there, you will find links to the Jaybird wiki, where there is
more detailed and interesting stuff, as well as documentation.

>
>Can anyone tell me whether this is correct? Can PreparedStatement
>caching not be achieved using Jaybird and Firebird. If this is the case
>is this due to the JDBC driver or Firebird?

Take this question directly to the Jaybird list - firebird-java. You can
subscribe from the firebird website (Resources > Lists and
Newsgroups). There you will also find a LOT of people who are using
Hibernate/Jaybird/Firebird.

./hb