Language:

The Free and Open Productivity Suite
Apache OpenOffice 4.1.4 released

Developer's Guide

API

SDK

Tips 'n' Tricks

Miscellaneous


:: com :: sun :: star :: sdbc ::

interface XClob
Description
is the mapping for the SQL CLOB type.

A SQL CLOB is a built-in type that stores a Character Large Object as a column value in a row of a database table. The driver implements a Clob object using a SQL locator(CLOB) , which means that a Clob object contains a logical pointer to the SQL CLOB data rather than the data itself. A Clob object is valid for the duration of the transaction in which it was created.

The Clob interface provides methods for getting the length of a SQL CLOB (Character Large Object) value, for materializing a CLOB value on the client, and for searching for a substring or CLOB object within a CLOB value.

Methods in the interfaces XResultSet , and XPreparedStatement , such as getClob and setClob allow a programmer to access the SQL CLOB .


Methods' Summary
length returns the number of characters in the CLOB value designated by this Clob object.  
getSubString returns a copy of the specified substring in the Clob value designated by this Clob object.  
getCharacterStream gets the Clob contents as a stream.  
position determines the character position at which the specified substring searchstr appears in the Clob . The search begins at position start .  
positionOfClob determines the position at which the specified Clob object pattern appears in this Clob object. The search begins at position start .  
Methods' Details
length
hyper
length()
raises( SQLException );

Description
returns the number of characters in the CLOB value designated by this Clob object.
Returns
the length of the CLOB object
Throws
SQLException if a database access error occurs.
getSubString
string
getSubString( [in] hyper  pos,
[in] long  length )
raises( SQLException );

Description
returns 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.

Parameter pos
the starting position
Parameter length
the length of the substring
Returns
the substring
Throws
SQLException if a database access error occurs.
getCharacterStream
::com::sun::star::io::XInputStream
getCharacterStream()
raises( SQLException );

Description
gets the Clob contents as a stream.
Returns
the stream
Throws
SQLException if a database access error occurs.
position
hyper
position( [in] string  searchstr,
[in] long  start )
raises( SQLException );

Description
determines the character position at which the specified substring searchstr appears in the Clob . The search begins at position start .
Parameter searchstr
the string to search
Parameter start
the starting position
Returns
the length of the CLOB object
Throws
SQLException if a database access error occurs.
positionOfClob
hyper
positionOfClob( [in] XClob  pattern,
[in] hyper  start )
raises( SQLException );

Description
determines the position at which the specified Clob object pattern appears in this Clob object. The search begins at position start .
Parameter pattern
the CLOB to search
Parameter start
the starting position
Returns
the position of the CLOB inside
Throws
SQLException if a database access error occurs.
Top of Page

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache and the Apache feather logo are trademarks of The Apache Software Foundation. OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.