2016-06-02 15:55 GMT+02:00 Denis Miorandi <[email protected]>:

> I've tried second approach. Sql is generated as expected and query
> executed, but resultset are not typed as expected.
> I.e. LocalDateTime types are java.sql.TimeStamp and so on....
>

Oh, indeed. I'm sorry I overlooked that. There's a pending feature request
to allow for passing the result record type to a plain SQL query:
https://github.com/jOOQ/jOOQ/issues/4473

Other than that, jOOQ doesn't know what kind of result it will get when you
run plain SQL queries.

Do you think ExecuteListener approach would run into same issue? If you
> think not i could try it.
>

No, that just modifies the rendered SQL without jOOQ noticing, so you will
get the expected record type.

Lukas

-- 
You received this message because you are subscribed to the Google Groups "jOOQ 
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to