io.debezium.jdbc

Class JdbcValueConverters

java.lang.Object

io.debezium.jdbc.JdbcValueConverters

All Implemented Interfaces:

ValueConverterProvider

@Immutable
public class JdbcValueConverters
extends Object
implements ValueConverterProvider

A provider of ValueConverters and SchemaBuilders for various column types. This implementation is aware of the most common JDBC types and values. Specializations for specific DBMSes can be addressed in subclasses.

Although it is more likely that values will correspond pretty closely to the expected JDBC types, this class assumes it is possible for some variation to occur when values originate in libraries that are not JDBC drivers. Specifically, the conversion logic for JDBC temporal types with timezones (e.g., Types.TIMESTAMP_WITH_TIMEZONE) do support converting values that don't have timezones (e.g., Timestamp) by assuming a default time zone offset for values that don't have (but are expected to have) timezones. Again, when the values are highly-correlated with the expected SQL/JDBC types, this default timezone offset will not be needed.

Author:

Randall Hauch

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	JdbcValueConverters.DecimalMode

Field Summary

Fields

Modifier and Type	Field and Description
protected boolean	adaptiveTimePrecision
private TemporalAdjuster	adjuster
protected JdbcValueConverters.DecimalMode	decimalMode
private ZoneOffset	defaultOffset
private static Double	DOUBLE_FALSE
private static Double	DOUBLE_TRUE
private static Float	FLOAT_FALSE
private static Float	FLOAT_TRUE
private static Integer	INTEGER_FALSE
private static Integer	INTEGER_TRUE
protected org.slf4j.Logger	logger
private static Long	LONG_FALSE
private static Long	LONG_TRUE
private static Short	SHORT_FALSE
private static Short	SHORT_TRUE

Constructor Summary

Constructors

Constructor and Description
JdbcValueConverters() Create a new instance that always uses UTC for the default time zone when converting values without timezone information to values that require timezones, and uses adapts time and timestamp values based upon the precision of the database columns.
JdbcValueConverters(JdbcValueConverters.DecimalMode decimalMode, boolean adaptiveTimePrecision, ZoneOffset defaultOffset, TemporalAdjuster adjuster) Create a new instance, and specify the time zone offset that should be used only when converting values without timezone information to values that require timezones.

Method Summary

