Re: pooled prepared statements

Thomas Finneid wrote:

> When a PreparedStatment is created by a pooled connection, as far as I
> understand if, that creation happens on the server side, and a
> reference, of sorts, is returned to the client jdbc.

More or less, yes. (Assuming you're reusing the statement, not just
using it once and discarding it).

> Is that prepared statement shared among the connections or is it only
> available to that single connection?

It is associated only with the connection that prepared the statement.
The preparation of the statement on the server side is state that's
specific to the connection, and it's not shared between server backend
processes - so the JDBC driver couldn't share statements between
connections even if it wanted to.

> and more importantly, can many
> connections use that prepared statement concurrently?

No.

-O