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

                    " at position " + pos + ",row " + i);
                else
                    System.out.println("Failed: Found unicode string " + arrayIndex +
                    " at position " + pos + ",row " + i);


                pos = clob.position(unicodeStrings[arrayIndex],4000);
                if (pos == 5004 || (pos == -1 && clobLength < 4000))
                    System.out.println("Succeeded: Found unicode string " + arrayIndex +
                    " at position " + pos + ",row " + i);
                else
                    System.out.println("Failed: Found unicode string " + arrayIndex +

View Full Code Here

                TestUtil.dumpSQLExceptions(e, isOutOfBoundException(e));
            }
            // 0 or negative position value
            try
            {
                clob.position("xx",-4000);
        System.out.println("FAIL = position('xx',-4000)");
            }
            catch (SQLException e)
            {
                TestUtil.dumpSQLExceptions(e, isOutOfBoundException(e));

View Full Code Here

                TestUtil.dumpSQLExceptions(e, isOutOfBoundException(e));
            }
            // null pattern
            try
            {
                clob.position((String) null,5);
        System.out.println("FAIL = position((String) null,5)");
            }
            catch (SQLException e)
            {
                TestUtil.dumpSQLExceptions(e, "XJ072".equals(e.getSQLState()));

View Full Code Here

                TestUtil.dumpSQLExceptions(e, "XJ072".equals(e.getSQLState()));
            }
            // 0 or negative position value
            try
            {
                clob.position(clob,-42);
        System.out.println("FAIL = position(clob,-42)");
            }
            catch (SQLException e)
            {
                TestUtil.dumpSQLExceptions(e, isOutOfBoundException(e));

View Full Code Here

                TestUtil.dumpSQLExceptions(e, isOutOfBoundException(e));
            }
            // null pattern
            try
            {
                clob.position((Clob) null,5);
        System.out.println("FAIL = pposition((Clob) null,5)");
            }
            catch (SQLException e)
            {
                TestUtil.dumpSQLExceptions(e, "XJ072".equals(e.getSQLState()));

View Full Code Here

            {
          TestUtil.dumpSQLExceptions(e);
        }
            try
            {
                clob.position("foo",2);
            }
            catch (SQLException e)
            {
          TestUtil.dumpSQLExceptions(e);
        }

View Full Code Here

            {
          TestUtil.dumpSQLExceptions(e);
        }
            try
            {
                clob.position(clob,2);
            }
            catch (SQLException e)
            {
          TestUtil.dumpSQLExceptions(e);
        }

View Full Code Here

        else
          TestUtil.dumpSQLExceptions(e);
        }
            try
            {
                clob.position("foo",2);
            }
            catch (SQLException e)
            {
        if (isDerbyNet)
          System.out.println("EXPECTED SQL Exception: " + e.getMessage());

View Full Code Here

        else
          TestUtil.dumpSQLExceptions(e);
        }
            try
            {
                clob.position(clob,2);
            }
            catch (SQLException e)
            {
        
        if (isDerbyNet)

View Full Code Here

    ps = conn.prepareStatement("SELECT ID, DATA FROM blobtest WHERE ID = 1");
    rs = ps.executeQuery();


    assertTrue(rs.next());
    c = rs.getClob("DATA");
    long position = c.position(pattern, 1);
    String rspData = c.getSubString(position, pattern.length());
    assertEquals("Request should be the same as the response", pattern, rspData);


    rs.close();
    ps.close();

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.