Examples of org.hsqldb.jdbc.jdbcBlob

org.hsqldb.jdbc.JDBCBlob
The representation (mapping) in the Java^TM programming language of an SQL BLOB value. An SQL BLOB is a built-in type that stores a Binary Large Object as a column value in a row of a database table. By default drivers implement Blob using an SQL locator(BLOB), which means that a Blob object contains a logical pointer to the SQL BLOB data rather than the data itself. A Blob object is valid for the duration of the transaction in which is was created.
Methods in the interfaces {@link java.sql.ResultSet}, {@link java.sql.CallableStatement}, and {@link java.sql.PreparedStatement}, such as getBlob and setBlob allow a programmer to access an SQL BLOB value. The Blob interface provides methods for getting the length of an SQL BLOB (Binary Large Object) value, for materializing a BLOB value on the client, and for determining the position of a pattern of bytes within a BLOB value. In addition, this interface has methods for updating a BLOB value.
All methods on the Blob 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 Blob using an SQL locator(BLOB). That is, an HSQLDB Blob object did not contain a logical pointer to SQL BLOB data; rather it directly contained a representation of the data (a byte array). As a result, an HSQLDB Blob 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 BLOB 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 BLOB data implementations, meaning that an HSQLDB Blob object may contain a logical pointer to remote SQL BLOB data (see {@link JDBCBlobClient JDBCBlobClient}) 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 Blob instance is constructed as a result of calling JDBCConnection.createBlob(), then the resulting Blob 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 BLOB value are supported for local use until the first invocation of free(); otherwise, an HSQLDB Blob'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 james house jhouse@part.net @author boucherb@users @version 2.0 @since JDK 1.2, HSQLDB 1.7.2 @revised JDK 1.6, HSQLDB 2.0

    }


    public void insertB(byte[] id) throws Exception {


        try {
            insertStmtB.setBlob(1, new JDBCBlob(data));
            insertStmtB.setBytes(2, id);
            insertStmtB.execute();
        } finally {
            insertStmtB.clearParameters();
            insertStmtB.clearWarnings();

View Full Code Here

            String            dql0 = "select * from blobtest;";
            PreparedStatement ps   = connection.prepareStatement(dml0);
            byte[]            data = new byte[] {
                1, 2, 3, 4, 5, 6, 7, 8, 9, 10
            };
            Blob              blob = new JDBCBlob(data);


            ps.setBlob(1, blob);
            ps.executeUpdate();


            data[4] = 50;
            blob    = new JDBCBlob(data);


            ps.setBlob(1, blob);
            ps.executeUpdate();
            ps.close();

View Full Code Here

public class OnDBWriteContent implements OnJPAWriteContent {


  @Override
  public Blob getJPABlob(final byte[] binaryData) throws ODataJPARuntimeException {
    try {
      return new JDBCBlob(binaryData);
    } catch (SerialException e) {
      ODataJPARuntimeException.throwException(ODataJPARuntimeException.INNER_EXCEPTION, e);
    } catch (SQLException e) {
      ODataJPARuntimeException.throwException(ODataJPARuntimeException.INNER_EXCEPTION, e);
    }

View Full Code Here

  public Blob convertToEntityAttribute(final byte[] arg0) {
    try {
      if (arg0 == null) {
        return null;
      }
      return new JDBCBlob(arg0);
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return null;
  }

View Full Code Here

            String            dql0 = "select * from blobtest;";
            PreparedStatement ps   = connection.prepareStatement(dml0);
            byte[]            data = new byte[] {
                1, 2, 3, 4, 5, 6, 7, 8, 9, 10
            };
            Blob              blob = new JDBCBlob(data);


            ps.setBlob(1, blob);
            ps.executeUpdate();


            data[4] = 50;
            blob    = new JDBCBlob(data);


            ps.setBlob(1, blob);
            ps.executeUpdate();
            ps.close();

View Full Code Here

            blob.setBytes(1, data);
            ps.setBlob(1, blob);
            ps.executeUpdate();


            data[4] = 50;
            blob    = new JDBCBlob(data);


            ps.setBlob(1, blob);
            ps.executeUpdate();
            ps.close();
            connection.commit();

View Full Code Here

        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 {
          throw new SQLException("Attribute 'payload' of class WebSocketMessageDTO has got wrong type!");
        }
        
        psInsertMessage.setInt(7, message.payloadLength);

View Full Code Here

    }


    public void insertB(byte[] id) throws Exception {


        try {
            insertStmtB.setBlob(1, new JDBCBlob(data));
            insertStmtB.setBytes(2, id);
            insertStmtB.execute();
        } finally {
            insertStmtB.clearParameters();
            insertStmtB.clearWarnings();

View Full Code Here

            String            dql0 = "select * from blobtest;";
            PreparedStatement ps   = connection.prepareStatement(dml0);
            byte[]            data = new byte[] {
                1, 2, 3, 4, 5, 6, 7, 8, 9, 10
            };
            Blob              blob = new JDBCBlob(data);


            ps.setBlob(1, blob);
            ps.executeUpdate();


            data[4] = 50;
            blob    = new JDBCBlob(data);


            ps.setBlob(1, blob);
            ps.executeUpdate();
            ps.close();

View Full Code Here


            ps.setBlob(1, blob);
            ps.executeUpdate();


            data[4] = 50;
            blob    = new JDBCBlob(data);


            ps.setBlob(1, blob);
            ps.executeUpdate();
            ps.close();

View Full Code Here

TOP

Related Classes of org.hsqldb.jdbc.jdbcBlob

org.apache.olingo.odata2.jpa.processor.ref.converter.BlobToByteConverter

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

org.hsqldb.test.TestLobs

org.hsqldb.test.TestStressInsert

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

java.io.ByteArrayInputStream

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.jdbcBlob

HSQLDB-Specific Information:

Related Classes of org.hsqldb.jdbc.jdbcBlob