Package org.apache.derby.iapi.sql

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

1463
1464
1465
1466
1467
1468
1469
1470
1471
1472
1473
1474
1475
1476
1477
1478
  /**
    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
72
73
74
75
76
77
78
79
80
81
        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
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
      //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
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
      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
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
      }
    }

  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
1050
1051
1052
1053
1054
1055
1056
1057
1058
   * @exception SQLException thrown on failure.
     */
    public void clearParameters() throws SQLException {
    checkStatus();

    ParameterValueSet pvs = getParms();
    if (pvs != null)
      pvs.clearParameters();
  }
View Full Code Here
1592
1593
1594
1595
1596
1597
1598
1599
1600
1601
1602
1603
1604
1605
    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
73
74
75
76
77
78
79
80
81
82
        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
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
      //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
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
    }
   
  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
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
    • 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.