org.postgresql.jdbc

Class PgClob

java.lang.Object

org.postgresql.jdbc.AbstractBlobClob

org.postgresql.jdbc.PgClob

All Implemented Interfaces:

Clob

public class PgClob
extends AbstractBlobClob
implements Clob

Field Summary

Fields inherited from class org.postgresql.jdbc.AbstractBlobClob

conn

Constructor Summary

Constructors

Constructor and Description
PgClob(BaseConnection conn, long oid)

Method Summary

Methods

Modifier and Type	Method and Description
InputStream	getAsciiStream() Retrieves the CLOB value designated by this Clob object as an ascii stream.
Reader	getCharacterStream() Retrieves the CLOB value designated by this Clob object as a java.io.Reader object (or as a stream of characters).
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.
String	getSubString(long i, int j) Retrieves a copy of the specified substring in the CLOB value designated by this Clob object.
long	position(Clob pattern, long start) This should be simply passing the byte value of the pattern Blob
long	position(String pattern, long start) For now, this is not implemented.
OutputStream	setAsciiStream(long pos) Retrieves a stream to be used to write Ascii characters to the CLOB value that this Clob object represents, starting at position pos.
Writer	setCharacterStream(long pos) Retrieves a stream to be used to write a stream of Unicode characters to the CLOB value that this Clob object represents, at position pos.
int	setString(long pos, String str) Writes the given Java String to the CLOB value that this Clob object designates at the position pos.
int	setString(long pos, String str, int offset, int len) Writes len characters of str, starting at character offset, to the CLOB value that this Clob represents.

Methods inherited from class org.postgresql.jdbc.AbstractBlobClob

addSubLO, assertPosition, assertPosition, checkFreed, free, getBinaryStream, getBytes, getLo, length, position, position, setBinaryStream, truncate

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.sql.Clob

free, length, truncate

Constructor Detail

PgClob

public PgClob(BaseConnection conn,
      long oid)
       throws SQLException

Throws:

SQLException

Method Detail

getCharacterStream

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

Description copied from interface: java.sql.Clob

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

Specified by:

getCharacterStream in interface Clob

Parameters:

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.

Returns:

Reader through which the partial Clob value can be read.

Throws:

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

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

setString

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

Description copied from interface: java.sql.Clob

Writes the given Java String to the CLOB value that this Clob object designates at the position pos. The string will overwrite the existing characters in the Clob object starting at the position pos. If the end of the Clob value is reached while writing the given string, then the length of the Clob value will be increased to accommodate the extra characters.

Note: If the value specified for pos is greater then the length+1 of the CLOB value then the behavior is undefined. Some JDBC drivers may throw a SQLException while other drivers may support this operation.

Specified by:

setString in interface Clob

Parameters:

pos - the position at which to start writing to the CLOB value that this Clob object represents; The first position is 1

str - the string to be written to the CLOB value that this Clob designates

Returns:

the number of characters written

Throws:

SQLException - if there is an error accessing the CLOB value or if pos is less than 1

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

setString

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

Description copied from interface: java.sql.Clob

Writes len characters of str, starting at character offset, to the CLOB value that this Clob represents. The string will overwrite the existing characters in the Clob object starting at the position pos. If the end of the Clob value is reached while writing the given string, then the length of the Clob value will be increased to accommodate the extra characters.

Note: If the value specified for pos is greater then the length+1 of the CLOB value then the behavior is undefined. Some JDBC drivers may throw a SQLException while other drivers may support this operation.

Specified by:

setString in interface Clob

Parameters:

pos - the position at which to start writing to this CLOB object; The first position is 1

str - the string to be written to the CLOB value that this Clob object represents

offset - the offset into str to start reading the characters to be written

len - the number of characters to be written

Returns:

the number of characters written

Throws:

SQLException - if there is an error accessing the CLOB value or if pos is less than 1

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

setAsciiStream

public OutputStream setAsciiStream(long pos)
                            throws SQLException

Description copied from interface: java.sql.Clob

