Jdbc config not working

Simple issue in that I have a jdbc config set up, but no output so no idea whats going on.

I have changed logstash config to go to debug and can see the config is being consumed without errors.

The input is select "test" from dual, although tried various select options. The output is to a file.

What do I need to do to switch up the config to see what is config wrong?

It would help if you were to share your config, the current output and what you expect the output to be.

The content of my config is not relevant, its the lack of output to explain what is wrong.

I have been working for 5 days to get select 'x' from dual to work and nothing useful is being logged to detail what is wrong. I should need to post on a forum to work output what I have mis configured