Examples of java.sql.ResultSet.updateBlob()

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

            if (spy)
                spyLogger.debugf("%s [%s] updateBlob(%s, %s)",
                        jndiName, Constants.SPY_LOGGER_PREFIX_RESULTSET,
                        columnLabel, inputStream);


            resultSet.updateBlob(columnLabel, inputStream);
        } catch (Throwable t) {
            throw checkException(t);
        }
    }

View Full Code Here

            }
            Blob blob = res.getBlob(1);
            OutputStream os = blob.setBinaryStream(1);
            copy(is, os);
            os.close();
            res.updateBlob(1, blob);
            res.updateRow();


        } catch (IOException ioe) {
            throw new StoreException(ioe);
        } finally {

View Full Code Here

            }
            Blob blob = res.getBlob(1);
            OutputStream os = blob.setBinaryStream(1);
            copy(is, os);
            os.close();
            res.updateBlob(1, blob);
            res.updateRow();


        } catch (IOException ioe) {
            throw new StoreException(ioe);
        } finally {

View Full Code Here


            // Update the blob
            Blob blob = rs.getBlob(1);
            blob.truncate(0);
            blob.setBytes(1, data);
            rs.updateBlob(1, blob);
            rs.updateRow();             // Update the row with the updated blob
        } finally {
            close(rs);
            close(s);
        }

View Full Code Here


            rs = stmt.executeQuery("SELECT ID, DATA FROM T_BLOB");
            while (rs.next()) {
                Blob x = conn.createBlob();
                x.setBytes(1, new byte[100]);
                rs.updateBlob(2, x);
            }
            JdbcUtils.close(rs);


            rs = stmt.executeQuery("SELECT ID, DATA FROM T_BLOB");
            while (rs.next()) {

View Full Code Here


            rs = stmt.executeQuery("SELECT ID, DATA FROM T_BLOB");
            while (rs.next()) {
                Blob x = conn.createBlob();
                x.setBytes(1, new byte[100]);
                rs.updateBlob("DATA", x);
            }
            JdbcUtils.close(rs);


            rs = stmt.executeQuery("SELECT ID, DATA FROM T_BLOB");
            while (rs.next()) {

View Full Code Here

            }
            JdbcUtils.close(rs);


            rs = stmt.executeQuery("SELECT ID, DATA FROM T_BLOB");
            while (rs.next()) {
                rs.updateBlob("DATA", new ByteArrayInputStream(new byte[100]));
            }
            JdbcUtils.close(rs);


            rs = stmt.executeQuery("SELECT ID, DATA FROM T_BLOB");
            while (rs.next()) {

View Full Code Here

            }
            JdbcUtils.close(rs);


            rs = stmt.executeQuery("SELECT ID, DATA FROM T_BLOB");
            while (rs.next()) {
                rs.updateBlob(2, new ByteArrayInputStream(new byte[100]));
            }


            rs = stmt.executeQuery("SELECT ID, DATA FROM T_BLOB");
            while (rs.next()) {
                rs.updateBlob("DATA", new ByteArrayInputStream(new byte[100]), 100);

View Full Code Here

                rs.updateBlob(2, new ByteArrayInputStream(new byte[100]));
            }


            rs = stmt.executeQuery("SELECT ID, DATA FROM T_BLOB");
            while (rs.next()) {
                rs.updateBlob("DATA", new ByteArrayInputStream(new byte[100]), 100);
            }
            JdbcUtils.close(rs);


            rs = stmt.executeQuery("SELECT ID, DATA FROM T_BLOB");
            while (rs.next()) {

View Full Code Here

            }
            JdbcUtils.close(rs);


            rs = stmt.executeQuery("SELECT ID, DATA FROM T_BLOB");
            while (rs.next()) {
                rs.updateBlob(2, new ByteArrayInputStream(new byte[100]), 100);
            }
            JdbcUtils.close(rs);
        } finally {
            JdbcUtils.close(rs);
            JdbcUtils.close(stmt);

View Full Code Here

0 1 2 3 4 5 6 7

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.