Hi

> > What if the statement which originally prepared the statement is closed?
> I think you mean connection. in this case all statements are closed too.

any subsequent operation on the closed statement results in SQLException.

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?

> if you specify maxStatements property, only the specified number of

prepared statements will be kept in cache.

Okay.

> see DataSource.getConnection(String, String) method.

I will.


Thanks, once again.


Regards,
Steffen