com.oceanbase.jdbc

类 Clob

java.lang.Object

com.oceanbase.jdbc.Lob

com.oceanbase.jdbc.Clob

所有已实现的接口:

Serializable, Clob

直接已知子类:

JDBC4NClob

public class Clob
extends Lob
implements Clob

另请参阅:

序列化表格

字段概要

从类继承的字段 com.oceanbase.jdbc.Lob

charData, data, DBMS_LOB_MAX_AMOUNT, encoding, exceptionInterceptor, isOracleMode, length, lengthFromServer, locator, offset

构造器概要

构造器

构造器和说明
Clob() Creates an empty Clob.
Clob(boolean hasLocator, byte[] data, String encoding, OceanBaseConnection conn)
Clob(byte[] bytes) Creates a Clob with content.
Clob(byte[] bytes, ExceptionInterceptor exceptionInterceptor)
Clob(byte[] bytes, int offset, int length) Creates a Clob with content.
Clob(String charDataInit, ExceptionInterceptor exceptionInterceptor)

方法概要

限定符和类型	方法和说明
InputStream	getAsciiStream()
Reader	getCharacterStream()
Reader	getCharacterStream(long pos, long length) Returns a Reader object that contains a partial Clob value, starting with the character specified by pos, which is length characters in length.
static Clob	getEmptyCLOB()
String	getSubString(long pos, int length) Get sub string.
long	length() Return character length of the Clob.
long	position(Clob searchStr, long start)
long	position(String searchStr, long start)
protected void	readFromServer() Read Clob object by the DBMS_LOB.READ(lob_loc, amount, offset, buffer).
OutputStream	setAsciiStream(long pos)
Writer	setCharacterStream(long pos) Set character stream.
int	setString(long pos, String str) Set String.
int	setString(long pos, String str, int offset, int len)
String	toString() ToString implementation.
void	truncate(long truncateLen)

从类继承的方法 com.oceanbase.jdbc.Lob

buildObLobLocatorV1, buildObLobLocatorV2, clearData, copy, free, getBinaryStream, getBinaryStream, getBytes, getLocator, isEmptyLob, setBinaryStream, setBytes

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

从接口继承的方法 java.sql.Clob

free

构造器详细资料

Clob

public Clob(byte[] bytes)

Creates a Clob with content.

参数:

bytes - the content for the Clob.

Clob

public Clob(byte[] bytes,
            ExceptionInterceptor exceptionInterceptor)

Clob

public Clob(byte[] bytes,
            int offset,
            int length)

Creates a Clob with content.

参数:

bytes - the content for the Clob.

offset - offset

length - length

Clob

public Clob(String charDataInit,
            ExceptionInterceptor exceptionInterceptor)

Clob

public Clob(boolean hasLocator,
            byte[] data,
            String encoding,
            OceanBaseConnection conn)
     throws SQLException

抛出:

SQLException

Clob

public Clob()

Creates an empty Clob.

方法详细资料

getEmptyCLOB

public static Clob getEmptyCLOB()
                         throws SQLException

抛出:

SQLException

toString

public String toString()

ToString implementation.

覆盖:

toString 在类中 Object

返回:

string value of blob content.

getSubString

public String getSubString(long pos,
                           int length)
                    throws SQLException

Get sub string.

指定者:

getSubString 在接口中 Clob

参数:

pos - position

length - length of sub string

返回:

substring

抛出:

SQLException - if pos is less than 1 or length is less than 0

getCharacterStream

public Reader getCharacterStream()
                          throws SQLException

指定者:

getCharacterStream 在接口中 Clob

抛出:

SQLException

getCharacterStream

public Reader getCharacterStream(long pos,
                                 long length)
                          throws SQLException

Returns a Reader object that contains a partial Clob value, starting with the character specified by pos, which is length characters in length.

指定者:

getCharacterStream 在接口中 Clob

参数:

pos - the offset to the first character of the partial value to be retrieved. The first character in the Clob is at position 1.

length - the length in characters of the partial value to be retrieved.

返回:

Reader through which the partial Clob value can be read.

抛出:

SQLException - if pos is less than 1 or if pos is greater than the number of characters in the Clob or if pos + length is greater than the number of characters in the Clob

setCharacterStream

public Writer setCharacterStream(long pos)
                          throws SQLException

Set character stream.

指定者:

setCharacterStream 在接口中 Clob

参数:

pos - position

返回:

writer

抛出:

SQLException - if position is invalid

getAsciiStream

public InputStream getAsciiStream()
                           throws SQLException

指定者:

getAsciiStream 在接口中 Clob

抛出:

SQLException

position

public long position(String searchStr,
                     long start)
              throws SQLException

指定者:

position 在接口中 Clob

抛出:

SQLException

position

public long position(Clob searchStr,
                     long start)
              throws SQLException

指定者:

position 在接口中 Clob

抛出:

SQLException

setString

public int setString(long pos,
                     String str)
              throws SQLException

Set String.

指定者:

setString 在接口中 Clob

参数:

pos - position

str - string

返回:

string length

抛出:

SQLException - if UTF-8 conversion failed

setString

public int setString(long pos,
                     String str,
                     int offset,
                     int len)
              throws SQLException

指定者:

setString 在接口中 Clob

抛出:

SQLException

setAsciiStream

public OutputStream setAsciiStream(long pos)
                            throws SQLException

指定者:

setAsciiStream 在接口中 Clob

抛出:

SQLException

length

public long length()
            throws SQLException

Return character length of the Clob. Assume UTF8 encoding.

指定者:

length 在接口中 Clob

抛出:

SQLException

truncate

public void truncate(long truncateLen)
              throws SQLException

指定者:

truncate 在接口中 Clob

抛出:

SQLException

readFromServer

protected void readFromServer()
                       throws SQLException

Read Clob object by the DBMS_LOB.READ(lob_loc, amount, offset, buffer). DBMS_LOB.READ ( lob_loc IN CLOB CHARACTER SET ANY_CS, amount IN OUT NOCOPY INTEGER, offset IN INTEGER, buffer OUT VARCHAR2 CHARACTER SET lob_loc%CHARSET); lob_loc: Locator for the LOB to be read. For more information, see Operational Notes. file_loc: The file locator for the LOB to be examined. amount: Number of bytes (for BLOBs) or characters (for CLOBs) to read, or number that were read. offset: Offset in bytes (for BLOBs) or characters (for CLOBs) from the start of the LOB (origin: 1). buffer: Output buffer for the read operation.

指定者:

readFromServer 在类中 Lob

抛出:

SQLException - if database READ procedure exceptions occur INVALID_ARGVAL: amount is less than 1, or amount is larger than 32767 bytes (or the character equivalent) offset is less than 1, or offset is larger than LOBMAXSIZE amount is greater, in bytes or characters, than the capacity of buffer. NO_DATA_FOUND: End of the LOB is reached, and there are no more bytes or characters to read from the LOB: amount has a value of 0.