Ken,

> I have heard that pooled prepared statements are part of JDBC3.0 but
> have not looked at the spec. Here is a patch that will implement
> prepared statement pooling. The patch is against the 1.0 version of
> the driver.

Thank you for the patch. However currently I'm thinking about
implementing statement pooling on the API level (JDBC level connection
and statement pooling is already in the CVS in client-java/src/pool/
directory). Implementing it on the API level adds generic mechanism of
statement handle pooling. The only problem I see is to decrease
coupling between instances of java.sql.Statement class (and
subclasses) and API objects.

Will you be interested in working in that direction?

Thanks!
Roman Rokytskyy