How to see the sql that will be sent to the db?

[nilopaim]

I would like to see the sql commend that will be sent to the db with the parameters already injected.

Are there some easy way?

Thanks.

[cellux-git]

You may implement a listener described on wiki: https://github.com/zsoltherpai/fluent-jdbc/wiki/Query-listener Alternatively, your jdbc driver might provide logging features.

…

On Tue, Aug 7, 2018, 9:47 PM Nilo Roberto C Paim ***@***.***> wrote: I would like to see the sql commend that will be sent to the db with the parameters already injected. Are there some easy way? Thanks. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#65>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AB72xWi5pgAYjZinqTpaSBe3hoGxIN45ks5uOe7AgaJpZM4VyxyC> .

[nilopaim]

Yes, that's what I did.

The sad part is that the sql command does not shows the parameters injected. It would be nice to have this feature, I think. That's the kind of thing that helps during the development.

Thanks, and congratulations for your work, I use fluent-jdbc every day.

[tonowie]

wanted to raise my own issue but this is pretty much the same thing so just comment here

For purposes of automated logging it would be great if AfterQueryListener received information also about the query parameters because those are important context of query execution. ExecutionDetails should provide enough information so that listener has all the information that is commonly needed for query logging. I am not sure whether this was left out on purpose or it is omission.

I can contribute to the project if it helps to make this happen in timely fashion :)

[tonowie]

created pull request #86 with suggestion of how to change the API