net.sf.jailer.util

Class CellContentConverter

java.lang.Object

net.sf.jailer.util.CellContentConverter

public class CellContentConverter
extends Object

Converts a cell-content to valid SQL-literal.

Author:

Ralf Wisser

Constructor Summary

Constructors

Constructor and Description
CellContentConverter(ResultSetMetaData resultSetMetaData, Session session, DBMS targetConfiguration) Constructor.

Method Summary

Methods

Modifier and Type	Method and Description
Object	getObject(ResultSet resultSet, int i) Gets object from result-set.
Object	getObject(ResultSet resultSet, String columnName) Gets object from result-set.
String	getSmallLob(ResultSet resultSet, int i) Gets SQL expression for a C/BLOB for small LOBS.
String	toSql(Object content) Converts a cell-content to valid SQL-literal.

Methods inherited from class java.lang.Object

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

Constructor Detail

CellContentConverter

public CellContentConverter(ResultSetMetaData resultSetMetaData,
                    Session session,
                    DBMS targetConfiguration)

Constructor.

Parameters:

resultSetMetaData - meta data of the result set to read from

session - database session

targetDBMSConfiguration - configuration of the target DBMS

Method Detail

toSql

public String toSql(Object content)

Converts a cell-content to valid SQL-literal.

Parameters:

object - the content

Returns:

the SQL-literal

getObject

public Object getObject(ResultSet resultSet,
               int i)
                 throws SQLException

Gets object from result-set.

Parameters:

resultSet - result-set

i - column index

Returns:

object

Throws:

SQLException

getObject

public Object getObject(ResultSet resultSet,
               String columnName)
                 throws SQLException

Gets object from result-set.

Parameters:

resultSet - result-set

columnName - column name

typeCache - for caching types

Returns:

object

Throws:

SQLException

getSmallLob

public String getSmallLob(ResultSet resultSet,
                 int i)
                   throws SQLException,
                          IOException

Gets SQL expression for a C/BLOB for small LOBS.

Parameters:

resultSet - the result set

i - index of LOB column

Returns:

SQL expression for a C/BLOB for small LOBS

Throws:

SQLException

IOException