Package org.apache.derby.iapi.sql

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


        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

      throw Util.notImplemented();
    }
  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

      }
    }

  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

      }
    }

  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

       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

TOP

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

Copyright © 2018 www.massapicom. All rights reserved.
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.