converted to 1.6 markup
|Deletions are marked like this.||Additions are marked like this.|
|Line 17:||Line 17:|
|1. StatementCache: Derby caches prepared statements to avoid unnecessary re-preparation.|
Derby SQL Language System
LanguageParse: Parser generates QueryTree from SQL statement text.
LanguageBind: Bind phase checks semantics.
LanguageOptimize: Optimization modifies QueryTree.
LanguageGenerate: Generate Java byte code for execution.
Data Structure Notes
StatementCache: Derby caches prepared statements to avoid unnecessary re-preparation.
For the lifetime of the execution, either until the ResultSet is closed, or the executeUpdate() call returns, the Statement has a one-to-one relationship with a single use Activation. Once the statement is complete the activation will be closed.
java.sql.PreparedStatement & CallableStatement
The application's JDBC PreparedStatement or CallableStatement has a one-to-one relationship with an Activation. The Activation maintains the state of the execution including parameters and linkage to the shared statement plan.
please fill in
TriggerImplementation Notes on the implementation of triggers.
http://db.apache.org/derby/binaries/ApacheDerbyInternals_1_1.pdf Derby internals presentation