This interface will have different implementations for the execution-only and compile-and-execute versions of the product. In the execution-only version, some of the methods will do nothing but raise exceptions to indicate that they are not implemented.
There is a Statement factory in the Connection interface in the Database module, which uses the one provided in LanguageFactory.
| Modifier and Type | Method and Description |
|---|---|
| public String | Returns: the SQL string this statement is for.Return the SQL string that this statement is for. |
| public PreparedStatement | Returns: A PreparedStatement that allows execution of the execution plan.The language connection context lcc)Generates an execution plan without executing it. |
| public PreparedStatement | Returns: A PreparedStatement that allows execution of the execution plan.the language connection context lcc, boolean If this statement is for a metadata call then
we will allow internal sql syntax on such statement. This internal
sql syntax is not available to a user sql statement. allowInternalSyntax)Generates an execution plan without executing it. |
| public PreparedStatement | Returns: A Storable PreparedStatement that allows execution of the execution plan.Compiler state variable. lcc, PreparedStatement Prepared statement ps, Object[] Default parameter values to use for
optimization paramDefaults, SchemaDescriptor schema of the stored prepared statement spsSchema, boolean True if this is for Derby-internal SQL internalSQL)Generates an execution plan given a set of named parameters. |
| getSource | back to summary |
|---|---|
| public String getSource() Return the SQL string that this statement is for.
| |
| prepare | back to summary |
|---|---|
| public PreparedStatement prepare(LanguageConnectionContext lcc) throws StandardException Generates an execution plan without executing it.
| |
| prepare | back to summary |
|---|---|
| public PreparedStatement prepare(LanguageConnectionContext lcc, boolean allowInternalSyntax) throws StandardException Generates an execution plan without executing it.
| |
| prepareStorable | back to summary |
|---|---|
| public PreparedStatement prepareStorable(LanguageConnectionContext lcc, PreparedStatement ps, Object[] paramDefaults, SchemaDescriptor spsSchema, boolean internalSQL) throws StandardException Generates an execution plan given a set of named parameters. For generating a storable prepared statement (which has some extensions over a standard prepared statement).
| |