db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marco Ferretti <marco.ferre...@gmail.com>
Subject Question about prepared statements
Date Wed, 21 Jul 2010 15:23:10 GMT
Hello,
I have a question on how derby works with prepared statements.

The scenario :
-1 connection (embedded driver)
-1 prepared statement run several times over the database ( does not matter
if select, insert ... )
-I keep the connection open but close the prepared statement ( and make sure
it is garbage collected )
-On a later stage I create a new prepared statement with the same SQL as the
one mentioned before

Question :
Does derby re-use the pre-compiled SQL or is it creating another one ?

TIA

Marco

Mime
View raw message