Esri Geoportal Server
1.0

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

Esri Geoportal Server
1.0

Copyright 2011 Environmental Systems Research Institute. All rights reserved. Use is subject to license terms.