com.mimer.jdbc
Class Clob

java.lang.Object
  |
  +--com.mimer.jdbc.Clob

public class Clob

extends java.lang.Object

The Clob object corresponds to a CLOB LOCATOR or NCLOB LOCATOR in the SQL-99 standard. This object may only be used to represent the Mimer SQL type CHARACTER LARGE OBJECT (CLOB) or NATIONAL CHARACTER LARGE OBJECT (NCLOB). Any attempts to use this object on other datatypes will cause an SQLException to be raised. For more information see java.sql.Blob .

Method Summary

java.io.InputStream	getAsciiStream() Returns an InputStream to access the data this CLOB LOCATOR represents.
java.io.Reader	getCharacterStream() Returns a CharacterStream to access the data this CLOB LOCATOR represents.
java.lang.String	getSubString(long pos, int length) Returns a String object holding the data this CLOB LOCATOR object represents.
long	length() Returns the length of the data this CLOB LOCATOR represents.
long	position(Clob pattern, long start) Searches for a position within the CLOB object.
long	position(java.lang.String pattern, long start) Searches for a position within the CLOB object.

Methods inherited from class java.lang.Object

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

Method Detail

getAsciiStream

public java.io.InputStream getAsciiStream()
                                   throws SQLException

Returns an InputStream to access the data this CLOB LOCATOR represents.

Returns:

A stream.

Throws:

SQLException - if an error occurs. SQLSTATE 25000 is thrown if this Blob object was invalidated because the transaction in which it was created has ended.

getCharacterStream

public java.io.Reader getCharacterStream()
                                  throws SQLException

Returns a CharacterStream to access the data this CLOB LOCATOR represents.

Returns:

A stream.

Throws:

SQLException - if an error occurs. SQLSTATE 25000 is thrown if this Blob object was invalidated because the transaction in which it was created has ended.

getSubString

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

Returns a String object holding the data this CLOB LOCATOR object represents.

Parameters:

pos - The offset within the CLOB to start returning data.

length - The number of characters at most to return.

Returns:

The string.

Throws:

SQLException - if an error occurs. SQLSTATE 25000 is thrown if this Blob object was invalidated because the transaction in which it was created has ended.

length

public long length()
            throws SQLException

Returns the length of the data this CLOB LOCATOR represents.

Returns:

The length in characters.

Throws:

SQLException - if an error occurs. SQLSTATE 25000 is thrown if this Blob object was invalidated because the transaction in which it was created has ended.

position

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

Searches for a position within the CLOB object.

Searches within CLOB:s are not supported yet.

SQLException

position

public long position(java.lang.String pattern,
                     long start)
              throws SQLException

Searches for a position within the CLOB object.

Searches within CLOB:s are not supported yet.

SQLException