JDBC Header Attributes
By default, the JDBC Multitable Consumer origin generates JDBC record header attributes that provide additional information about each record, such as the original data type of a field or the source tables for the record.
You can use the record:attribute or
record:attributeOrDefault functions to access the information
in the attributes. For more information about working with record header attributes,
see Working with Header Attributes.
JDBC record header attributes include a jdbc prefix to differentiate the
JDBC attributes from other record header attributes.
You can configure the origin to skip creating JDBC header attributes by clearing the Create JDBC Header Attributes property on the Advanced tab.
| JDBC Header Attribute | Description |
|---|---|
| jdbc.tables |
Provides a
comma-separated list of source tables for the fields in the
record.
Note: Not all JDBC drivers provide this
information. Oracle uses all caps for schema, table, and column names by default. Names can be lower- or mixed-case only if the schema, table, or column was created with quotation marks around the name. |
| jdbc.partition | Provides the full offset key for the partition that produced the record |
| jdbc.threadNumber | Provides the number of the thread that produced the record. |
| jdbc.<column name>.jdbcType | Provides the numeric value of the original SQL data type for each field in the record. See the Java documentation for a list of the data types that correspond to numeric values. |
| jdbc.<column name>.precision | Provides the original precision for all numeric and decimal fields. |
| jdbc.<column name>.scale | Provides the original scale for all numeric and decimal fields. |