Now, the select statement is erroneously composed by simply replacing
each "?" with its correspondent value. However, this won't work for string and dates for example.
The insert query should be prepared and executed afterwards using only the params/values instead, though for now this is throwing "Vector has failed with exception: line 1, The dynamically defined statement 'jdbc_stmt_0_1' is either a SELECT statement that cannot be EXECUTED, or a non-SELECT statement that cannot be OPENED."
Now, the select statement is erroneously composed by simply replacing each "?" with its correspondent value. However, this won't work for string and dates for example.
The insert query should be prepared and executed afterwards using only the params/values instead, though for now this is throwing "Vector has failed with exception: line 1, The dynamically defined statement 'jdbc_stmt_0_1' is either a SELECT statement that cannot be EXECUTED, or a non-SELECT statement that cannot be OPENED."