Friday, January 31, 2003 07:33 AM
How exactly PreparedStatement(s) are stored into database side as in many references its written they are stored into database side as stored procedure? What is the mechanism? Is there any overhead to connection? If the program closes the connection will the same statement will recompile again with fresh connection? I guess PreparedStatement(s) are bound to connection life, is this true?
What care should be taken to get the maximum result regarding handling connection? Any reference/link to good documentation will be most helpful.
Thanks in advance!