Retrieves a stream to be used to write Ascii characters to the CLOB value that this Clob object represents, starting at position pos. Characters written to the stream will overwrite the existing characters in the Clob object starting at the position pos. If the end of the Clob value is reached while writing characters to the stream, then the length of the Clob value will be increased to accommodate the extra characters.

Note: If the value specified for pos is greater then the length+1 of the CLOB value then the behavior is undefined. Some JDBC drivers may throw a SQLException while other drivers may support this operation.

Specified by:

setAsciiStream in interface Clob

Parameters:

pos - the position at which to start writing to this CLOB object; The first position is 1

Returns:

the stream to which ASCII encoded characters can be written

Throws:

SQLException - if there is an error accessing the CLOB value or if pos is less than 1

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

See Also:

Clob.getAsciiStream()

setCharacterStream

public Writer setCharacterStream(long pos)
                          throws SQLException

Description copied from interface: java.sql.Clob

Retrieves a stream to be used to write a stream of Unicode characters to the CLOB value that this Clob object represents, at position pos. Characters written to the stream will overwrite the existing characters in the Clob object starting at the position pos. If the end of the Clob value is reached while writing characters to the stream, then the length of the Clob value will be increased to accommodate the extra characters.

Note: If the value specified for pos is greater then the length+1 of the CLOB value then the behavior is undefined. Some JDBC drivers may throw a SQLException while other drivers may support this operation.

Specified by:

setCharacterStream in interface Clob

Parameters:

pos - the position at which to start writing to the CLOB value; The first position is 1

Returns:

a stream to which Unicode encoded characters can be written

Throws:

SQLException - if there is an error accessing the CLOB value or if pos is less than 1

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

See Also:

Clob.getCharacterStream()

getAsciiStream

public InputStream getAsciiStream()
                           throws SQLException

Description copied from interface: java.sql.Clob

Retrieves the CLOB value designated by this Clob object as an ascii stream.

Specified by:

getAsciiStream in interface Clob

Returns:

a java.io.InputStream object containing the CLOB data

Throws:

SQLException - if there is an error accessing the CLOB value

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

See Also:

Clob.setAsciiStream(long)

getCharacterStream

public Reader getCharacterStream()
                          throws SQLException

Description copied from interface: java.sql.Clob

Retrieves the CLOB value designated by this Clob object as a java.io.Reader object (or as a stream of characters).

Specified by:

getCharacterStream in interface Clob

Returns:

a java.io.Reader object containing the CLOB data

Throws:

SQLException - if there is an error accessing the CLOB value

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

See Also:

Clob.setCharacterStream(long)

getSubString

public String getSubString(long i,
                  int j)
                    throws SQLException

Description copied from interface: java.sql.Clob

Retrieves a copy of the specified substring in the CLOB value designated by this Clob object. The substring begins at position pos and has up to length consecutive characters.

Specified by:

getSubString in interface Clob

Parameters:

i - the first character of the substring to be extracted. The first character is at position 1.

j - the number of consecutive characters to be copied; the value for length must be 0 or greater

Returns:

a String that is the specified substring in the CLOB value designated by this Clob object

Throws:

SQLException - if there is an error accessing the CLOB value; if pos is less than 1 or length is less than 0

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

position

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

For now, this is not implemented.

Specified by:

position in interface Clob

Parameters:

pattern - the substring for which to search

start - the position at which to begin searching; the first position is 1

Returns:

the position at which the substring appears or -1 if it is not present; the first position is 1

Throws:

SQLException - if there is an error accessing the CLOB value or if pos is less than 1

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

position

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

This should be simply passing the byte value of the pattern Blob

Specified by:

position in interface Clob

Parameters:

pattern - the Clob object for which to search

start - the position at which to begin searching; the first position is 1

Returns:

the position at which the Clob object appears or -1 if it is not present; the first position is 1

Throws:

SQLException - if there is an error accessing the CLOB value or if start is less than 1

SQLFeatureNotSupportedException - if the JDBC driver does not support this method