CC-19080: Fix JDBC Source Connector to support Sybase jConnect JDBC 4 Driver.
Problem
The types as returned by Connection.getMetaData().getTableTypes().getString(int columnIndex) for Sybase jConnect driver contains extra whitespaces at the end which causes other APIs to fail when those returned values are used as-it-is:
"TABLE" => "TABLE "
"SYSTEM TABLE" => "SYSTEM TABLE "
"VIEW" => "VIEW "
Solution
Trimming the returned values of the aforementioned getTableTypes method. Here is the reference to the previous code change which was tested to be working fine for the jConnect driver.
Context
CC-19080: Fix JDBC Source Connector to support Sybase jConnect JDBC 4 Driver.
Problem
The types as returned by
Connection.getMetaData().getTableTypes().getString(int columnIndex)for Sybase jConnect driver contains extra whitespaces at the end which causes other APIs to fail when those returned values are used as-it-is:Solution
Trimming the returned values of the aforementioned getTableTypes method. Here is the reference to the previous code change which was tested to be working fine for the jConnect driver.
Does this solution apply anywhere else?
If yes, where?
NA
Testing done: