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

org.apache.derby.iapi.sql.Activation
An activation contains all the local state information necessary to execute a re-entrant PreparedStatement. The way it will actually work is that a PreparedStatement will have an executable plan, which will be a generated class. All of the local state will be variables in the class. Creating a new instance of the executable plan will create the local state variables. This means that an executable plan must implement this interface, and that the PreparedStatement.getActivation() method will do a "new" operation on the executable plan.
The fixed implementations of Activation in the Execution impl package are used as skeletons for the classes generated for statements when they are compiled.
There are no fixed implementations of Activation for statements; a statement has an activation generated for it when it is compiled.

    public ResultSet execute(LanguageConnectionContext lcc,
                             boolean rollbackParentContext,
                             long timeoutMillis)
    throws StandardException
  {
    Activation a = getActivation(lcc, false);
    a.setSingleExecution();
    return execute(a, rollbackParentContext, timeoutMillis);
  }

View Full Code Here


    // try to remember the SQL statement in case anybody asks for it
    SQLText = sql;    


    try {
      Activation activation;
      try {
        PreparedStatement preparedStatement = lcc.prepareInternalStatement
            (lcc.getDefaultSchema(), sql, resultSetConcurrency==JDBC20Translation.CONCUR_READ_ONLY, false);
        activation =
          preparedStatement.getActivation(lcc, resultSetType == JDBC20Translation.TYPE_SCROLL_INSENSITIVE);
        checkRequiresCallableStatement(activation);
       } catch (Throwable t) {
        throw handleException(t);
       }




      // this is for a Statement execution
      activation.setSingleExecution();


      //bug 4838 - save the auto-generated key information in activation. keeping this
      //information in lcc will not work work it can be tampered by a nested trasaction
      if (autoGeneratedKeys == JDBC30Translation.RETURN_GENERATED_KEYS)
        activation.setAutoGeneratedKeysResultsetInfo(columnIndexes, columnNames);
      return executeStatement(activation, executeQuery, executeUpdate);
    } finally {
        restoreContextStack();
    }
    }

View Full Code Here

                        null, 
                        false, 
                        0L);
                org.apache.derby.iapi.sql.PreparedStatement ps = 
                        lcc.prepareInternalStatement(insertSQL.toString());
                Activation act = ps.getActivation(lcc, false);


                // in this for loop we are assigning values for parameters 
                //in sql constructed earlier VALUES (?, ..)
                for (int i=1, paramPosition=0; i<=rd.getColumnCount(); i++) { 
                    // if the column got updated, do following
                    if (columnGotUpdated[i-1]) {  
                        act.getParameterValueSet().
                                getParameterForSet(paramPosition++).
                                setValue(updateRow.getColumn(i));
                    }
                }
                // Don't see any timeout when inserting rows (use 0)

View Full Code Here

            lcc = getEmbedConnection().getLanguageConnection();


            // Context used for preparing, don't set any timeout (use 0)
            statementContext = lcc.pushStatementContext(isAtomic, false, updateWhereCurrentOfSQL.toString(), null, false, 0L);
            org.apache.derby.iapi.sql.PreparedStatement ps = lcc.prepareInternalStatement(updateWhereCurrentOfSQL.toString());
            Activation act = ps.getActivation(lcc, false);


            //in this for loop we are assigning values for parameters in sql constructed earlier with columnname=?,... 
            for (int i=1, paramPosition=0; i<=rd.getColumnCount(); i++) { 
                if (columnGotUpdated[i-1])  //if the column got updated, do following
                    act.getParameterValueSet().getParameterForSet(paramPosition++).setValue(updateRow.getColumn(i));
            }
            // Don't set any timeout when updating rows (use 0)
            // Execute the update where current of sql.
            org.apache.derby.iapi.sql.ResultSet rs = ps.execute(act, true, 0L);
            SQLWarning w = act.getWarnings();
            if (w != null) {
                addWarning(w);
            }
            rs.close();
            rs.finish();

