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]>: > 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]. > 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.
