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

        ps_sb.close();


        //Update operation
        ResultSet rs1 = fetchUpd("dLongBit", key);
        rs1.next();
        rs1.updateBinaryStream(1, is2);
        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

        ps_sb.close();


        //Update operation
        ResultSet rs1 = fetchUpd("dBlob", key);
        rs1.next();
        rs1.updateBinaryStream(1, is2);
        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

        ps_sb.close();


        //Update operation
        ResultSet rs1 = fetchUpd("dLongBit", key);
        rs1.next();
        rs1.updateBinaryStream("dLongBit", is2);
        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


      /* 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

                        rs.updateBytes(ColumnNames[sqlType-1],
                                rs1.getBytes(updateXXXName));
                } else if (updateXXXName == 12) { 
                    //update column with updateBinaryStream methods
                    if (indexOrName == 1) //test by passing column position
                        rs.updateBinaryStream(sqlType,
                                rs1.getBinaryStream(updateXXXName), 2);
                    else //test by passing column name
                        rs.updateBinaryStream(ColumnNames[sqlType-1],
                                rs1.getBinaryStream(updateXXXName), 2);
                } else if (updateXXXName == 13) {

View Full Code Here

                    //update column with updateBinaryStream methods
                    if (indexOrName == 1) //test by passing column position
                        rs.updateBinaryStream(sqlType,
                                rs1.getBinaryStream(updateXXXName), 2);
                    else //test by passing column name
                        rs.updateBinaryStream(ColumnNames[sqlType-1],
                                rs1.getBinaryStream(updateXXXName), 2);
                } else if (updateXXXName == 13) { 
                    //update column with updateClob methods
                    //Don't test this method because running JDK1.3 and this jvm
                    //does not support the method

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

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.