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

        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

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

        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

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

                        rs.updateString(ColumnNames[sqlType-1], 
                                rs1.getString(updateXXXName));
                } else if (updateXXXName == 8) { 
                    //update column with updateAsciiStream methods
                    if (indexOrName == 1) //test by passing column position
                        rs.updateAsciiStream(sqlType,
                                rs1.getAsciiStream(updateXXXName), 4);
                    else //test by passing column name
                        rs.updateAsciiStream(ColumnNames[sqlType-1],
                                rs1.getAsciiStream(updateXXXName), 4);
                } else if (updateXXXName == 9) {

View Full Code Here

                    //update column with updateAsciiStream methods
                    if (indexOrName == 1) //test by passing column position
                        rs.updateAsciiStream(sqlType,
                                rs1.getAsciiStream(updateXXXName), 4);
                    else //test by passing column name
                        rs.updateAsciiStream(ColumnNames[sqlType-1],
                                rs1.getAsciiStream(updateXXXName), 4);
                } else if (updateXXXName == 9) { 
                    //update column with updateCharacterStream methods
                    if (indexOrName == 1) //test by passing column position
                        rs.updateCharacterStream(sqlType,

View Full Code Here

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

View Full Code Here

   public void updateAsciiStream(int columnIndex, InputStream x) throws SQLException
   {
      ResultSet resultSet = getUnderlyingResultSet();
      try
      {
         resultSet.updateAsciiStream(columnIndex, x);
      }
      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.