I am Splunk version 7.3.0 and splunk DB connect app version 3.1.4 . Does This version is compatible with Splunk Version? and I am using mysql server from which I am fetching data.
Since I have created identity and connection and now when I try to create input I tried below query for rising column input
SELECT * FROM `sakila`.`address` WHERE last_update > ? ORDER BY last_update ASC
But When I tried below query for Batch input it works fine
SELECT * FROM `sakila`.`address` WHERE last_update > 0 ORDER BY last_update ASC
For rising input I am considering checkpoint value as 1/1/1970 00:00:00.000 and when I try to execute query it gives error as- java.sql.SQLException: No value specified for parameter 1
What could be an issue Please help me.