JDBC Stages and On Unknown Type => Convert to String
not sure what i don't understand, but it looks like streamsets hardcode this parameter to always be STOP_PIPELINE and not configurable? This is from the configBean...
@ConfigDef(
required = true,
type = ConfigDef.Type.MODEL,
label = "On Unknown Type",
description = "Action that should be performed when an unknown type is detected in the result set.",
defaultValue = "STOP_PIPELINE",
displayPosition = 220,
group = "ADVANCED"
)
@ValueChooserModel(UnknownTypeActionChooserValues.class)
public UnknownTypeAction unknownTypeAction = UnknownTypeAction.STOP_PIPELINE;
Error:
java.lang.IllegalArgumentException: Type:-155 is not a valid Types.java value. at java.sql.JDBCType.valueOf(Unknown Source) at com.streamsets.pipeline.lib.jdbc.multithread.TableContext.isPartitionable(TableContext.java:215) at com.streamsets.pipeline.lib.jdbc.multithread.TableContext.isPartitionable(TableContext.java:186) at com.streamsets.pipeline.lib.jdbc.multithread.TableContext.<init>(TableContext.java:109) at...
Yes, I understand that the datatimeoffset from SQL is a type -155, which isn't in the java.sql library StreamSets is using. Hence why I wanted to use TO_STRING on the unknown datatypes. Are you saying that StreamSets has no solution for this problem? I tried this and couldn't get the TO_STRING on UNKNOWN_TYPES to work, and thus I started to dig into the code to see why it wasn't working. Is there not a way to move forward?