|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--oracle.sql.Datum | +--oracle.sql.CLOB
Field Summary | |
static int |
DURATION_CALL
|
static int |
DURATION_SESSION
|
static int |
MAX_CHUNK_SIZE
|
static int |
MODE_READONLY
|
static int |
MODE_READWRITE
|
Constructor Summary | |
CLOB(OracleConnection conn,
byte[] lob_descriptor,
short csform)
|
Method Summary | |
void |
close()
Close a previously opened CLOB. |
static CLOB |
createTemporary(java.sql.Connection conn,
boolean cache,
int duration)
Create a temporary clob. |
static CLOB |
empty_lob()
Return a empty lob. |
void |
freeTemporary()
Free the contents and the locator of the temporary clob. |
static void |
freeTemporary(CLOB temp_lob)
Free the contents and the locator of the temporary clob. |
java.io.OutputStream |
getAsciiOutputStream()
Oracle extension. |
java.io.OutputStream |
getAsciiOutputStream(long pos)
Write to the CLOB from a stream at the requested position. |
java.io.InputStream |
getAsciiStream()
Implements the Clob interface method. |
java.io.InputStream |
getAsciiStream(long pos)
Read from the CLOB as a stream at the requested position. |
int |
getBufferSize()
Oracle extension. |
java.io.Writer |
getCharacterOutputStream()
Oracle extension. |
java.io.Writer |
getCharacterOutputStream(long pos)
Write to the CLOB from a stream at the requested position. |
java.io.Reader |
getCharacterStream()
Implements the Clob interface method. |
java.io.Reader |
getCharacterStream(long pos)
Read from the CLOB as a stream at the requested position. |
int |
getChars(long pos,
int length,
char[] buffer)
Oracle extension. |
int |
getChunkSize()
Oracle extension. |
OracleConnection |
getConnection()
Deprecated. since 9.0.0. Use getJavaSqlConnection() instead. |
java.sql.Connection |
getJavaSqlConnection()
Oracle extension Return the java.sql.Connection associated with the receiver. |
java.lang.String |
getSubString(long pos,
int length)
Implements the Clob interface method. |
boolean |
isConvertibleTo(java.lang.Class jClass)
Test whether this data object can be converted to the specified Java data type. |
boolean |
isEmptyLob()
Return true if this is a empty lob. |
boolean |
isNCLOB()
|
boolean |
isOpen()
Check whether the CLOB is opened. |
boolean |
isTemporary()
Return true if the lob locator points to a temporary clob. |
static boolean |
isTemporary(CLOB lob)
Return true if the lob locator points to a temporary clob. |
long |
length()
Implements the Clob interface method. |
void |
open(int mode)
Open a CLOB in the indicated mode. |
long |
position(java.sql.Clob searchstr,
long start)
Implements the Clob interface method. |
long |
position(java.lang.String searchstr,
long start)
Implements the Clob interface method. |
int |
putChars(long pos,
char[] chars)
Oracle extension. |
int |
putString(long pos,
java.lang.String str)
Oracle extension. |
java.lang.Object |
toJdbc()
Convert this data object into its default Java object type. |
void |
trim(long newlen)
Trim the value of the CLOB to the length you specify in the newlen parameter. |
Methods inherited from class oracle.sql.Datum |
asciiStreamValue,
bigDecimalValue,
binaryStreamValue,
booleanValue,
byteValue,
characterStreamValue,
dateValue,
doubleValue,
equals,
floatValue,
getBytes,
getLength,
getStream,
intValue,
longValue,
makeJdbcArray,
setBytes,
setShareBytes,
shareBytes,
stringValue,
timestampValue,
timeValue |
Methods inherited from class java.lang.Object |
getClass,
hashCode,
notify,
notifyAll,
toString,
wait,
wait,
wait |
Field Detail |
public static final int MAX_CHUNK_SIZE
public static final int DURATION_SESSION
public static final int DURATION_CALL
public static final int MODE_READONLY
public static final int MODE_READWRITE
Constructor Detail |
public CLOB(OracleConnection conn, byte[] lob_descriptor, short csform) throws java.sql.SQLException
Method Detail |
public boolean isNCLOB()
public long length() throws java.sql.SQLException
CLOB
value
designated by this Clob
object.CLOB
in charactersCLOB
public java.lang.String getSubString(long pos, int length) throws java.sql.SQLException
CLOB
value
designated by this Clob
object.
The substring begins at position
pos
and has up to length
consecutive
characters.pos
- the first character of the substring to be extracted.
The first character is at position 1.length
- the number of consecutive characters to be copiedString
that is the specified substring in
the CLOB
value designated by this Clob
ob
jectCLOB
public java.io.Reader getCharacterStream() throws java.sql.SQLException
Clob
contents as a Unicode stream.CLOB
dataCLOB
public java.io.InputStream getAsciiStream() throws java.sql.SQLException
CLOB
value designated by this Clob
object as a stream of Ascii bytes.CLOB
dataCLOB
valuepublic long position(java.lang.String searchstr, long start) throws java.sql.SQLException
searchstr
- is the substring to search for.start
- is the position at which to begin searching.public long position(java.sql.Clob searchstr, long start) throws java.sql.SQLException
searchstr
- is the substring to search for.start
- is the position at which to begin searching.public int getChars(long pos, int length, char[] buffer) throws java.sql.SQLException
buffer
- is the buffer into whcih the characters are read.pos
- is the first character of the substring to be extracted.length
- is the number of consecutive character to be copied.public java.io.Writer getCharacterOutputStream() throws java.sql.SQLException
public java.io.OutputStream getAsciiOutputStream() throws java.sql.SQLException
public java.sql.Connection getJavaSqlConnection() throws java.sql.SQLException
public OracleConnection getConnection() throws java.sql.SQLException
getJavaSqlConnection()
instead.public int putChars(long pos, char[] chars) throws java.sql.SQLException
pos
- is the position to write characters.chars
- is the buffer of characters to be written.public int putString(long pos, java.lang.String str) throws java.sql.SQLException
pos
- is the position to write characters.str
- is the Java string to be written.public int getChunkSize() throws java.sql.SQLException
public int getBufferSize() throws java.sql.SQLException
public static CLOB empty_lob() throws java.sql.SQLException
public boolean isEmptyLob() throws java.sql.SQLException
empty_lob
public java.io.OutputStream getAsciiOutputStream(long pos) throws java.sql.SQLException
pos
- is the position data to be put.public java.io.Writer getCharacterOutputStream(long pos) throws java.sql.SQLException
pos
- is the position data to be put.public java.io.InputStream getAsciiStream(long pos) throws java.sql.SQLException
pos
- is the position data to be put.public java.io.Reader getCharacterStream(long pos) throws java.sql.SQLException
pos
- is the position data to be put.public void trim(long newlen) throws java.sql.SQLException
newlen
- the new length of the CLOB.public static CLOB createTemporary(java.sql.Connection conn, boolean cache, int duration) throws java.sql.SQLException
cache
- Specifies if LOB should be read into buffer cache or not.duration
- The duration of the temporary LOB. The following are
valid values: DURATION_SESSION, DURATION_CALL.public static void freeTemporary(CLOB temp_lob) throws java.sql.SQLException
temp_lob
- A temporary clob to be freeed.public static boolean isTemporary(CLOB lob) throws java.sql.SQLException
lob
- the clob to test.public void freeTemporary() throws java.sql.SQLException
public boolean isTemporary() throws java.sql.SQLException
public void open(int mode) throws java.sql.SQLException
public void close() throws java.sql.SQLException
public boolean isOpen() throws java.sql.SQLException
public java.lang.Object toJdbc() throws java.sql.SQLException
public boolean isConvertibleTo(java.lang.Class jClass)
jClass
- specifies the Java data type to test against.
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |