Hi Lukas,
finally I've kept first approach (the fetch one) cause I need a
query local approach, not a global one (my dsl context is global, via
spring 4).
I've just added my already existings java8 time* converters inside the
RecordMapper in getValue(), and it works.
Just to understand for future tasks, the Listener approach is always at
global/config level? Or it's possible to add a listener also at query level?
Tks
Denis
Il giorno giovedì 2 giugno 2016 16:01:27 UTC+2, Lukas Eder ha scritto:
>
>
>
> 2016-06-02 15:55 GMT+02:00 Denis Miorandi <[email protected]
> <javascript:>>:
>
>> 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.
