Debugging time based database FlexConnector

[fausto.filho1]

Hi folks,

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

EVENTS

WHERE

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?

Thanks!

[Gayan]

Hi Fausto,

here ? use as primary key. If you want check whether your query work not then you can try it in the java sql developer.

Cheers

G

[fausto.filho1]

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!

ff

[Gayan]

Cool man.

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'.

Cheers

Gayan

[fausto.filho1]

That's the algorithm, Gayan!
Hope ours thoughts help somebody in the future!

Cheers,

ff

[Gayan]

Yep