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

        Statement.NO_GENERATED_KEYS,
        null,
        null);


    // mark our parameters as for a callable statement 
    ParameterValueSet pvs = getParms();


    // do we have a return parameter?
    hasReturnOutputParameter = pvs.hasReturnOutputParameter();
  }

View Full Code Here

      //Fetch the getParms into a local variable now because the
      //activation associated with a CallableStatement at this 
      //point(after the executStatement) is the current activation. 
      //We can now safely stuff the return value of the 
      //CallableStatement into the following ParameterValueSet object.
      ParameterValueSet pvs = getParms();


      /*
      ** If we have a return parameter, then we
      ** consume it from the returned ResultSet
      ** reset the ResultSet set to null.
      */
      if (hasReturnOutputParameter)
      {
        if (SanityManager.DEBUG)
        {
          SanityManager.ASSERT(results!=null, "null results even though we are supposed to have a return parameter");
        }
        boolean gotRow = results.next();
        if (SanityManager.DEBUG)
        {
          SanityManager.ASSERT(gotRow, "the return resultSet didn't have any rows");
        }


        try
        {
          DataValueDescriptor returnValue = pvs.getReturnValueForSet();
          returnValue.setValueFromResultSet(results, 1, true);
        } catch (StandardException e)
        {
          throw EmbedResultSet.noStateChangeException(e);
        }

View Full Code Here

  /**
    Check to see if a statement requires to be executed via a callable statement.
  */
  protected 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

        JDBC30Translation.NO_GENERATED_KEYS,
        null,
        null);


    // mark our parameters as for a callable statement 
    ParameterValueSet pvs = getParms();


    // do we have a return parameter?
    hasReturnOutputParameter = pvs.hasReturnOutputParameter();
  }

View Full Code Here

    // to ensure we have an activation for the getParams
    checkExecStatus();
    synchronized (getConnectionSynchronization())
    {
      wasNull = false;
      ParameterValueSet pvs = getParms();
      try
      {
        pvs.validate();


      } catch (StandardException e)
      {
        throw EmbedResultSet.noStateChangeException(e);
      }


      /* KLUDGE - ? = CALL ... returns a ResultSet().  We
       * need executeUpdate to be false in that case.
       */
      boolean execResult = super.executeStatement(a, executeQuery,
        (executeUpdate && (! hasReturnOutputParameter)));


      /*
      ** If we have a return parameter, then we
      ** consume it from the returned ResultSet
      ** reset the ResultSet set to null.
      */
      if (hasReturnOutputParameter)
      {
        if (SanityManager.DEBUG)
        {
          SanityManager.ASSERT(results!=null, "null results even though we are supposed to have a return parameter");
        }
        boolean gotRow = results.next();
        if (SanityManager.DEBUG)
        {
          SanityManager.ASSERT(gotRow, "the return resultSet didn't have any rows");
        }


        try
        {
          pvs.setReturnValue(results.getObject(1));


        } catch (StandardException e)
        {
          throw EmbedResultSet.noStateChangeException(e);
        }

View Full Code Here

  }


  public void addBatch() throws SQLException {


    checkStatus();
    ParameterValueSet pvs = getParms();


    int numberOfParameters = pvs.getParameterCount();


    for (int j=1; j<=numberOfParameters; j++) {


      switch (pvs.getParameterMode(j)) {
      case JDBC30Translation.PARAMETER_MODE_IN:
      case JDBC30Translation.PARAMETER_MODE_UNKNOWN:
        break;
      case JDBC30Translation.PARAMETER_MODE_OUT:
      case JDBC30Translation.PARAMETER_MODE_IN_OUT:

View Full Code Here


    int jdbcTypeId = getParameterJDBCType(parameterIndex);




    try {
      ParameterValueSet pvs = getParms();


      LimitReader limitIn = new LimitReader(reader);
      if (length != -1)
        limitIn.setLimit(length);
      ReaderToUTF8Stream utfIn = new ReaderToUTF8Stream(limitIn);


      /* JDBC is one-based, DBMS is zero-based */
      pvs.getParameterForSet(parameterIndex - 1).setValue(utfIn, length);


    } catch (StandardException t) {
      throw EmbedResultSet.noStateChangeException(t);
    }
  }

View Full Code Here

      }
    }


  protected 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.