org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL

Solution 1:

The error message says:

THE NUMBER OF HOST VARIABLES SPECIFIED IS NOT EQUAL TO THE NUMBER OF PARAMETER MARKERS

See IBM Knowledge Center for more Details.

Your query need 2 parameter. But your array contains only one parameter. You have to add destination two times to the array.