Unfortunately, you are correct. Under ordinary circumstances, the PreparedStatement will not be reused. However, you may consider implementing the database connection pool sponsored by the Jakarta Commons subproject. That DBCP provides optional pooling of prepared statements.
- Morgan Steve Johnson-Evers wrote on 11/13/01 3:46 pm: I would like to have a preparedStatement nested inside a regular statement. Will the prepared statement get reused and just take the new setColumn value(s) or will database be asked to parse the inner statement for each row the outer statement returns? I suspect the latter but I don't know how to confirm my suspicions. -Stevers -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>