com.esri.gpt.framework.sql
Interface IClobMutator

public interface IClobMutator

Provides mechanizm to access CLOB data. Depending on database it might be a different way to access data stored within CLOB column.

See Also:

ManagedConnection.getClobMutator()

Method Summary

String	get(ResultSet rs, int fieldIndex) Gets value of the CLOB.
String	get(ResultSet rs, String fieldName) Gets value of the CLOB.
InputStream	getStream(ResultSet rs, int fieldIndex) Gets value as a stream
void	set(PreparedStatement st, int paramIndex, String value) Sets value of the CLOB.
void	setStream(PreparedStatement st, int fieldIndex, InputStream value, long length) Sets value as a stream

Method Detail

get

String get(ResultSet rs,
           int fieldIndex)
           throws SQLException

Gets value of the CLOB.

Parameters:

rs - result set

fieldIndex - index of the CLOB field

Returns:

value of the CLOB as string

Throws:

SQLException - if reading CLOB failed

get

String get(ResultSet rs,
           String fieldName)
           throws SQLException

Gets value of the CLOB.

Parameters:

rs - result set

fieldName - name of the CLOB field

Returns:

value of the CLOB as string

Throws:

SQLException - if reading CLOB failed

set

void set(PreparedStatement st,
         int paramIndex,
         String value)
         throws SQLException

Sets value of the CLOB.

Parameters:

st - prepared statement

paramIndex - index of the CLOB parameter

value - value to set

Throws:

SQLException - if writing CLOB failed

getStream

InputStream getStream(ResultSet rs,
                      int fieldIndex)
                      throws SQLException

Gets value as a stream

Parameters:

rs - result set

fieldIndex - field index

Returns:

input stream to read value

Throws:

SQLException - if getting stream failed

setStream

void setStream(PreparedStatement st,
               int fieldIndex,
               InputStream value,
               long length)
               throws SQLException

Sets value as a stream

Parameters:

st - prepared statement

fieldIndex - field index

value - value as a stream

length - length of the stream

Throws:

SQLException - if setting stream failed