View Full Code Here

                
                // Context used for preparing, don't set any timeout (use 0)
                statementContext = lcc.pushStatementContext(isAtomic, false, deleteWhereCurrentOfSQL.toString(), null, false, 0L);
                org.apache.derby.iapi.sql.PreparedStatement ps = lcc.prepareInternalStatement(deleteWhereCurrentOfSQL.toString());
                // Get activation, so that we can get the warning from it
                Activation act = ps.getActivation(lcc, false);
                // Don't set any timeout when deleting rows (use 0)
                //execute delete where current of sql
                org.apache.derby.iapi.sql.ResultSet rs = 
                        ps.execute(act, true, 0L);
                SQLWarning w = act.getWarnings();
                if (w != null) {
                    addWarning(w);
                }
                rs.close();
                rs.finish();

View Full Code Here

    if (cursorName != null)
    {
      // have to see if another activation is open
      // with the same cursor name. If so we can't use this name


      Activation activeCursor = lcc.lookupCursorActivation(cursorName);


      if ((activeCursor != null) && (activeCursor != ac)) {
        throw StandardException.newException(SQLState.LANG_CURSOR_ALREADY_EXISTS, cursorName);
      }
    }

View Full Code Here

        // closing one or more activation leaving our index beyond
        // the end of the array
        if (i >= acts.size())
          continue;


        Activation a1 = (Activation) acts.elementAt(i);
        if (!a1.isInUse()) {
          a1.close();
        }
      }
    }


    if (SanityManager.DEBUG) {

View Full Code Here


    int size = acts.size();
    if (size > 0)
    {
      for (int i = 0; i < size; i++) {
         Activation a = (Activation) acts.elementAt(i);


         if (!a.isInUse())
         {
          continue;
         }






        String executingCursorName = a.getCursorName();


         if (cursorName.equals(executingCursorName)) {


          ResultSet rs = a.getResultSet();
          if (rs == null)
            continue;


           // if the result set is closed, the the cursor doesn't exist
           if (rs.isClosed()) {

View Full Code Here

   */
  private boolean checkIfAnyActivationHasHoldCursor(String tableName)
      throws StandardException
  {
    for (int i = acts.size() - 1; i >= 0; i--) {
      Activation a = (Activation) acts.elementAt(i);
      if (a.checkIfThisActivationHasHoldCursor(tableName))
        return true;
    }
    return false;
  }

View Full Code Here

    boolean seenOpenResultSets = false;


    /* For every activation */
    for (int i = acts.size() - 1; i >= 0; i--) {


      Activation a = (Activation) acts.elementAt(i);


      if (SanityManager.DEBUG)
      {
        SanityManager.ASSERT(a instanceof CursorActivation, "a is not a CursorActivation");
      }


      if (!a.isInUse())
      {
        continue;
      }


      if (!a.getResultSetHoldability())
      {
        continue;
      }


      ResultSet rs = ((CursorActivation) a).getResultSet();


      /* is there an open result set? */
      if ((rs != null) && !rs.isClosed() && rs.returnsRows())
      {
        seenOpenResultSets = true;
        break;
      }
    }


    if (!seenOpenResultSets)
      return(true);


    // There may be open ResultSet's that are yet to be garbage collected
    // let's try and force these out rather than throw an error
    System.gc();
    System.runFinalization();




    /* For every activation */
    for (int i = acts.size() - 1; i >= 0; i--) {
        
      Activation a = (Activation) acts.elementAt(i);


      if (SanityManager.DEBUG)
      {
        SanityManager.ASSERT(a instanceof CursorActivation, "a is not a CursorActivation");
      }


      if (!a.isInUse())
      {
        continue;
      }


      if (!a.getResultSetHoldability())
      {
        continue;
      }


      ResultSet rs = ((CursorActivation) a).getResultSet();

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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

org.apache.derby.impl.jdbc.EmbedResultSet

org.apache.derby.impl.jdbc.EmbedStatement

org.apache.derby.impl.sql.compile.CurrentOfNode

org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext

org.apache.derby.impl.sql.execute.GenericResultSetFactory

org.apache.derby.impl.sql.execute.GenericTriggerExecutor

org.apache.derby.impl.sql.execute.MatchingClauseConstantAction

org.apache.derby.impl.sql.GenericActivationHolder

org.apache.derby.impl.sql.GenericPreparedStatement

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.