Hi Ahmed, Thank you for your message. Can you please show an example with details about what you mean, specifically?
Best regards, Lukas On Mon, Mar 18, 2024 at 3:54 PM Ahmed Ghanmi <ahmed.ghan...@gmail.com> wrote: > Hello Lukas, > > In our Oracle->PG migration, we are using JOOQ's ParsingConnection to > translate between dialects. > > Similar to https://github.com/jOOQ/jOOQ/issues/11757, we are facing > issues with Oracle's NULL and empty string equivalence. > The assumption is prelevant across the codebase as we have a lot of code > that expects setString('', i) to be nullified. > This is especially problematic when done on FK columns, as pg would > complain for violating it (otherwise I wouldn't have found out about this > haha). > > The first straight-forward solution on our side is to add empty checks > everywhere, but I am trying to avoid this path for obvious reasons. > I wonder if JOOQ could do something about this, or if there is an > equivalent to ParseListener for binding that would allow more flexibility > in that area. > > jooq version : 3.19.6 > target sql dialect : POSTGRES_12 > settings : > Settings settings = new Settings() > .withParseDialect(SQLDialect.ORACLE) > .withParseUnknownFunctions(ParseUnknownFunctions.IGNORE) > .withTransformTableListsToAnsiJoin(true) // transform (+) to left outer > join > > .withTransformUnneededArithmeticExpressions(TransformUnneededArithmeticExpressions.ALWAYS) > .withTransformRownum(Transformation.ALWAYS) > .withParamType(ParamType.INLINED) > .withParamCastMode(ParamCastMode.DEFAULT) > .withRenderOptionalAsKeywordForFieldAliases(RenderOptionalKeyword.ON) > .withRenderOptionalAsKeywordForTableAliases(RenderOptionalKeyword.ON) > .withRenderQuotedNames(RenderQuotedNames.EXPLICIT_DEFAULT_UNQUOTED) > .withRenderNameCase(RenderNameCase.UPPER) > .withRenderCoalesceToEmptyStringInConcat(true); > > -- > 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 jooq-user+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/60920cfc-5e40-4cfe-abff-c8831817b304n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/60920cfc-5e40-4cfe-abff-c8831817b304n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 jooq-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO42o7E1PjT9LfukNjHFVvXP0Yx%2BO5rmrCmxJOm4hYt5-w%40mail.gmail.com.
