net.sf.jailer.util

Class CellContentConverter

java.lang.Object

net.sf.jailer.util.CellContentConverter

public class CellContentConverter
extends java.lang.Object

Converts a cell-content to valid SQL-literal.

Author:

Ralf Wisser

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	CellContentConverter.NCharWrapper
static class	CellContentConverter.PObjectWrapper
class	CellContentConverter.SQLExpressionWrapper
static class	CellContentConverter.TimestampWithNano

Field Summary

Fields

Modifier and Type	Field and Description
static char[]	hexChar All hex digits.
static int	TIMESTAMP_WITH_NANO

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
java.lang.Object	getObject(java.sql.ResultSet resultSet, int i) Gets object from result-set.
java.lang.Object	getObject(java.sql.ResultSet resultSet, java.lang.String columnName) Gets object from result-set.
static java.lang.String	getSmallLob(java.lang.Object lob, DBMS targetConfiguration, java.lang.Integer maxBlobLength, java.lang.Integer maxClobLength) Gets SQL expression for a C/BLOB for small LOBS.
java.lang.String	getSmallLob(java.sql.ResultSet resultSet, int i) Gets SQL expression for a C/BLOB for small LOBS.
static boolean	isPostgresObjectType(java.lang.String columnTypeName)
java.lang.String	toSql(java.lang.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

Field Detail

TIMESTAMP_WITH_NANO

public static final int TIMESTAMP_WITH_NANO

See Also:

Constant Field Values

hexChar

public static final char[] hexChar

All hex digits.

Constructor Detail

CellContentConverter

public CellContentConverter(java.sql.ResultSetMetaData resultSetMetaData,
                            Session session,
                            DBMS targetConfiguration)

Constructor.

Parameters:

resultSetMetaData - meta data of the result set to read from

session - database session

targetConfiguration - configuration of the target DBMS

Method Detail

toSql

public java.lang.String toSql(java.lang.Object content)

Converts a cell-content to valid SQL-literal.

Parameters:

content - the content

Returns:

the SQL-literal

getObject

public java.lang.Object getObject(java.sql.ResultSet resultSet,
                                  int i)
                           throws java.sql.SQLException

Gets object from result-set.

Parameters:

resultSet - result-set

i - column index

Returns:

object

Throws:

java.sql.SQLException

isPostgresObjectType

public static boolean isPostgresObjectType(java.lang.String columnTypeName)

getObject

public java.lang.Object getObject(java.sql.ResultSet resultSet,
                                  java.lang.String columnName)
                           throws java.sql.SQLException

Gets object from result-set.

Parameters:

resultSet - result-set

columnName - column name

Returns:

the object

Throws:

java.sql.SQLException

getSmallLob

public java.lang.String getSmallLob(java.sql.ResultSet resultSet,
                                    int i)

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

getSmallLob

public static java.lang.String getSmallLob(java.lang.Object lob,
                                           DBMS targetConfiguration,
                                           java.lang.Integer maxBlobLength,
                                           java.lang.Integer maxClobLength)

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

Parameters:

lob - the lob

Returns:

SQL expression for a C/BLOB for small LOBS