Currently, we are trying to get a new SQL query to function within DB Connect. The SQL query runs against a Postgres database. Although the SQL query runs fine in batch mode, it is not running so well when setting up the same in rising mode. Attached is a screenshot of the error message we are receiving.
We tried setting the rising column as "created_at". Also, we tried adding the following lines to the SQL query:
AND created_at > ?
ORDER BY created_at ASC
But we receive error messages:
org.postgresql.util.PSQLException: No value specified for parameter 1.
org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0.
Can someone suggest the best approach to resolving this?