Examples of java.sql.ResultSet.updateAsciiStream()

java.sql.ResultSet.updateAsciiStream()
Updates a column specified by a column index with an ASCII stream value. @param columnIndex the index of the column to update @param x the new value for the specified column @param length the length of the data to write from the stream @throws SQLException if a database error happens

   public void updateAsciiStream(String columnLabel, InputStream x, long length) throws SQLException
   {
      ResultSet resultSet = getUnderlyingResultSet();
      try
      {
         resultSet.updateAsciiStream(columnLabel, x, length);
      }
      catch (Throwable t)
      {
         throw checkException(t);
      }

View Full Code Here

   public void updateAsciiStream(String columnLabel, InputStream x) throws SQLException
   {
      ResultSet resultSet = getUnderlyingResultSet();
      try
      {
         resultSet.updateAsciiStream(columnLabel, x);
      }
      catch (Throwable t)
      {
         throw checkException(t);
      }

View Full Code Here

    Statement stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
    ResultSet rs = stmt.executeQuery("SELECT id, asi, chr, bin FROM stream");


    rs.moveToInsertRow();
    rs.updateInt(1, 1);
    rs.updateAsciiStream("asi", null, 17);
    rs.updateCharacterStream("chr", null, 81);
    rs.updateBinaryStream("bin", null, 0);
    rs.insertRow();


    rs.moveToInsertRow();

View Full Code Here

    rs.updateBinaryStream("bin", null, 0);
    rs.insertRow();


    rs.moveToInsertRow();
    rs.updateInt(1, 3);
    rs.updateAsciiStream("asi", new ByteArrayInputStream(string.getBytes("US-ASCII")), 5);
    rs.updateCharacterStream("chr", new StringReader(string), 5);
    rs.updateBinaryStream("bin", new ByteArrayInputStream(bytes), bytes.length);
    rs.insertRow();


    rs.beforeFirst();

View Full Code Here

    assertNull(rs.getString(2));
    assertNull(rs.getString(3));
    assertNull(rs.getBytes(4));


    rs.updateInt("id", 2);
    rs.updateAsciiStream("asi", new ByteArrayInputStream(string.getBytes("US-ASCII")), 5);
    rs.updateCharacterStream("chr", new StringReader(string), 5);
    rs.updateBinaryStream("bin", new ByteArrayInputStream(bytes), bytes.length);
    rs.updateRow();


    assertEquals(2, rs.getInt(1));

View Full Code Here

        //other tests can go on unimpacted


        ResultSet rs1 = stmt.executeQuery
                ("select * from UpdateTestTable_ResultSet for update");
        rs1.next();
        rs1.updateAsciiStream(2,is_for_update,(int)BYTES2.length);
        rs1.updateRow();
        rs1.close();


        //Query to see whether the data that has been updated
        //using the updateAsciiStream method is the same

View Full Code Here

        //use a different ResultSet variable so that the
        //other tests can go on unimpacted


        ResultSet rs1 = fetchUpd("dLongVarchar", key);
        rs1.next();
        rs1.updateAsciiStream("dLongVarchar",is_for_update,(int)BYTES2.length);
        rs1.updateRow();
        rs1.close();


        //Query to see whether the data that has been updated
        //using the updateAsciiStream method is the same

View Full Code Here

        ps_sb.close();


        // Update the data.
        ResultSet rs1 = fetchUpd("dLongVarchar", key);
        rs1.next();
        rs1.updateAsciiStream(1, isForUpdate);
        rs1.updateRow();
        rs1.close();


        // Query to see whether the data that has been updated.
        rs1 = fetch("dLongVarchar", key);

View Full Code Here

        ps_sb.close();


        // Update the data.
        ResultSet rs1 = fetchUpd("dLongVarchar", key);
        rs1.next();
        rs1.updateAsciiStream("dLongVarchar", isForUpdate);
        rs1.updateRow();
        rs1.close();


        // Query to see whether the data that has been updated.
        rs1 = fetch("dLongVarchar", key);

View Full Code Here

            if (spy)
                spyLogger.debugf("%s [%s] updateAsciiStream(%s, %s, %s)",
                        jndiName, Constants.SPY_LOGGER_PREFIX_RESULTSET,
                        columnIndex, x, length);


            resultSet.updateAsciiStream(columnIndex, x, length);
        } catch (Throwable t) {
            throw checkException(t);
        }
    }

View Full Code Here

0 1 2 3 4

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.