At least one application server (Websphere) pools prepared statements in
exactly the same way as connections for just this reason. Even though the
SQL database pools the prepared statement query plan, websphere allows the
additional performance improvement of pooling the prepared statements.
"Do you believe that my being stronger or faster has anything
to do with my muscles in this place?" ... "Free your mind."
Laurence Fishburne as Morpheus in 'The Matrix'.
Fred A. Kulack - AS/400e Java and Java DB2 access, Jdbc, JTA, etc...
IBM in Rochester, MN (Phone: 507.253.5982 T/L 553-5982)
mailto:[EMAIL PROTECTED] Personal: mailto:[EMAIL PROTECTED]
AOL Instant Messenger: Home:FKulack Work:FKulackWrk
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
