Columns of the Online Service Not Visible when Reading Input via Jdbc Reader Step
Reported for version 10
Problem
When reading input using Jdbc Reader step, some columns are not visible in the online service.
Solution
Make sure that you use Columns of the Jdbc Reader step to read the input data. If you use Shadow Columns for reading, the data columns will not be populated from the database (hence, the values are NULL
). Hence, the columns are not visible in the service response. To overcome the issue, remove the Shadow Columns and define them in Columns and in Query String. Query String uses an SQL query to gather input data records from the data source. Restart the service after making the changes to populate the columns with data from the database.
For more information about Jdbc Reader step, see the built-in documentation of your IDE, which you can find under Help > Help Contents.
Related articles