Examples of org.apache.derby.iapi.sql.Statement

org.apache.derby.iapi.sql.Statement
The Statement interface provides a way of giving a statement to the language module, preparing the statement, and executing it. It also provides some support for stored statements. Simple, non-stored, non-parameterized statements can be executed with the execute() method. Parameterized statements must use prepare(). To get the stored query plan for a statement, use get().
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. @author Jeff Lichtman

    {
      lcc.pushTriggerTable(triggerTable);
    }


    // stored statements always stored as unicode.
    Statement       stmt = lcf.getStatement(dd.getSchemaDescriptor(compSchemaId, null), text, true);


    try
    {
      preparedStatement = (ExecPreparedStatement) stmt.prepareStorable(
                lcc,
                preparedStatement, 
                getParameterDefaults(),
                getSchemaDescriptor(),
                type == SPS_TYPE_TRIGGER);

View Full Code Here

    {
      lcc.pushTriggerTable(triggerTable);
    }


    // stored statements always stored as unicode.
    Statement       stmt = lcf.getStatement(dd.getSchemaDescriptor(compSchemaId, null), text, true);


    try
    {
      preparedStatement = (ExecPreparedStatement) stmt.prepareStorable(
                lcc,
                preparedStatement, 
                getParameterDefaults(),
                getSchemaDescriptor(),
                type == SPS_TYPE_TRIGGER);

View Full Code Here

    {
      lcc.pushTriggerTable(triggerTable);
    }


    // stored statements always stored as unicode.
    Statement       stmt = lcf.getStatement(dd.getSchemaDescriptor(compSchemaId, null), text, true);


    try
    {
      preparedStatement = (ExecPreparedStatement) stmt.prepareStorable(
                lcc,
                preparedStatement, 
                getParameterDefaults(),
                getSchemaDescriptor(),
                type == SPS_TYPE_TRIGGER);

View Full Code Here

    {
      lcc.pushTriggerTable(triggerTable);
    }


    // stored statements always stored as unicode.
    Statement       stmt = lcf.getStatement(dd.getSchemaDescriptor(compSchemaId, null), text, true);


    try
    {
      preparedStatement = (ExecPreparedStatement) stmt.prepareStorable(
                lcc,
                preparedStatement, 
                getParameterDefaults(),
                getSchemaDescriptor(),
                type == SPS_TYPE_TRIGGER);

View Full Code Here

    {
      lcc.pushTriggerTable(triggerTable);
    }


    // stored statements always stored as unicode.
    Statement       stmt = lcf.getStatement(dd.getSchemaDescriptor(compSchemaId, null), text, true);


    try
    {
      preparedStatement = (ExecPreparedStatement) stmt.prepareStorable(
                lcc,
                preparedStatement, 
                getParameterDefaults(),
                getSchemaDescriptor(),
                type == SPS_TYPE_TRIGGER);

View Full Code Here

    {
      lcc.pushTriggerTable(triggerTable);
    }


    // stored statements always stored as unicode.
    Statement       stmt = lcf.getStatement(dd.getSchemaDescriptor(compSchemaId, null), text, true);


    try
    {
      preparedStatement = (ExecPreparedStatement) stmt.prepareStorable(
                lcc,
                preparedStatement, 
                getParameterDefaults(),
                getSchemaDescriptor(),
                type == SPS_TYPE_TRIGGER);

View Full Code Here

    {
      lcc.pushTriggerTable(triggerTable);
    }


    // stored statements always stored as unicode.
    Statement       stmt = lcf.getStatement(dd.getSchemaDescriptor(compSchemaId, null), text, true);


    try
    {
      preparedStatement = (ExecPreparedStatement) stmt.prepareStorable(
                lcc,
                preparedStatement, 
                getParameterDefaults(),
                getSchemaDescriptor(),
                type == SPS_TYPE_TRIGGER);

View Full Code Here

    {
      lcc.pushTriggerTable(triggerTable);
    }


    // stored statements always stored as unicode.
    Statement       stmt = lcf.getStatement(dd.getSchemaDescriptor(compSchemaId, null), text, true);


    try
    {
      preparedStatement = (ExecPreparedStatement) stmt.prepareStorable(
                lcc,
                preparedStatement, 
                getParameterDefaults(),
                getSchemaDescriptor(),
                type == SPS_TYPE_TRIGGER);

View Full Code Here

    {
      lcc.pushTriggerTable(triggerTable);
    }


    // stored statements always stored as unicode.
    Statement       stmt = lcf.getStatement(dd.getSchemaDescriptor(compSchemaId, null), text);


    try
    {
      preparedStatement = (ExecPreparedStatement) stmt.prepareStorable(
                lcc,
                preparedStatement, 
                getParameterDefaults(),
                getSchemaDescriptor(),
                type == SPS_TYPE_TRIGGER);

View Full Code Here

    {
      lcc.pushTriggerTable(triggerTable);
    }


    // stored statements always stored as unicode.
    Statement       stmt = lcf.getStatement(dd.getSchemaDescriptor(compSchemaId, null), text);


    try
    {
      preparedStatement = (ExecPreparedStatement) stmt.prepareStorable(
                lcc,
                preparedStatement, 
                getParameterDefaults(),
                getSchemaDescriptor(),
                type == SPS_TYPE_TRIGGER);

View Full Code Here

0 1

TOP

Related Classes of org.apache.derby.iapi.sql.Statement

org.apache.derby.iapi.sql.dictionary.SPSDescriptor

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.