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.
