Examples of java.sql.Clob.position()

java.sql.Clob.position()
Retrieves the character position at which a specified Clob object appears in this Clob object. @param searchstr the specified Clob to search for @param start the position within this Clob to start the search @return a long value with the position at which the specified Clob occurswithin this Clob. @throws SQLException if an error occurs accessing the Clob

            rs = stmt.executeQuery("SELECT ID, DATA FROM T_CLOB");
            rs.getStatement(); // just call
            while (rs.next()) {
                Clob readClob = rs.getClob(2);
                readClob.length();
                readClob.position("abc", 1);
                readClob.getCharacterStream().close();
                readClob.getAsciiStream().close();
                readClob.getCharacterStream(1, 1).close();
                readClob.getSubString(1, 2);
                readClob.truncate(2);

View Full Code Here

            rs = stmt.executeQuery("SELECT ID, DATA FROM T_CLOB");
            while (rs.next()) {
                Clob searchstr = conn.createClob();
                searchstr.setString(1, "AB");
                Clob x = rs.getClob("DATA");
                x.position(searchstr, 1);
                x.free();
            }
            JdbcUtils.close(rs);


            rs = stmt.executeQuery("SELECT ID, DATA FROM T_CLOB");

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.