After migration to DBConnect 3.11 my SQL Statement won't work any more. It fails with an error in the UI.
com.microsoft.sqlserver.jdbc.SQLServerException: The value is not set for the parameter number 1.
I created a new Input in the Ui, first I run the stement with Batchmode by Execute Sql
SELECT [Entry No_] as [Entry_No]
,[Date and Time] as [Date_and_Time]
,[Time] as [Time]
,[User ID] as [User_ID]
FROM [table]
Next I select Rising Column and select Enty_No (bigint) also added the following line to my SQL Statement
WHERE Entry_No > ? ORDER BY Entry_No ASC
When I run Execute SQL again, the above error is displayed.
I created several Inputs with DB Connect 2.x and all of them worked. But now I cannot create a single one with 3.11
... View more