Great, I'll be in touch. On Fri, Feb 26, 2021 at 11:02 AM Walid CHAIB <[email protected]> wrote:
> Thanks a lot Lukas ! > > Yeah, i would like to test the new beta version, actually we are just > facing issues with implicit casting and with date functions, if that will > be resolved, it's a great achievement. > > > Le jeu. 25 févr. 2021 à 14:38, Lukas Eder <[email protected]> a écrit : > >> If nothing goes wrong, I'll be releasing 3.14.8 this afternoon, including >> the fix for the cast. Other than that, regarding the issues you've >> encountered with missing parser support for some Oracle specific functions >> like ADD_MONTHS() or LAST_DAY(), there's good news. The upcoming jOOQ >> 3.15.0 will ship with a new parser listener SPI that allows you to hook >> into the parser and parse your own syntax, including the possibility to >> translate that to different dialects. The feature is described here: >> >> - https://github.com/jOOQ/jOOQ/issues/10243 >> - >> https://www.jooq.org/doc/dev/manual/sql-building/sql-parser/sql-parser-listener/ >> >> So again, if you're interested in beta testing that on 3.15.0-SNAPSHOT, >> just let me know and I'll send you an extended trial license. >> >> Cheers, >> Lukas >> >> On Wednesday, February 24, 2021 at 12:57:46 PM UTC+1 Lukas Eder wrote: >> >>> Well, the fix is going to be implemented today: >>> https://github.com/jOOQ/jOOQ/issues/11511 >>> But I doubt it will be backported to 3.14, as there's are a few >>> subtleties that could produce regressions in edge cases. So, an extended >>> trial would give you access to the fix starting from tomorrow... >>> >>> On Wed, Feb 24, 2021 at 12:16 PM Walid CHAIB <[email protected]> >>> wrote: >>> >>>> Thanks a lot Lukas ! >>>> For us, if the next version come with the implicit casting that will be >>>> a big big treasure for us, that's the big issue that we have currently as >>>> you know oracle does the implicit casting unlike postgresql and we have a >>>> lot of requests to migrate i am looking forward impatiently to the next >>>> version. >>>> >>>> >>>> Le mer. 24 févr. 2021 à 11:55, Lukas Eder <[email protected]> a >>>> écrit : >>>> >>>>> Hi Walid, >>>>> >>>>> Thanks a lot for your message. We currently do not have an SPI for >>>>> custom syntax elements in the parser yet, but it would be very interesting >>>>> to create one. See: https://github.com/jOOQ/jOOQ/issues/10243 >>>>> >>>>> On the other hand, we can add additional functionality for you very >>>>> quickly, as support for individual functions like add_months or last_day >>>>> is >>>>> not that much work. Ideally, you could provide us with a list of what's >>>>> important to you in the short run (here or on a different support >>>>> channel), >>>>> and I'll be very happy to prioritise this accordingly. >>>>> >>>>> I also take from your previous messages on twitter or github, that >>>>> you're still evaluating jOOQ? We can provide you with a free extended >>>>> trial >>>>> license so you can download the latest 3.15.0-SNAPSHOT versions and work >>>>> with what's already implemented. 3.15 has already seen a lot of >>>>> improvements, and will see even more until we release. Besides, the >>>>> extended trial includes the source code, so you can assess how working >>>>> with >>>>> jOOQ will be once you make a purchasing decision (e.g. you'll be able to >>>>> apply your own modifications, so you don't have to wait for new releases). >>>>> If you're interested, please contact [email protected] for an >>>>> extended trial. >>>>> >>>>> Best Regards, >>>>> Lukas >>>>> >>>>> On Wed, Feb 24, 2021 at 10:30 AM Walid CHAIB <[email protected]> >>>>> wrote: >>>>> >>>>>> Hi Guys, >>>>>> >>>>>> Thanks for this great tool. >>>>>> >>>>>> I am working on migrating our project from oracle to postgresql 12 >>>>>> with jdbc and prepared statements, we are facing problems with date >>>>>> functions like add_months , last_day that don't exist in postgresql and >>>>>> jooq unable to convert it, i am wondering if there's a specific settings >>>>>> that i should do, sysdate also can not be converted. >>>>>> >>>>>> Thanks in advance >>>>>> >>>>>> -- >>>>>> 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]. >>>>>> To view this discussion on the web visit >>>>>> https://groups.google.com/d/msgid/jooq-user/25fd2664-9d69-4c81-8c53-c53a0ad3a34fn%40googlegroups.com >>>>>> <https://groups.google.com/d/msgid/jooq-user/25fd2664-9d69-4c81-8c53-c53a0ad3a34fn%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 [email protected]. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/jooq-user/CAB4ELO5KqRO4G22C6s5pbXQhwk5%2B7cgLoCMGdGYftAszq9ut2w%40mail.gmail.com >>>>> <https://groups.google.com/d/msgid/jooq-user/CAB4ELO5KqRO4G22C6s5pbXQhwk5%2B7cgLoCMGdGYftAszq9ut2w%40mail.gmail.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 [email protected]. >>>> >>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/jooq-user/CAOP4XxhsfzBWPuJHk%3DCxPNOPn-m42ShBPAV6G1g%2B%2BY5WFZ5BXw%40mail.gmail.com >>>> <https://groups.google.com/d/msgid/jooq-user/CAOP4XxhsfzBWPuJHk%3DCxPNOPn-m42ShBPAV6G1g%2B%2BY5WFZ5BXw%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "jOOQ User Group" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/jooq-user/Bcl-fj69yYM/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/jooq-user/b68ee345-ff5a-42f0-a0f5-b062f9d3b82fn%40googlegroups.com >> <https://groups.google.com/d/msgid/jooq-user/b68ee345-ff5a-42f0-a0f5-b062f9d3b82fn%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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/CAOP4Xxh_HcQExuNpTed1%3DJ%3DJs6%2Bc3vXdC4EnkjmWtbPVzB5NVQ%40mail.gmail.com > <https://groups.google.com/d/msgid/jooq-user/CAOP4Xxh_HcQExuNpTed1%3DJ%3DJs6%2Bc3vXdC4EnkjmWtbPVzB5NVQ%40mail.gmail.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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO7-L3ez2bHa7KzvZXHVZ-TMjtEGapdLMKjmUQhwTCAuhg%40mail.gmail.com.
