Thanks, Lukas! I'll take a look later in documentation on how to implement my own implementation of LoggerListener.
But taking a look further into the method AbstractRecord.toString() <https://github.com/jOOQ/jOOQ/blob/master/jOOQ/src/main/java/org/jooq/impl/AbstractRecord.java#L1057> it seems like it uses the ResultImpl.toString() <https://github.com/jOOQ/jOOQ/blob/master/jOOQ/src/main/java/org/jooq/impl/ResultImpl.java#L1585> which in case uses a custom instance of TXTFormat: TXTFormat.DEFAULT.maxRows(50).maxColWidth(50) If I understood correctly, based on this line of code above, jOOQ logger should show the maximum of 50 columns, but it's only showing 6. Do you know why it's not using this settings? On Wednesday, June 13, 2018 at 10:26:50 AM UTC-3, Lukas Eder wrote: > > Hi Rafael, > > Thanks for your message. > > What you're seeing here is the output of the LoggerListener, which > provides default, out-of-the-box debug logging for jOOQ. The particular > problem you're running into is a width limitation of the Record.format() > method, which is a sane precaution for situations where you might have LOBs > with millions of bytes of data - it would be unwise to spill those to the > log by default. In the LoggerListener, the Routine results are put in a > Record in order to be able to reuse existing formatting logic. This might > change in the future, of course. > > You can always override the default LoggerListener behaviour by > implementing your own LoggerListener (an implementation of > ExecuteListener), and turn off the default behaviour through > Settings.executeLogging. > > I hope this helps, > Lukas > > Am Mi., 13. Juni 2018 um 15:17 Uhr schrieb Rafael Ponte <[email protected] > <javascript:>>: > >> Hi guys, >> >> I'd like to know if it's possible to configure jOOQ to show all out >> parameters when executing a stored procedure. Is it? >> >> I mean, when executing this function >> <https://gist.github.com/rponte/e5880a719a01eeb40521257c74ac7a34#file-mdb_sgc_apurador_pkg-sql> >> >> from a package in Oracle 11g XE via jOOQ v3.10.7 I get this output >> <https://gist.github.com/rponte/e5880a719a01eeb40521257c74ac7a34#file-jooq-logger-log> >> : >> >> 09:58:09 DEBUG [LoggerListener ] ... >> >> 09:58:09 DEBUG [LoggerListener ] Fetched OUT parameters : >> +--------------------------------------------------+ >> 09:58:09 DEBUG [LoggerListener ] : >> |RETURN_VALUE | >> 09:58:09 DEBUG [LoggerListener ] : >> +--------------------------------------------------+ >> 09:58:09 DEBUG [LoggerListener ] : |(81, 1, >> 'MENSAL', 1, 362, '8472999000183', 'JAN...| >> 09:58:09 DEBUG [LoggerListener ] : >> +--------------------------------------------------+ >> >> 09:58:09 DEBUG [LoggerListener ] ... >> >> >> Notice the return value is not showing all out parameters. My function >> returns a Record Type with 13 attributes (columns) >> <https://gist.github.com/rponte/e5880a719a01eeb40521257c74ac7a34#file-mdb_sgc_apurador_pkg-sql-L8-L22>, >> >> but the logger is showing only 6 of them! >> >> I configured my log4j.properties >> <https://gist.github.com/rponte/e5880a719a01eeb40521257c74ac7a34#file-log4j-properties> >> >> to set jOOQ logger as debug: >> >> log4j.logger.org.jooq=debug >> >> I'm using Spring and my jOOQ configuration >> <https://gist.github.com/rponte/e5880a719a01eeb40521257c74ac7a34#file-jooqconfig-java> >> >> is like this: >> >> DefaultConfiguration jooqConfiguration = new DefaultConfiguration(); >> jooqConfiguration >> .set(connectionProvider) >> .set(new DefaultExecuteListenerProvider(exceptionTransformer())) >> .set(SQLDialect.ORACLE11G) >> .set(new Settings() >> .withRenderFormatted(false) >> .withRenderCatalog(false) >> .withRenderSchema(false) >> .withRenderNameStyle(RenderNameStyle.AS_IS)); >> >> Maybe I'm missing something. >> >> Any tip? >> >> -- >> 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] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > -- 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.
