Overview

Package

Class

Use

Tree

Deprecated

Index

Help

Java Platform 1.2
Beta 4

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: INNER | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

Interface java.sql.Clob

public abstract interface Clob

JDBC 2.0

By default, a Clob is a transaction duration reference to a character large object.

Method Summary

InputStream	getAsciiStream() Get the Clob contents as an ascii stream.
Reader	getCharacterStream() Get the Clob contents as a Unicode stream.
String	getSubString(long pos, int length) Return copy of the substring of the CLOB at the requested position.
long	length() The length of the Character Large Object in characters.
long	position(Clob searchstr, long start) Determine the character position at which the given substring
long	position(String searchstr, long start) Determine the character position at which the given substring

Method Detail

length

public long length()
            throws SQLException

The length of the Character Large Object in characters.

Returns:

length of the CLOB in characters

getSubString

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

Return copy of the substring of the CLOB at the requested position.

Parameters:

pos - is the first character of the substring to be extracted.

length - is the number of consecutive character to be copied.

Returns:

a byte array containing a substring of the CLOB

getCharacterStream

public Reader getCharacterStream()
                          throws SQLException

Get the Clob contents as a Unicode stream.

Returns:

a Unicode stream containing the CLOB data

getAsciiStream

public InputStream getAsciiStream()
                           throws SQLException

Get the Clob contents as an ascii stream.

Returns:

an ascii stream containing the CLOB data

position

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

Determine the character position at which the given substring

Parameters:

searchstr - is the substring to search for.

start - is the position at which to begin searching.

Returns:

the position at which the substring appears, else -1.

position

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

Determine the character position at which the given substring

Parameters:

searchstr - is the substring to search for.

start - is the position at which to begin searching.

Returns:

the position at which the substring appears, else -1.