Reusing of a PreparedStatement between methods?
Posted
by
MRalwasser
on Stack Overflow
See other posts from Stack Overflow
or by MRalwasser
Published on 2011-01-10T13:49:32Z
Indexed on
2011/01/10
13:53 UTC
Read the original article
Hit count: 205
We all know that we should rather reuse a JDBC PreparedStatement
than creating a new instance within a loop.
But how to deal with PreparedStatement
reuse between different method invocations?
Does the reuse-"rule" still count?
Should I really consider using a field for the PreparedStatement
or should I close and re-create the prepared statement in every invocation?
(Of course an instance of such a class would be bound to a Connection
which might be a disadvantage)
I am aware that the ideal answer might be "it depends".
But I am looking for a best practice for less experienced developers that they will do the right choice in most of the cases.
© Stack Overflow or respective owner