User guide

Chapter 9
9.1
The maximum size of a blob segment supported by Oracle Rdb today is 65535. The Oracle
JDBC for Rdb drivers will correctly handle segments up to this maximum size.
To enable limited formatting of data returned from Oracle Rdb segmented strings, a new
public method has been added to oracle.jdbc.rdb.common.Blob that allows the specification
of a separator string value to be inserted between segments when the segmented string is
converted to a JDBC blob object.
Format
public void oracle.jdbc.rdb.common.Blob.setSegSeparator(java.lang.String
separator)
Returns:
JDBC Extensions for Oracle Rdb
The following sections provide information on features that are extensions to the JDBC
standard provided by Oracle JDBC for Rdb.
Enhanced Blob Handling
There is no limit on the number of segments that can be stored for a single Blob, however, as
the drivers materialize the blob into internal byte arrays. The correct handling of very large
blobs in this version of the Oracle JDBC for Rdb drivers is limited to the free memory that is
available to the Java environment.
Specify the separator string to use between segmented string segments:
Parameters:
separator - separator string to use
Void
Example
The following code segment shows how to add a newline break between segments.
ResultSet rs = s.executeQuery(
"select resume from resumes where employee_id = '00164'");
rs.next();
oracle.jdbc.rdb.common.Blob bl =
(oracle.jdbc.rdb.common.Blob)rs.getBlob(1);
bl.setSegSeparator("\n");
141