Hi

> > while(true) {
> > Connection con = getConnection(); // gets a connection from Pool.
> > PreparedStatement ps = con.prepareStatement(some_sql); ps.execute();
> > con close(); }

> No, when you close the connection, prepared statement pool is released...
> Hmmm... I think I want to correct this.

Wrong. The connection is NOT closed.
It is just returned to the pool!

Regards,
Steffen