Dear group,

There is a pending feature request to improve customisability of logging in
general:
https://github.com/jOOQ/jOOQ/issues/2622

This will allow for more fine-grained control, what kind of action will be
logged at what level by jOOQ's default logging mechanisms.

What you're asking for, however, is more difficult to achieve. You can
solve this in various:

1. Override jOOQ's code generator to create a custom toString() method in
UDT Records
2. Inject a custom org.jooq.BindContext, intercepting bind events and log
your own version of a UDT variable binding event. There is no official SPI
for this, so this might feel a bit tweaky.
3. Implement a custom ExecuteListener that re-renders the SQL statement
with inlined bind values. You won't get a log entry per bind value, but the
full SQL statement should include the inlined UDT

About your concrete issues:

My problems are :
>> 1. I would like to change logged info ( there is no need for me to see
>> numbers of milis elapsed in specific phases )
>>
>
That will be covered with #2622


> 2. I need different logging schema for UDT
>>
>
That can be done with custom toString() methods.


> 3. I need output from function
>>
>
True, that currently isn't logged. I have registered #2639 for this
https://github.com/jOOQ/jOOQ/issues/2639

Besides, I have noticed that output isn't registered in the ExecuteContext,
the way regular ResultQuery Results are. For this, I have registered #2640:
https://github.com/jOOQ/jOOQ/issues/2640


> 4. I would like to do 1-3 with as little modification to jooq, so that in
>> future I can update jooq to newest version without much problems
>>
>
The above is all I can offer you for now. So a little update risk will
remain.

Cheers
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/groups/opt_out.


Reply via email to