com.northconcepts.datapipeline.jdbc

Interface JdbcValueReader

public interface JdbcValueReader

The interface used to read column values from a JDBC ResultSet.

Field Summary

Fields

Modifier and Type	Field and Description
static JdbcValueReader	DEFAULT Deprecated. use ORIGINAL to replicate the pre-8.0.0 default behavior. Maps database types to java types using the original DataPipeline algorithm. This mapping should no longer be used and replaced with OPINIONATED (or STRICT) instead.
static JdbcValueReader	OPINIONATED Maps database types to java types based only on java.sql.Types, column display size, and scale.
static JdbcValueReader	ORIGINAL
static JdbcValueReader	STRICT Maps database types to java types based only on java.sql.Types as defined by Sun/Oracle.

Method Summary

Modifier and Type	Method and Description
Object	readColumnValue(ResultSet result, int columnIndex, int columnType, String columnName)
default Object	readColumnValue(ResultSet result, int columnIndex, int columnType, String columnName, FieldType fieldType)
default Class<?>	sqlToJavaType(int sqlTypeIndex, int displaySize, int decimals, boolean nullable, boolean signed, String className)

Field Detail

ORIGINAL

static final JdbcValueReader ORIGINAL

DEFAULT

@Deprecated
static final JdbcValueReader DEFAULT

Deprecated. use ORIGINAL to replicate the pre-8.0.0 default behavior. Maps database types to java types using the original DataPipeline algorithm. This mapping should no longer be used and replaced with OPINIONATED (or STRICT) instead.

STRICT

static final JdbcValueReader STRICT

Maps database types to java types based only on java.sql.Types as defined by Sun/Oracle. Column display size and scale will not be considered for numeric types.

See Also:

JDBC / Relational Databases

OPINIONATED

static final JdbcValueReader OPINIONATED

Maps database types to java types based only on java.sql.Types, column display size, and scale.

See Also:

JDBC / Relational Databases

Method Detail

sqlToJavaType

default Class<?> sqlToJavaType(int sqlTypeIndex,
                               int displaySize,
                               int decimals,
                               boolean nullable,
                               boolean signed,
                               String className)
                        throws Throwable

Throws:

Throwable

readColumnValue

Object readColumnValue(ResultSet result,
                       int columnIndex,
                       int columnType,
                       String columnName)
                throws Throwable

Throws:

Throwable

readColumnValue

default Object readColumnValue(ResultSet result,
                               int columnIndex,
                               int columnType,
                               String columnName,
                               FieldType fieldType)
                        throws Throwable

Throws:

Throwable