Examples of java.sql.ResultSet.updateBinaryStream()

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

        rs.updateFloat(11, (float) 0.0);
        rs.updateLong(12, 0L);
        rs.updateObject(13, null);
        rs.updateShort(14, (short) 0);
        rs.updateCharacterStream(15, new StringReader("test"), 0);
        rs.updateBinaryStream(16, new ByteArrayInputStream(new byte[] { (byte) 0xff, 0x00 }), 0);
        rs.insertRow();


        rs.moveToInsertRow();
        rs.updateInt("ID", 2);
        rs.updateString("NAME", "+");

View Full Code Here

        rs.updateLong("L", Long.MAX_VALUE);
        rs.updateObject("O_I", 10);
        rs.updateShort("SH", Short.MIN_VALUE);
        // auml, ouml, uuml
        rs.updateCharacterStream("CL", new StringReader("\u00ef\u00f6\u00fc"), 0);
        rs.updateBinaryStream("BL", new ByteArrayInputStream(new byte[] { (byte) 0xab, 0x12 }), 0);
        rs.insertRow();


        rs = stat.executeQuery("SELECT * FROM TEST ORDER BY ID NULLS FIRST");
        rs.next();
        assertTrue(rs.getInt(1) == 0);

View Full Code Here

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

View Full Code Here

   public void updateBinaryStream(int columnIndex, InputStream x) throws SQLException
   {
      ResultSet resultSet = getUnderlyingResultSet();
      try
      {
         resultSet.updateBinaryStream(columnIndex, x);
      }
      catch (Throwable t)
      {
         throw checkException(t);
      }

View Full Code Here

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

View Full Code Here

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

View Full Code Here


      /* move to insertRow */
      updRs.moveToInsertRow();


      /* update the table */
      updRs.updateBinaryStream("field1", new ByteArrayInputStream(
          streamData), streamLength);


      updRs.insertRow();
    } finally {
      this.stmt.executeUpdate("DROP TABLE IF EXISTS updateStreamTest");

View Full Code Here


      /* move to insertRow */
      updRs.moveToInsertRow();


      /* update the table */
      updRs.updateBinaryStream("field1", new ByteArrayInputStream(
          streamData), streamLength);


      updRs.insertRow();
    } finally {
      this.stmt.executeUpdate("DROP TABLE IF EXISTS updateStreamTest");

View Full Code Here

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


        ResultSet rs1 = fetchUpd("dLongBit", key);
        rs1.next();
        rs1.updateBinaryStream(1,is_for_update,(int)BYTES2.length);
        rs1.updateRow();
        rs1.close();


        //Query to see whether the data that has been updated
        //using the updateBinaryStream 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("dLongBit", key);
        rs1.next();
        rs1.updateBinaryStream("dLongBit",is_for_update,(int)BYTES2.length);
        rs1.updateRow();
        rs1.close();


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

View Full Code Here

0 1 2 3 4 5

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.