Embedded Function Call in SQL Throws an Error

Reported for version 9

Problem

Attempting to run query: Select functionName() from Table returns the following error:

Runtime error in JDBC reader: Invalid sql column in the result: functionName()[STEP Jdbc Reader Jdbc Reader]] 
Java.lang.IleagalStateException: Invalid sql column in the result: functionName()

Solution

The JDBC Reader step expects a column name after the function. It will place the result of the query in this column. You need to create a column in the JDBC Reader step and specify Type for the newly created column.

In Query string of the JDBC Reader step input string in the following format:

select functionName as Column from Table

In the example, functionName represents the function and Column - the column where the result of the query will be placed.

Problem

Solution

Related articles