Examples of org.hsqldb.jdbc.JDBCClob

org.hsqldb.jdbc.JDBCClob
The mapping in the Java^TM programming language for the SQL CLOB type. An SQL CLOB is a built-in type that stores a Character Large Object as a column value in a row of a database table. By default drivers implement a Clob object using an SQL locator(CLOB), which means that a Clob object contains a logical pointer to the SQL CLOB data rather than the data itself. A Clob object is valid for the duration of the transaction in which it was created.
The Clob interface provides methods for getting the length of an SQL CLOB (Character Large Object) value, for materializing a CLOB value on the client, and for searching for a substring or CLOB object within a CLOB value. Methods in the interfaces {@link java.sql.ResultSet}, {@link java.sql.CallableStatement}, and {@link java.sql.PreparedStatement}, such as getClob and setClob allow a programmer to access an SQL CLOB value. In addition, this interface has methods for updating a CLOB value.
All methods on the Clob interface must be fully implemented if the JDBC driver supports the data type.

HSQLDB-Specific Information:

Previous to 2.0, the HSQLDB driver did not implement Clob using an SQL locator(CLOB). That is, an HSQLDB Clob object did not contain a logical pointer to SQL CLOB data; rather it directly contained a representation of the data (a String). As a result, an HSQLDB Clob object was itself valid beyond the duration of the transaction in which is was created, although it did not necessarily represent a corresponding value on the database. Also, the interface methods for updating a CLOB value were unsupported, with the exception of the truncate method, in that it could be used to truncate the local value.
Starting with 2.0, the HSQLDB driver fully supports both local and remote SQL CLOB data implementations, meaning that an HSQLDB Clob object may contain a logical pointer to remote SQL CLOB data (see {@link JDBCClobClient JDBCClobClient}) or it may directly contain a local representation of the data (as implemented in this class). In particular, when the product is built under JDK 1.6+ and the Clob instance is constructed as a result of calling JDBCConnection.createClob(), then the resulting Clob instance is initially disconnected (is not bound to the tranaction scope of the vending Connection object), the data is contained directly and all interface methods for updating the CLOB value are supported for local use until the first invocation of free(); otherwise, an HSQLDB Clob's implementation is determined at runtime by the driver, it is typically not valid beyond the duration of the transaction in which is was created, and there no standard way to query whether it represents a local or remote value.

