List of pushStatementContext() Examples

Examples of pushStatementContext()

org.apache.derby.iapi.sql.conn.LanguageConnectionContext.pushStatementContext()
Push a StatementContext on the context stack. @param isAtomic whether a commit/rollback is permittedfrom a nested connection under this statement @param stmtText the text of the statement. Needed for any languagestatement (currently, for any statement that can cause a trigger to fire). Please set this unless you are some funky jdbc setXXX method or something. @param pvs parameter value set, if it has one @param rollbackParentContext True if 1) the statement context isNOT a top-level context, AND 2) in the event of a statement-level exception, the parent context needs to be rolled back, too. @param timeoutMillis Timeout value for this statement, in milliseconds.Zero means no timeout. @return StatementContext The statement context.

Examples of org.apache.derby.iapi.sql.conn.LanguageConnectionContext.pushStatementContext()

                insertSQL.append(") ");
                valuesSQL.append(") ");
                insertSQL.append(valuesSQL);


                // Context used for preparing, don't set any timeout (use 0)
                statementContext = lcc.pushStatementContext(
                        isAtomic, 
                        false, 
                        insertSQL.toString(), 
                        null, 
                        false,

View Full Code Here

Examples of org.apache.derby.iapi.sql.conn.LanguageConnectionContext.pushStatementContext()

            //using quotes around the cursor name to preserve case sensitivity
            updateWhereCurrentOfSQL.append(" WHERE CURRENT OF " + 
                    quoteSqlIdentifier(getCursorName()));


            // 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++) {

View Full Code Here

Examples of org.apache.derby.iapi.sql.conn.LanguageConnectionContext.pushStatementContext()

                //using quotes around the cursor name to preserve case sensitivity
                deleteWhereCurrentOfSQL.append(" WHERE CURRENT OF " + 
                        quoteSqlIdentifier(getCursorName()));
                
                // 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

View Full Code Here

Examples of org.apache.derby.iapi.sql.conn.LanguageConnectionContext.pushStatementContext()

           */
          LanguageConnectionContext lcc = getEmbedConnection()
              .getLanguageConnection();
                    // No timeout for this operation (use 0)
          StatementContext statementContext =
                        lcc.pushStatementContext(isAtomic, 
             concurrencyOfThisResultSet==JDBC20Translation.CONCUR_READ_ONLY,
             getSQLText(),
                                                 getParameterValueSet(),
                                                 false, 0L);

View Full Code Here

Examples of org.apache.derby.iapi.sql.conn.LanguageConnectionContext.pushStatementContext()

         * so that the ResultSet will get correctly closed down
         * on an error.
         * (Cache the LanguageConnectionContext)
         */
                StatementContext statementContext =
                    lcc.pushStatementContext(isAtomic, 
               concurrencyOfThisResultSet==java.sql.ResultSet.CONCUR_READ_ONLY, 
               getSQLText(),
               getParameterValueSet(),
                                             false, timeoutMillis);

View Full Code Here

Examples of org.apache.derby.iapi.sql.conn.LanguageConnectionContext.pushStatementContext()

                insertSQL.append(") ");
                valuesSQL.append(") ");
                insertSQL.append(valuesSQL);


                // Context used for preparing, don't set any timeout (use 0)
                statementContext = lcc.pushStatementContext(
                        isAtomic, 
                        false, 
                        insertSQL.toString(), 
                        null, 
                        false,

View Full Code Here

Examples of org.apache.derby.iapi.sql.conn.LanguageConnectionContext.pushStatementContext()

            //using quotes around the cursor name to preserve case sensitivity
            updateWhereCurrentOfSQL.append(" WHERE CURRENT OF " + 
                    quoteSqlIdentifier(getCursorName()));


            // 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);


            statementContext.setActivation(act);

View Full Code Here

Examples of org.apache.derby.iapi.sql.conn.LanguageConnectionContext.pushStatementContext()

                //using quotes around the cursor name to preserve case sensitivity
                deleteWhereCurrentOfSQL.append(" WHERE CURRENT OF " + 
                        quoteSqlIdentifier(getCursorName()));
                
                // 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);


                statementContext.setActivation(act);

View Full Code Here

Examples of org.apache.derby.iapi.sql.conn.LanguageConnectionContext.pushStatementContext()

           */
          LanguageConnectionContext lcc = getEmbedConnection()
              .getLanguageConnection();
                    // No timeout for this operation (use 0)
          StatementContext statementContext =
                        lcc.pushStatementContext(isAtomic, 
             concurrencyOfThisResultSet==java.sql.ResultSet.CONCUR_READ_ONLY,
             getSQLText(),
                                                 getParameterValueSet(),
                                                 false, 0L);

View Full Code Here

Examples of org.apache.derby.iapi.sql.conn.LanguageConnectionContext.pushStatementContext()

      // method of the GenericTriggerExecutor class, and at that time
      // the SPS action will be recompiled correctly.
        rePrepare(lccToUse);
      }


      StatementContext statementContext = lccToUse.pushStatementContext(
        isAtomic, updateMode==CursorNode.READ_ONLY, getSource(), pvs, rollbackParentContext, timeoutMillis);


      statementContext.setActivation(activation);


      if (needsSavepoint())

View Full Code Here

0 1 2 3 4 5

TOP

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.