Kbase P24198: What is the lifespan of an SQL-92 Prepared Statement when co
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/08/2003 |
|
Status: Unverified
GOAL:
Can an SQL-92 prepared statement be reused indefinitely when using JDBC? Is there any case in which it should be closed and reopened?
FACT(s) (Environment):
Progress 9.1D
FIX:
Yes, an SQL-92 statement may be reused indefinitely once it has been prepared without the need to to re-prepare it.
However, it is recommended to call the close() method for each statement at the end of each execution cycle in order to release resources as soon as they are no longer needed to avoid tying up the database resources.
The Java garbage collector will close the statement object and release resources automatically finally by default.