Debugging time based database FlexConnector
Can somebody give me a light here?
I'm trying to figure out a way to check the format and current output from "?" used to limit limit a given query in a time based database FlexConn, as shown below in this example query:
SELECT time, ipaddr, message FROM
time >= ?
ORDER BY time
Is there out any way to get "?" on the fly, to perform the same query to assure that my connectors is working as expected?
Hey G, whats up?
So, I was looking deeper in the connector execution log and found the values attributed to "?" on the fly - in this case it will be the last execution time. To debug the query we can copy the date and substitute the "?" for it in the query developer.
Furthermore, I recommend DBeaver to interact with the database. It's a very flexible and reliable tool.
Thanks for your help and time, dude!
Time based flex is really easy since all the time "event time " parameter is unique.
The connector is replacing '?' with the result of first query in the second one, the connector will replace the '? ' from 'Query' with the value taken from 'event time'.