Modifier and Type	Method and Description
protected ByteOrder	byteOrderOfBitType() Determine whether the byte[] values for columns of type BIT(n) are big-endian or little-endian.
protected Object	convertBigInt(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.INTEGER.
protected Object	convertBinary(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.BLOB, Types.BINARY, Types.VARBINARY, Types.LONGVARBINARY.
protected Object	convertBit(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.BIT.
protected ValueConverter	convertBits(Column column, org.apache.kafka.connect.data.Field fieldDefn)
protected Object	convertBits(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data, int numBytes) Converts a value object for an expected JDBC type of Types.BIT of length 2+.
protected Object	convertBoolean(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.BOOLEAN.
protected ByteBuffer	convertByteArray(Column column, byte[] data) Converts the given byte array value into a byte buffer as preferred by Kafka Connect.
protected Object	convertDateToEpochDays(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.DATE to the number of days past epoch.
protected Object	convertDateToEpochDaysAsDate(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.DATE to the number of days past epoch, but represented as a Date value at midnight on the date.
protected Object	convertDecimal(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.NUMERIC.
protected Object	convertDouble(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.DOUBLE.
ValueConverter	converter(Column column, org.apache.kafka.connect.data.Field fieldDefn) Returns a ValueConverter that can be used to convert the JDBC values corresponding to the given JDBC temporal type into literal values described by the schema.
protected Object	convertFloat(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.FLOAT.
protected Object	convertInteger(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.INTEGER.
protected Object	convertNumeric(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.NUMERIC.
protected Object	convertReal(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.REAL.
protected Object	convertRowId(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.ROWID.
protected Object	convertSmallInt(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.SMALLINT.
protected Object	convertString(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.CHAR, Types.VARCHAR, Types.LONGVARCHAR, Types.CLOB, Types.NCHAR, Types.NVARCHAR, Types.LONGNVARCHAR, Types.NCLOB, Types.DATALINK, and Types.SQLXML.
protected Object	convertTimestampToEpochMicros(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.TIMESTAMP to MicroTimestamp values, or microseconds past epoch.
protected Object	convertTimestampToEpochMillis(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.TIMESTAMP to Timestamp values, or milliseconds past epoch.
protected Object	convertTimestampToEpochMillisAsDate(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.TIMESTAMP to Date values representing milliseconds past epoch.
protected Object	convertTimestampToEpochNanos(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.TIMESTAMP to NanoTimestamp values, or nanoseconds past epoch.
protected Object	convertTimestampWithZone(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.TIMESTAMP_WITH_TIMEZONE.
protected Object	convertTimeToMicrosPastMidnight(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.TIME to MicroTime values, or microseconds past midnight.
protected Object	convertTimeToMillisPastMidnight(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.TIME to Time values, or milliseconds past midnight.
protected Object	convertTimeToMillisPastMidnightAsDate(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.TIME to Date values representing the milliseconds past midnight on the epoch day.
protected Object	convertTimeToNanosPastMidnight(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.TIME to NanoTime values, or nanoseconds past midnight.
protected Object	convertTimeWithZone(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.TIME_WITH_TIMEZONE.
protected Object	convertTinyInt(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Converts a value object for an expected JDBC type of Types.TINYINT.
protected Object	handleUnknownData(Column column, org.apache.kafka.connect.data.Field fieldDefn, Object data) Convert an unknown data value.
protected byte[]	padLittleEndian(int numBytes, byte[] data)
org.apache.kafka.connect.data.SchemaBuilder	schemaBuilder(Column column) Returns a SchemaBuilder for a Schema describing literal values of the given JDBC type.
protected byte[]	unexpectedBinary(Object value, org.apache.kafka.connect.data.Field fieldDefn) Handle the unexpected value from a row with a column type of Types.BLOB, Types.BINARY, Types.VARBINARY, Types.LONGVARBINARY.

Methods inherited from class java.lang.Object

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

Field Detail

SHORT_TRUE

private static final Short SHORT_TRUE

SHORT_FALSE

private static final Short SHORT_FALSE

INTEGER_TRUE

private static final Integer INTEGER_TRUE

INTEGER_FALSE

private static final Integer INTEGER_FALSE

LONG_TRUE

private static final Long LONG_TRUE

LONG_FALSE

private static final Long LONG_FALSE

FLOAT_TRUE

private static final Float FLOAT_TRUE

FLOAT_FALSE

private static final Float FLOAT_FALSE

DOUBLE_TRUE

private static final Double DOUBLE_TRUE

DOUBLE_FALSE

private static final Double DOUBLE_FALSE

logger

protected final org.slf4j.Logger logger

defaultOffset

private final ZoneOffset defaultOffset

adaptiveTimePrecision

protected final boolean adaptiveTimePrecision

decimalMode

protected final JdbcValueConverters.DecimalMode decimalMode

adjuster

private final TemporalAdjuster adjuster

Constructor Detail

JdbcValueConverters

public JdbcValueConverters()

Create a new instance that always uses UTC for the default time zone when converting values without timezone information to values that require timezones, and uses adapts time and timestamp values based upon the precision of the database columns.

JdbcValueConverters

public JdbcValueConverters(JdbcValueConverters.DecimalMode decimalMode,
                           boolean adaptiveTimePrecision,
                           ZoneOffset defaultOffset,
                           TemporalAdjuster adjuster)

Create a new instance, and specify the time zone offset that should be used only when converting values without timezone information to values that require timezones. This default offset should not be needed when values are highly-correlated with the expected SQL/JDBC types.

Parameters:

decimalMode - how DECIMAL and NUMERIC values should be treated; may be null if JdbcValueConverters.DecimalMode.PRECISE is to be used

adaptiveTimePrecision - true if the time, date, and timestamp values should be based upon the precision of the database columns using io.debezium.time semantic types, or false if they should be fixed to millisecond precision using Kafka Connect org.apache.kafka.connect.data logical types.

defaultOffset - the zone offset that is to be used when converting non-timezone related values to values that do have timezones; may be null if UTC is to be used

adjuster - the optional component that adjusts the local date value before obtaining the epoch day; may be null if no adjustment is necessary

Method Detail

schemaBuilder

public org.apache.kafka.connect.data.SchemaBuilder schemaBuilder(Column column)

Description copied from interface: ValueConverterProvider

Returns a SchemaBuilder for a Schema describing literal values of the given JDBC type.

Specified by:

schemaBuilder in interface ValueConverterProvider

Parameters:

column - the column definition; never null

Returns:

the schema builder; null if the column's type information is unknown

converter

public ValueConverter converter(Column column,
                                org.apache.kafka.connect.data.Field fieldDefn)

Description copied from interface: ValueConverterProvider

Returns a ValueConverter that can be used to convert the JDBC values corresponding to the given JDBC temporal type into literal values described by the schema.

This method is only called when ValueConverterProvider.schemaBuilder(Column) returns a non-null SchemaBuilder for the same column definition.

Specified by:

converter in interface ValueConverterProvider

Parameters:

column - the column definition; never null

fieldDefn - the definition for the field in a Kafka Connect Schema describing the output of the function; never null

Returns:

the value converter; never null

convertBits

protected ValueConverter convertBits(Column column,
                                     org.apache.kafka.connect.data.Field fieldDefn)

convertTimestampWithZone

protected Object convertTimestampWithZone(Column column,
                                          org.apache.kafka.connect.data.Field fieldDefn,
                                          Object data)

Converts a value object for an expected JDBC type of Types.TIMESTAMP_WITH_TIMEZONE. The standard ANSI to Java 8 type mappings specify that the preferred mapping (when using JDBC's getObject(...) methods) in Java 8 is to return OffsetDateTime for these values.

This method handles several types of objects, including OffsetDateTime, Timestamp, Date, LocalTime, and LocalDateTime.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertTimeWithZone

protected Object convertTimeWithZone(Column column,
                                     org.apache.kafka.connect.data.Field fieldDefn,
                                     Object data)

Converts a value object for an expected JDBC type of Types.TIME_WITH_TIMEZONE. The standard ANSI to Java 8 type mappings specify that the preferred mapping (when using JDBC's getObject(...) methods) in Java 8 is to return OffsetTime for these values.

This method handles several types of objects, including OffsetTime, Time, Date, LocalTime, and LocalDateTime. If any of the types have date components, those date components are ignored.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertTimestampToEpochMillis

protected Object convertTimestampToEpochMillis(Column column,
                                               org.apache.kafka.connect.data.Field fieldDefn,
                                               Object data)

Converts a value object for an expected JDBC type of Types.TIMESTAMP to Timestamp values, or milliseconds past epoch.

Per the JDBC specification, databases should return Timestamp instances, which have date and time info but no time zone info. This method handles Date objects plus any other standard date-related objects such as Date, LocalTime, and LocalDateTime.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertTimestampToEpochMicros

protected Object convertTimestampToEpochMicros(Column column,
                                               org.apache.kafka.connect.data.Field fieldDefn,
                                               Object data)

Converts a value object for an expected JDBC type of Types.TIMESTAMP to MicroTimestamp values, or microseconds past epoch.

Per the JDBC specification, databases should return Timestamp instances, which have date and time info but no time zone info. This method handles Date objects plus any other standard date-related objects such as Date, LocalTime, and LocalDateTime.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertTimestampToEpochNanos

protected Object convertTimestampToEpochNanos(Column column,
                                              org.apache.kafka.connect.data.Field fieldDefn,
                                              Object data)

Converts a value object for an expected JDBC type of Types.TIMESTAMP to NanoTimestamp values, or nanoseconds past epoch.

Per the JDBC specification, databases should return Timestamp instances, which have date and time info but no time zone info. This method handles Date objects plus any other standard date-related objects such as Date, LocalTime, and LocalDateTime.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertTimestampToEpochMillisAsDate

protected Object convertTimestampToEpochMillisAsDate(Column column,
                                                     org.apache.kafka.connect.data.Field fieldDefn,
                                                     Object data)

Converts a value object for an expected JDBC type of Types.TIMESTAMP to Date values representing milliseconds past epoch.

Per the JDBC specification, databases should return Timestamp instances, which have date and time info but no time zone info. This method handles Date objects plus any other standard date-related objects such as Date, LocalTime, and LocalDateTime.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertTimeToMillisPastMidnight

protected Object convertTimeToMillisPastMidnight(Column column,
                                                 org.apache.kafka.connect.data.Field fieldDefn,
                                                 Object data)

Converts a value object for an expected JDBC type of Types.TIME to Time values, or milliseconds past midnight.

Per the JDBC specification, databases should return Time instances that have no notion of date or time zones. This method handles Date objects plus any other standard date-related objects such as Date, LocalTime, and LocalDateTime. If any of the types might have date components, those date components are ignored.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertTimeToMicrosPastMidnight

protected Object convertTimeToMicrosPastMidnight(Column column,
                                                 org.apache.kafka.connect.data.Field fieldDefn,
                                                 Object data)

Converts a value object for an expected JDBC type of Types.TIME to MicroTime values, or microseconds past midnight.

Per the JDBC specification, databases should return Time instances that have no notion of date or time zones. This method handles Date objects plus any other standard date-related objects such as Date, LocalTime, and LocalDateTime. If any of the types might have date components, those date components are ignored.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertTimeToNanosPastMidnight

protected Object convertTimeToNanosPastMidnight(Column column,
                                                org.apache.kafka.connect.data.Field fieldDefn,
                                                Object data)

Converts a value object for an expected JDBC type of Types.TIME to NanoTime values, or nanoseconds past midnight.

Per the JDBC specification, databases should return Time instances that have no notion of date or time zones. This method handles Date objects plus any other standard date-related objects such as Date, LocalTime, and LocalDateTime. If any of the types might have date components, those date components are ignored.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertTimeToMillisPastMidnightAsDate

protected Object convertTimeToMillisPastMidnightAsDate(Column column,
                                                       org.apache.kafka.connect.data.Field fieldDefn,
                                                       Object data)

Converts a value object for an expected JDBC type of Types.TIME to Date values representing the milliseconds past midnight on the epoch day.

Per the JDBC specification, databases should return Time instances that have no notion of date or time zones. This method handles Date objects plus any other standard date-related objects such as Date, LocalTime, and LocalDateTime. If any of the types might have date components, those date components are ignored.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertDateToEpochDays

protected Object convertDateToEpochDays(Column column,
                                        org.apache.kafka.connect.data.Field fieldDefn,
                                        Object data)

Converts a value object for an expected JDBC type of Types.DATE to the number of days past epoch.

Per the JDBC specification, databases should return Date instances that have no notion of time or time zones. This method handles Date objects plus any other standard date-related objects such as Date, LocalDate, and LocalDateTime. If any of the types might have time components, those time components are ignored.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertDateToEpochDaysAsDate

protected Object convertDateToEpochDaysAsDate(Column column,
                                              org.apache.kafka.connect.data.Field fieldDefn,
                                              Object data)

Converts a value object for an expected JDBC type of Types.DATE to the number of days past epoch, but represented as a Date value at midnight on the date.

Per the JDBC specification, databases should return Date instances that have no notion of time or time zones. This method handles Date objects plus any other standard date-related objects such as Date, LocalDate, and LocalDateTime. If any of the types might have time components, those time components are ignored.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertBinary

protected Object convertBinary(Column column,
                               org.apache.kafka.connect.data.Field fieldDefn,
                               Object data)

Converts a value object for an expected JDBC type of Types.BLOB, Types.BINARY, Types.VARBINARY, Types.LONGVARBINARY.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertByteArray

protected ByteBuffer convertByteArray(Column column,
                                      byte[] data)

Converts the given byte array value into a byte buffer as preferred by Kafka Connect. Specific connectors can perform value adjustments based on the column definition, e.g. right-pad with 0x00 bytes in case of fixed length BINARY in MySQL.

unexpectedBinary

protected byte[] unexpectedBinary(Object value,
                                  org.apache.kafka.connect.data.Field fieldDefn)

Handle the unexpected value from a row with a column type of Types.BLOB, Types.BINARY, Types.VARBINARY, Types.LONGVARBINARY.

Parameters:

value - the binary value for which no conversion was found; never null

fieldDefn - the field definition in the Kafka Connect schema; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

See Also:

convertBinary(Column, Field, Object)

convertTinyInt

protected Object convertTinyInt(Column column,
                                org.apache.kafka.connect.data.Field fieldDefn,
                                Object data)

Converts a value object for an expected JDBC type of Types.TINYINT.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertSmallInt

protected Object convertSmallInt(Column column,
                                 org.apache.kafka.connect.data.Field fieldDefn,
                                 Object data)

Converts a value object for an expected JDBC type of Types.SMALLINT.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertInteger

protected Object convertInteger(Column column,
                                org.apache.kafka.connect.data.Field fieldDefn,
                                Object data)

Converts a value object for an expected JDBC type of Types.INTEGER.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertBigInt

protected Object convertBigInt(Column column,
                               org.apache.kafka.connect.data.Field fieldDefn,
                               Object data)

Converts a value object for an expected JDBC type of Types.INTEGER.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertFloat

protected Object convertFloat(Column column,
                              org.apache.kafka.connect.data.Field fieldDefn,
                              Object data)

Converts a value object for an expected JDBC type of Types.FLOAT.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertDouble

protected Object convertDouble(Column column,
                               org.apache.kafka.connect.data.Field fieldDefn,
                               Object data)

Converts a value object for an expected JDBC type of Types.DOUBLE.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertReal

protected Object convertReal(Column column,
                             org.apache.kafka.connect.data.Field fieldDefn,
                             Object data)

Converts a value object for an expected JDBC type of Types.REAL.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertNumeric

protected Object convertNumeric(Column column,
                                org.apache.kafka.connect.data.Field fieldDefn,
                                Object data)

Converts a value object for an expected JDBC type of Types.NUMERIC.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertDecimal

protected Object convertDecimal(Column column,
                                org.apache.kafka.connect.data.Field fieldDefn,
                                Object data)

Converts a value object for an expected JDBC type of Types.NUMERIC.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertString

protected Object convertString(Column column,
                               org.apache.kafka.connect.data.Field fieldDefn,
                               Object data)

Converts a value object for an expected JDBC type of Types.CHAR, Types.VARCHAR, Types.LONGVARCHAR, Types.CLOB, Types.NCHAR, Types.NVARCHAR, Types.LONGNVARCHAR, Types.NCLOB, Types.DATALINK, and Types.SQLXML.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertRowId

protected Object convertRowId(Column column,
                              org.apache.kafka.connect.data.Field fieldDefn,
                              Object data)

Converts a value object for an expected JDBC type of Types.ROWID.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertBit

protected Object convertBit(Column column,
                            org.apache.kafka.connect.data.Field fieldDefn,
                            Object data)

Converts a value object for an expected JDBC type of Types.BIT.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

convertBits

protected Object convertBits(Column column,
                             org.apache.kafka.connect.data.Field fieldDefn,
                             Object data,
                             int numBytes)

Converts a value object for an expected JDBC type of Types.BIT of length 2+.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

numBytes - the number of bytes that should be included in the resulting byte[]

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

padLittleEndian

protected byte[] padLittleEndian(int numBytes,
                                 byte[] data)

byteOrderOfBitType

protected ByteOrder byteOrderOfBitType()

Determine whether the byte[] values for columns of type BIT(n) are big-endian or little-endian. All values for BIT(n) columns are to be returned in little-endian.

By default, this method returns ByteOrder.LITTLE_ENDIAN.

Returns:

little endian or big endian; never null

convertBoolean

protected Object convertBoolean(Column column,
                                org.apache.kafka.connect.data.Field fieldDefn,
                                Object data)

Converts a value object for an expected JDBC type of Types.BOOLEAN.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls

handleUnknownData

protected Object handleUnknownData(Column column,
                                   org.apache.kafka.connect.data.Field fieldDefn,
                                   Object data)

Convert an unknown data value.

Parameters:

column - the column definition describing the data value; never null

fieldDefn - the field definition; never null

data - the data object to be converted into a Kafka Connect date type; never null

Returns:

the converted value, or null if the conversion could not be made and the column allows nulls

Throws:

IllegalArgumentException - if the value could not be converted but the column does not allow nulls