> Not exactly.
> What I mean is the following:
> Assume, I have code, that prepares a statement (on a certain
> connection).
> Uses it and finally closes that statement and connection.
> I see, that the connection is not really closed, but returned to the
> pool.
>
> Now assume, that code is run again.
> Because of transparent statement pooling, the already prepared
> statement will be used again - but it is already closed!
>
> What will happen here?

Everything will work as expected. :) PreparedStatement.close() returns
statement to the pool, it does not release the statement (but the
result set is released). That's the main part of the dynamic proxy code.

Roman