Hi all, 

I’m trying to find a way of printing in and out structures send to / 
received from database when executing functions defined in UDT.
After enabling trace logging level i was able to receive some logs like :
…
TRACE StopWatch - Preparing statement      : Total: 3.382ms, +2.142ms
TRACE StopWatch - Statement prepared       : Total: 3.974ms, +0.592ms
TRACE StopWatch - Binding variables        : Total: 4.107ms, +0.133ms
TRACE DefaultBindContext - Binding variable 2       : "TEST_PARAM_IN"(null, 
test, 999999999, 1234, 1234, 123, agr, ….. ) (class 
pl.(...).dao.generated.udt.records.TestParamInRecord)
TRACE StopWatch - Variables bound          : Total: 4.738ms, +0.63ms
TRACE StopWatch - Executing query          : Total: 5.093ms, +0.355ms
DEBUG StopWatch - Query executed           : Total: 14.079ms, +9.443ms
DEBUG StopWatch - Finishing                : Total: 14.338ms, +0.259ms
DEBUG StopWatch - Query executed           : Total: 14.916ms, +9.822ms
DEBUG StopWatch - Finishing                : Total: 15.124ms, +0.208ms

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 )
2. I need different logging schema for UDT
3. I need output from function
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

How should I approach these problems ?

-- 
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