@author boucherb@users @version 2.0 @since JDK 1.2, HSQLDB 1.7.2 @revised JDK 1.6, HSQLDB 2.0

        try {
            String dml0 = "insert into clobtest(clobfield) values(?)";
            String            dql0 = "select * from clobtest;";
            PreparedStatement ps   = connection.prepareStatement(dml0);
            String            data = "Testing clob insert and select ops";
            Clob              clob = new JDBCClob(data);


            ps.setClob(1, clob);
            ps.executeUpdate();


            data = data.replaceFirst("insert", "INSERT");
            clob = new JDBCClob(data);


            ps.setClob(1, clob);
            ps.executeUpdate();
            ps.close();

View Full Code Here

        try {
            String dml0 = "insert into clobtest values(default, ?, ?, ?)";
            String            dql0 = "select * from clobtest;";
            PreparedStatement ps   = connection.prepareStatement(dml0);
            String            data = "Testing clob insert and select ops";
            Clob              clob = new JDBCClob(data);


            ps.setString(1, "test");
            ps.setInt(2, 5);
            ps.setClob(3, clob);
            ps.executeUpdate();


            data = data.replaceFirst("insert", "INSERT");
            clob = new JDBCClob(data);


            ps.setClob(3, clob);
            ps.executeUpdate();


            PreparedStatement ps2 = connection.prepareStatement(dql0);
            ResultSet         rs  = ps2.executeQuery();


            rs.next();


            Clob clob1 = rs.getClob(4);


            rs.next();


            Clob clob2 = rs.getClob(4);
            int data1 = clob1.getSubString(1, data.length()).indexOf("insert");
            int data2 = clob2.getSubString(1, data.length()).indexOf("INSERT");


            assertTrue(data1 == data2 && data1 > 0);


            //
            Clob   clob3  = new JDBCClob(data);
            Reader reader = clob3.getCharacterStream();


            ps.setCharacterStream(3, reader, (int) clob3.length());
            ps.executeUpdate();


            //
            reader = clob2.getCharacterStream();


            try {
                ps.setCharacterStream(3, reader, (int) clob3.length());
                assertTrue(false);
                ps.executeUpdate();
            } catch (SQLException e) {}


            connection.commit();

View Full Code Here

            PreparedStatement ps = connection.prepareStatement(dml0);


            connection.setAutoCommit(false);


            //
            JDBCClob dataClob =
                new JDBCClob("the quick brown fox jumps on the lazy dog");
            Reader    reader = null;
            StopWatch sw     = new StopWatch();


            sw.start();


            for (int i = 0; i < 1000; i++) {
                reader = dataClob.getCharacterStream();


                ps.setString(1, "test-id-1" + i);
                ps.setLong(2, 23456789123456L + i);
                ps.setCharacterStream(3, reader, dataClob.length());
                ps.setString(4, "test-scope-1" + i);
                ps.executeUpdate();
                connection.commit();
            }


            sw.stop();
            System.out.println(sw.elapsedTimeToMessage("Time for inserts"));


            ps = connection.prepareStatement(dml1);


            sw.zero();
            sw.start();


            for (int i = 100; i < 200; i++) {
                reader = dataClob.getCharacterStream();


                ps.setCharacterStream(1, reader, dataClob.length());
                ps.setString(2, "test-id-1" + i);
                ps.setLong(3, 23456789123456L + i);
                ps.setString(4, "test-scope-1" + i);
                ps.executeUpdate();
                connection.commit();

View Full Code Here

            PreparedStatement ps = connection.prepareStatement(dml0);


            connection.setAutoCommit(false);


            //
            JDBCClob dataClob =
                new JDBCClob("the quick brown fox jumps on the lazy dog");
            Reader    reader = null;
            StopWatch sw     = new StopWatch();


            sw.start();


            for (int i = 0; i < 100; i++) {
                reader = dataClob.getCharacterStream();


                ps.setString(1, "test-id-1" + i);
                ps.setLong(2, 23456789123456L + i);
                ps.setCharacterStream(3, reader, dataClob.length());
                ps.setString(4, "test-scope-1" + i);
                ps.executeUpdate();
                connection.commit();
            }


            sw.stop();
            System.out.println(sw.elapsedTimeToMessage("Time for inserts"));


            ps = connection.prepareStatement(dml1);


            sw.zero();
            sw.start();


            for (int i = 10; i < 20; i++) {
                ps.setString(1, "test-id-1" + i);
                ps.setLong(2, 23456789123456L + i);
                ps.setString(3, "test-scope-1" + i);
                ps.executeUpdate();
                connection.commit();
            }


            connection.commit();


            ResultSet rs = statement.executeQuery("SELECT * FROM VARIABLE");


            while (rs.next()) {
                Clob clob       = rs.getClob(4);
                long dataLength = dataClob.length();
                long clobLength = clob.length();


                assertTrue(dataLength == clobLength);
                assertTrue(
                    dataClob.getSubString(1, 30).equals(
                        clob.getSubString(1, 30)));
            }


            rs = statement.executeQuery(
                "SELECT CAST(SUBSTRING(VALUE FROM 19) AS VARCHAR(100)),STATEID,"

View Full Code Here

  }


  @Override
  public Clob getJPAClob(final char[] characterData) throws ODataJPARuntimeException {
    try {
      return new JDBCClob(new String(characterData));
    } catch (SQLException e) {
      ODataJPARuntimeException.throwException(ODataJPARuntimeException.INNER_EXCEPTION, e);
    }
    return null;
  }

View Full Code Here

        try {
            String dml0 = "insert into clobtest(clobfield) values(?)";
            String            dql0 = "select * from clobtest;";
            PreparedStatement ps   = connection.prepareStatement(dml0);
            String            data = "Testing clob insert and select ops";
            Clob              clob = new JDBCClob(data);


            ps.setClob(1, clob);
            ps.executeUpdate();


            data = data.replaceFirst("insert", "INSERT");
            clob = new JDBCClob(data);


            ps.setClob(1, clob);
            ps.executeUpdate();
            ps.close();

View Full Code Here

        try {
            String dml0 = "insert into clobtest values(default, ?, ?, ?)";
            String            dql0 = "select * from clobtest;";
            PreparedStatement ps   = connection.prepareStatement(dml0);
            String            data = "Testing clob insert and select ops";
            Clob              clob = new JDBCClob(data);


            ps.setString(1, "test");
            ps.setInt(2, 5);
            ps.setClob(3, clob);
            ps.executeUpdate();


            data = data.replaceFirst("insert", "INSERT");
            clob = new JDBCClob(data);


            ps.setClob(3, clob);
            ps.executeUpdate();


            PreparedStatement ps2 = connection.prepareStatement(dql0);
            ResultSet         rs  = ps2.executeQuery();


            rs.next();


            Clob clob1 = rs.getClob(4);


            rs.next();


            Clob clob2 = rs.getClob(4);
            int data1 = clob1.getSubString(1, data.length()).indexOf("insert");
            int data2 = clob2.getSubString(1, data.length()).indexOf("INSERT");


            assertTrue(data1 == data2 && data1 > 0);


            //
            Clob   clob3  = new JDBCClob(data);
            Reader reader = clob3.getCharacterStream();


            ps.setCharacterStream(3, reader, (int) clob3.length());
            ps.executeUpdate();


            //
            reader = clob2.getCharacterStream();


            try {
                ps.setCharacterStream(3, reader, (int) clob3.length());
                ps.executeUpdate();
            } catch (SQLException e) {}


            connection.commit();
        } catch (SQLException e) {

View Full Code Here

            PreparedStatement ps = connection.prepareStatement(dml0);


            connection.setAutoCommit(false);


            //
            JDBCClob dataClob =
                new JDBCClob("the quick brown fox jumps on the lazy dog");
            Reader    reader = null;
            StopWatch sw     = new StopWatch();


            sw.start();


            for (int i = 0; i < 1000; i++) {
                reader = dataClob.getCharacterStream();


                ps.setString(1, "test-id-1" + i);
                ps.setLong(2, 23456789123456L + i);
                ps.setCharacterStream(3, reader, dataClob.length());
                ps.setString(4, "test-scope-1" + i);
                ps.executeUpdate();
                connection.commit();
            }


            sw.stop();
            System.out.println(sw.elapsedTimeToMessage("Time for inserts"));


            ps = connection.prepareStatement(dml1);


            sw.zero();
            sw.start();


            for (int i = 100; i < 200; i++) {
                reader = dataClob.getCharacterStream();


                ps.setCharacterStream(1, reader, dataClob.length());
                ps.setString(2, "test-id-1" + i);
                ps.setLong(3, 23456789123456L + i);
                ps.setString(4, "test-scope-1" + i);
                ps.executeUpdate();
                connection.commit();

View Full Code Here

            PreparedStatement ps = connection.prepareStatement(dml0);


            connection.setAutoCommit(false);


            //
            JDBCClob dataClob =
                new JDBCClob("the quick brown fox jumps on the lazy dog");
            Reader    reader = null;
            StopWatch sw     = new StopWatch();


            sw.start();


            for (int i = 0; i < 100; i++) {
                reader = dataClob.getCharacterStream();


                ps.setString(1, "test-id-1" + i);
                ps.setLong(2, 23456789123456L + i);
                ps.setCharacterStream(3, reader, dataClob.length());
                ps.setString(4, "test-scope-1" + i);
                ps.executeUpdate();
                connection.commit();
            }


            sw.stop();
            System.out.println(sw.elapsedTimeToMessage("Time for inserts"));


            ps = connection.prepareStatement(dml1);


            sw.zero();
            sw.start();


            for (int i = 10; i < 20; i++) {
                ps.setString(1, "test-id-1" + i);
                ps.setLong(2, 23456789123456L + i);
                ps.setString(3, "test-scope-1" + i);
                ps.executeUpdate();
                connection.commit();
            }


            connection.commit();


            ResultSet rs = statement.executeQuery("SELECT * FROM VARIABLE");


            while (rs.next()) {
                Clob clob       = rs.getClob(4);
                long dataLength = dataClob.length();
                long clobLength = clob.length();


                assertTrue(dataLength == clobLength);
                assertTrue(
                    dataClob.getSubString(1, 30).equals(
                        clob.getSubString(1, 30)));
            }


            rs = statement.executeQuery(
                "SELECT CAST(SUBSTRING(VALUE FROM 19) AS VARCHAR(100)),STATEID,"

View Full Code Here

        psInsertMessage.setTimestamp(3, new Timestamp(message.timestamp));
        psInsertMessage.setInt(4, message.opcode);
  
        // write payload
        if (message.payload instanceof String) {
          psInsertMessage.setClob(5, new JDBCClob((String) message.payload));
          psInsertMessage.setNull(6, Types.BLOB);
        } else if (message.payload instanceof byte[]) {
          psInsertMessage.setNull(5, Types.CLOB);
          psInsertMessage.setBlob(6, new JDBCBlob((byte[]) message.payload));
        } else {

View Full Code Here

0 1

TOP

Related Classes of org.hsqldb.jdbc.JDBCClob

org.apache.olingo.odata2.jpa.processor.ref.extension.OnDBWriteContent

org.hsqldb.lib.AsciiStringInputStream

org.hsqldb.test.TestLobs

org.zaproxy.zap.extension.websocket.db.TableWebSocket

java.io.ByteArrayInputStream

java.io.StringReader

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.

Examples of org.hsqldb.jdbc.JDBCClob

HSQLDB-Specific Information:

Related Classes of org.hsqldb.jdbc.JDBCClob