All the dependencies are documented in the pom.xml file of the relevant artifact. Use mvn dependency:tree on your project to visualise them
On Mon, Mar 20, 2023 at 9:52 AM deepankar gupta < deepankargupta1...@gmail.com> wrote: > Hi Lucas, > Is there any documentation I can refer to, to get all list of dependencies > compatible with jooq 3.17.5?? > > Regards > Deepankar Gupta > > On Monday, March 20, 2023 at 2:10:13 PM UTC+5:30 lukas...@gmail.com wrote: > >> Hi Deepankar, >> >> ChatGPT produces inaccurate results. See: >> >> https://www.google.com/search?q=chatgpt+results+inaccurate&oq=chatgpt+results+inaccurate >> >> The mere fact that this output suggest you add soap to your list of >> dependencies should be a red flag. >> >> I hope this helps, >> Lukas >> >> On Mon, Mar 20, 2023 at 9:16 AM deepankar gupta <deepankar...@gmail.com> >> wrote: >> >>> Hi Lucas, >>> >>> Can you please help me with external dependencies that is compatible >>> with jooq 3.17.5. From chatgpt, I come up with below dependencies: >>> >>> Here are the external dependencies used by jOOQ 3.17.5: >>> >>> - asm: 7.2 (Apache License 2.0) >>> - cglib: 3.3.0 (Apache License 2.0) >>> - jakarta.activation: 1.2.2 (Apache License 2.0) >>> - jakarta.annotation-api: 1.3.5 (Eclipse Public License 2.0) >>> - jakarta.xml.bind-api: 2.3.3 (Eclipse Public License 2.0) >>> - jakarta.xml.soap-api: 1.4.2 (Eclipse Public License 2.0) >>> - jakarta.xml.ws-api: 2.3.3 (Eclipse Public License 2.0) >>> - javax.activation: 1.2.0 (Common Development and Distribution >>> License 1.0) >>> - javax.xml.bind: 2.3.3 (Common Development and Distribution License >>> 1.0) >>> - javax.xml.soap: 1.4.0 (Common Development and Distribution License >>> 1.0) >>> - javax.xml.ws: 2.3.3 (Common Development and Distribution License >>> 1.0) >>> - jdom2: 2.0.6 (Apache License 2.0) >>> - log4j-api: 2.14.1 (Apache License 2.0) >>> - log4j-core: 2.14.1 (Apache License 2.0) >>> - org.eclipse.jdt.core.compiler: 3.25.0 (Eclipse Public License 1.0) >>> - org.jooq: jooq-meta: 3.17.5 (Apache License 2.0) >>> - org.jooq: jooq-codegen: 3.17.5 (Apache License 2.0) >>> - org.postgresql: postgresql: 42.2.18 (BSD-style license) >>> - org.slf4j: slf4j-api: 1.7.30 (MIT License) >>> >>> Do let me know if any dependency is missing or version is not correct. >>> >>> Regards >>> Deepankar Gupta >>> On Friday, March 17, 2023 at 2:59:58 PM UTC+5:30 deepankar gupta wrote: >>> >>>> Hi Lucas, >>>> Thanks for such in-depth insights. Yeah it solves my problem >>>> >>>> Regards >>>> Deepankar Gupta >>>> >>>> On Thursday, March 16, 2023 at 1:50:45 PM UTC+5:30 lukas...@gmail.com >>>> wrote: >>>> >>>>> Hi Deepankar, >>>>> >>>>> Thanks a lot for your message. That's an interesting approach, I can >>>>> see how that works for you. The fact that you're implementing interfaces >>>>> like these (especially the one that is called QueryPartInternal) hints at >>>>> there being a feature request hidden in there somewhere. Things can break >>>>> when implementing internal interfaces. Besides, we'll "soon" seal the >>>>> entire DSL type hierarchy, because most attempts at implementing the DSL >>>>> API (e.g. Constraint) should also be considered tweaking internals and are >>>>> usually not the best way to achieve something. >>>>> >>>>> I'd love to get a bit more context on your use-case here. It seems >>>>> that you would like to add some DDL clause support to your constraints >>>>> when >>>>> using jOOQ's CREATE TABLE or ALTER TABLE support? Is it this feature >>>>> you're >>>>> looking for? >>>>> https://github.com/jOOQ/jOOQ/issues/10363 >>>>> >>>>> Maybe, it's worth investigating also the option of supporting plain >>>>> SQL TableElement and CustomTableElement implementations, which allow for >>>>> adding arbitrary clauses to DDL statements, which jOOQ doesn't support >>>>> (yet). I've created a feature request for this: >>>>> https://github.com/jOOQ/jOOQ/issues/14807 >>>>> >>>>> Back to what broke here, the internal rendering API got changed a long >>>>> time ago with: >>>>> https://github.com/jOOQ/jOOQ/issues/3323 >>>>> >>>>> And the old internal API was removed with: >>>>> https://github.com/jOOQ/jOOQ/issues/11495 >>>>> >>>>> This change allows for traversing an expression tree only once to do >>>>> both actions in one go: >>>>> - SQL generation >>>>> - Bind value collection >>>>> >>>>> In any case, I think you already correctly implemented the interfaces, >>>>> with your accept() method. You can now just remove the toSQL() and bind() >>>>> methods, which are no longer necessary. >>>>> Does that solve your problem? >>>>> >>>>> Best Regards, >>>>> Lukas >>>>> >>>>> On Thu, Mar 16, 2023 at 9:06 AM deepankar gupta < >>>>> deepankar...@gmail.com> wrote: >>>>> >>>>>> Hi Lucas, >>>>>> >>>>>> I am trying to upgrade jooq version from 3.14.6 to 3.17.5. We have >>>>>> implemented 2 interfaces Constraint and QueryPartInternal. And also >>>>>> overridden toSQL(RenderContext ctx) and bind(BindContext ctx) methods but >>>>>> in jooq version 3.17.5 these methods are not there anymore. Need help on >>>>>> how these 2 methods implementation should look like in jooq version >>>>>> 3.17.5 >>>>>> >>>>>> Code Snippet: >>>>>> private interface ConstraintInternal extends Constraint, >>>>>> QueryPartInternal { >>>>>> >>>>>> } >>>>>> >>>>>> private Constraint useDeferrableConstraint(Constraint delegate){ >>>>>> return new ConstraintInternal() { >>>>>> >>>>>> @Override >>>>>> public void accept(Context<?> ctx) { >>>>>> ((QueryPartInternal) (delegate)).accept(ctx); >>>>>> if (join.from().isPartitioned()) { >>>>>> ctx.sql(" deferrable initially deferred not >>>>>> valid"); >>>>>> } else { >>>>>> ctx.sql(" deferrable initially deferred"); >>>>>> } >>>>>> } >>>>>> >>>>>> @Override >>>>>> public boolean rendersContent(Context<?> ctx) { >>>>>> return ((QueryPartInternal) >>>>>> (delegate)).rendersContent(ctx); >>>>>> } >>>>>> >>>>>> //Need help on this method(Not there anymore in jooq >>>>>> 3.17.5) >>>>>> @Override >>>>>> public void toSQL(RenderContext ctx) { >>>>>> ((QueryPartInternal) (delegate)).toSQL(ctx); >>>>>> } >>>>>> >>>>>> //Need help on this method(Not there anymore in jooq >>>>>> 3.17.5) >>>>>> @Override >>>>>> public void bind(BindContext ctx) throws >>>>>> DataAccessException { >>>>>> ((QueryPartInternal) (delegate)).bind(ctx); >>>>>> } >>>>>> >>>>>> @Override >>>>>> public Clause[] clauses(Context<?> ctx) { >>>>>> return ((QueryPartInternal) (delegate)).clauses(ctx); >>>>>> } >>>>>> >>>>>> @Override >>>>>> public boolean declaresFields() { >>>>>> return ((QueryPartInternal) >>>>>> (delegate)).declaresFields(); >>>>>> } >>>>>> >>>>>> @Override >>>>>> public boolean declaresTables() { >>>>>> return ((QueryPartInternal) >>>>>> (delegate)).declaresTables(); >>>>>> } >>>>>> >>>>>> @Override >>>>>> public boolean declaresWindows() { >>>>>> return ((QueryPartInternal) >>>>>> (delegate)).declaresWindows(); >>>>>> } >>>>>> >>>>>> @Override >>>>>> public boolean declaresCTE() { >>>>>> return ((QueryPartInternal) (delegate)).declaresCTE(); >>>>>> } >>>>>> >>>>>> //Need to override this method in jooq 3.17.5 >>>>>> @Override >>>>>> public boolean declaresParameters() { >>>>>> return false; >>>>>> } >>>>>> >>>>>> @Override >>>>>> public boolean generatesCast() { >>>>>> return ((QueryPartInternal) >>>>>> (delegate)).generatesCast(); >>>>>> } >>>>>> >>>>>> @Override >>>>>> public String getName() { >>>>>> return delegate.getName(); >>>>>> } >>>>>> >>>>>> @Override >>>>>> public Name getQualifiedName() { >>>>>> return delegate.getQualifiedName(); >>>>>> } >>>>>> >>>>>> @Override >>>>>> public Name getUnqualifiedName() { >>>>>> return delegate.getUnqualifiedName(); >>>>>> } >>>>>> >>>>>> @Override >>>>>> public String getComment() { >>>>>> return delegate.getComment(); >>>>>> } >>>>>> >>>>>> @Override >>>>>> public Comment getCommentPart() { >>>>>> return delegate.getCommentPart(); >>>>>> } >>>>>> >>>>>> //Need to override this method in jooq 3.17.5 >>>>>> @Override >>>>>> public @org.jetbrains.annotations.NotNull Name $name() { >>>>>> return delegate.$name(); >>>>>> } >>>>>> >>>>>> @Override >>>>>> public String toString() { >>>>>> if (join.from().isPartitioned()) { >>>>>> return delegate.toString() + " deferrable >>>>>> initially deferred not valid"; >>>>>> } else { >>>>>> return delegate.toString() + " deferrable >>>>>> initially deferred"; >>>>>> } >>>>>> } >>>>>> >>>>>> //Need to override this method in jooq 3.17.5 >>>>>> @Override >>>>>> public <R> R $traverse(Traverser<?, R> traverser) { >>>>>> return delegate.$traverse(traverser); >>>>>> } >>>>>> >>>>>> //Need to override this method in jooq 3.17.5 >>>>>> @Override >>>>>> public @org.jetbrains.annotations.NotNull QueryPart >>>>>> $replace(Replacer replacer) { >>>>>> return delegate.$replace(replacer); >>>>>> } >>>>>> }; >>>>>> } >>>>>> >>>>>> -- >>>>>> 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+...@googlegroups.com. >>>>>> To view this discussion on the web visit >>>>>> https://groups.google.com/d/msgid/jooq-user/71aaa0ae-71f0-450b-b3ec-db081635ddfen%40googlegroups.com >>>>>> <https://groups.google.com/d/msgid/jooq-user/71aaa0ae-71f0-450b-b3ec-db081635ddfen%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+...@googlegroups.com. >>> >> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/jooq-user/54ce08d5-a418-4672-be35-fa4f222533c1n%40googlegroups.com >>> <https://groups.google.com/d/msgid/jooq-user/54ce08d5-a418-4672-be35-fa4f222533c1n%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/721760f4-b94a-451b-971c-242176ddee85n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/721760f4-b94a-451b-971c-242176ddee85n%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/CAB4ELO4YNootwc8Pukbf1pd5dfYPgjvvtp6MK9%2B7pQJY-ajGCA%40mail.gmail.com.
