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

org.apache.derby.iapi.sql.ParameterValueSet
A ParameterValueSet is a set of parameter values that can be assembled by a JDBC driver and passed to a PreparedStatement all at once. The fact that they are all passed at once can reduce the communication overhead between client and server. @author Jeff Lichtman

  /**
    Check to see if a statement requires to be executed via a callable statement.
  */
  void checkRequiresCallableStatement(Activation activation) throws SQLException {


    ParameterValueSet pvs = activation.getParameterValueSet();


    if (pvs == null)
      return;


    if (pvs.checkNoDeclaredOutputParameters()) {
      try {
        activation.close();
      } catch (StandardException se) {
      }
      throw newSQLException(SQLState.REQUIRES_CALLABLE_STATEMENT, SQLText);

View Full Code Here


            if ( originalConstant ==  null ) { newConstant = null; }
            else if ( originalConstant instanceof int[] )
            {
                int parameterNumber = ((int[]) originalConstant)[ 0 ];
                ParameterValueSet pvs = activation.getParameterValueSet();


                newConstant = pvs.getParameter( parameterNumber ).getObject();
            }
            else { newConstant = originalConstant; }
           
            return new Restriction.ColumnQualifier
                (

View Full Code Here

       if (lccToUse.getLogStatementText())
      {
        HeaderPrintWriter istream = Monitor.getStream();
        String xactId = lccToUse.getTransactionExecute().getActiveStateTxIdString();
        String pvsString = "";
        ParameterValueSet pvs = activation.getParameterValueSet();
        if (pvs != null && pvs.getParameterCount() > 0)
        {
          pvsString = " with " + pvs.getParameterCount() +
              " parameters " + pvs.toString();
        }
        istream.printlnWithHeader(LanguageConnectionContext.xidStr + 
                      xactId + 
                      "), " +
                      LanguageConnectionContext.lccStr +
                      lccToUse.getInstanceNumber() +
                      "), " +
                      LanguageConnectionContext.dbnameStr +
                      lccToUse.getDbname() +
                      "), " +
                      LanguageConnectionContext.drdaStr +
                      lccToUse.getDrdaID() +
                      "), Executing prepared statement: " +
                      getSource() +
                      " :End prepared statement" +
                      pvsString);
      }


      ParameterValueSet pvs = activation.getParameterValueSet();


      /* put it in try block to unlock the PS in any case
       */
      if (!spsAction) {
      // only re-prepare if this isn't an SPS for a trigger-action;

View Full Code Here

      }
    }


  boolean executeBatchElement(Object batchElement) throws SQLException, StandardException {
    
    ParameterValueSet temp = (ParameterValueSet) batchElement;


    int numberOfParameters = temp.getParameterCount();


    for (int j=0; j<numberOfParameters; j++) {
      temp.getParameter(j).setInto(this, j + 1);
    }


    return super.executeStatement(activation, false, true);
  }

View Full Code Here

   * @exception SQLException thrown on failure.
     */
    public void clearParameters() throws SQLException {
    checkStatus();


    ParameterValueSet pvs = getParms();
    if (pvs != null)
      pvs.clearParameters();
  }

View Full Code Here

    if (scale < 0)
      throw newSQLException(SQLState.BAD_SCALE_VALUE, new Integer(scale));
    
    try {


      ParameterValueSet pvs = getParms();


      /* JDBC is one-based, DBMS is zero-based */
      DataValueDescriptor value = pvs.getParameter(parameterIndex - 1);




      int origvaluelen = value.getLength();
      ((VariableSizeDataValue)
            value).setWidth(VariableSizeDataValue.IGNORE_PRECISION,

View Full Code Here

  /**
    Check to see if a statement requires to be executed via a callable statement.
  */
  void checkRequiresCallableStatement(Activation activation) throws SQLException {


    ParameterValueSet pvs = activation.getParameterValueSet();


    if (pvs == null)
      return;


    if (pvs.checkNoDeclaredOutputParameters()) {
      try {
        activation.close();
      } catch (StandardException se) {
      }
      throw newSQLException(SQLState.REQUIRES_CALLABLE_STATEMENT, SQLText);

View Full Code Here

       if (lccToUse.getLogStatementText())
      {
        HeaderPrintWriter istream = Monitor.getStream();
        String xactId = lccToUse.getTransactionExecute().getActiveStateTxIdString();
        String pvsString = "";
        ParameterValueSet pvs = activation.getParameterValueSet();
        if (pvs != null && pvs.getParameterCount() > 0)
        {
          pvsString = " with " + pvs.getParameterCount() +
              " parameters " + pvs.toString();
        }
        istream.printlnWithHeader(LanguageConnectionContext.xidStr + 
                      xactId + 
                      "), " +
                      LanguageConnectionContext.lccStr +
                      lccToUse.getInstanceNumber() +
                      "), " +
                      LanguageConnectionContext.dbnameStr +
                      lccToUse.getDbname() +
                      "), " +
                      LanguageConnectionContext.drdaStr +
                      lccToUse.getDrdaID() +
                      "), Executing prepared statement: " +
                      getSource() +
                      " :End prepared statement" +
                      pvsString);
      }


      ParameterValueSet pvs = activation.getParameterValueSet();


      /* put it in try block to unlock the PS in any case
       */
      if (!spsAction) {
      // only re-prepare if this isn't an SPS for a trigger-action;

View Full Code Here

      }
    }


  boolean executeBatchElement(Object batchElement) throws SQLException, StandardException {
    
    ParameterValueSet temp = (ParameterValueSet) batchElement;


    int numberOfParameters = temp.getParameterCount();


    for (int j=0; j<numberOfParameters; j++) {
      temp.getParameter(j).setInto(this, j + 1);
    }


    return super.executeStatement(activation, false, true);
  }

View Full Code Here

   * @exception SQLException thrown on failure.
     */
    public void clearParameters() throws SQLException {
    checkStatus();


    ParameterValueSet pvs = getParms();
    if (pvs != null)
      pvs.clearParameters();
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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

org.apache.derby.impl.jdbc.EmbedCallableStatement

org.apache.derby.impl.jdbc.EmbedPreparedStatement

org.apache.derby.impl.jdbc.EmbedStatement

org.apache.derby.impl.sql.compile.CompilerContextImpl

org.apache.derby.impl.sql.compile.ExecSPSNode

org.apache.derby.impl.sql.execute.SetRoleConstantAction

org.apache.derby.impl.sql.execute.SetSchemaConstantAction

org.apache.derby.impl.sql.execute.VTIResultSet

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.