I'm pretty sure jOOQ can map all of the things you want to map! But as long as you don't ask the question of what you want to do *specifically*, I won't be able to answer it. I mean, you can't use JPA annotations to map things (the Y in your question). But you don't want to use JPA annotations, you want to map things. You can map nested collections and nested records (the X in your question), but not with JPA annotations. How about an example? What specific example would illustrate how you'd like to map things?
On the other hand, perhaps I can just direct you to the relevant docs of how to do things in jOOQ? - https://blog.jooq.org/jooq-3-15s-new-multiset-operator-will-change-how-you-think-about-sql/ - https://www.jooq.org/doc/latest/manual/sql-building/column-expressions/multiset-value-constructor/ - https://www.jooq.org/doc/latest/manual/sql-building/column-expressions/nested-records/ - https://www.jooq.org/doc/latest/manual/sql-execution/fetching/ad-hoc-converter/ Also useful: - Coming from JPA: https://www.jooq.org/doc/latest/manual/coming-from-jpa/ - OneToOne and ManyToOne: https://www.jooq.org/doc/latest/manual/coming-from-jpa/from-jpa-manytoone/ - OneToMany and ManyToMany: https://www.jooq.org/doc/latest/manual/coming-from-jpa/from-jpa-onetomany/ It will be helpful to let go of "It must work just like in JPA" and embrace "How can I make it work with jOOQ?" Hope this helps, Lukas On Tue, Oct 18, 2022 at 11:27 AM akash verma <[email protected]> wrote: > Yes, you are right I want some sort of mapping and JOOQ is not able to > do so as of now. > > Thank you. > > On Tuesday, 18 October 2022 at 12:50:58 UTC+5:30 [email protected] wrote: > >> We're clearly deep into https://xyproblem.info land. You want to do X >> (some sort of mapping?), and you think you can achieve X using Y (JPA >> annotations). But that's not how jOOQ works. >> >> Let's start over again: What do you want to do? >> >> On Tue, Oct 18, 2022 at 6:50 AM akash verma <[email protected]> wrote: >> >>> if able to do then we can use that POJOs and DAOs for the CRUD Api, if >>> two tables have relationship like (OneToMany). >>> As of now we are not able to get anything from the Pojos to know the >>> realtionship. >>> >>> On Tuesday, 18 October 2022 at 00:08:56 UTC+5:30 [email protected] >>> wrote: >>> >>>> And why would jOOQ do that? >>>> >>>> Am Montag, 17. Oktober 2022 schrieb akash verma <[email protected]>: >>>> >>>>> I got my answer. >>>>> >>>>> Thank you so much, Lukas. I'm eagerly waiting for the JOOQ update in >>>>> which JOOQ is able to do mapping annotations in POJO classes like >>>>> (@OneToOne, @OneToMany). >>>>> >>>>> On Monday, 17 October 2022 at 22:16:45 UTC+5:30 [email protected] >>>>> wrote: >>>>> >>>>>> jOOQ-meta runs its own queries against the information schema / >>>>>> catalogs / dictionary views, etc. JDBC DatabaseMetaData is insufficient. >>>>>> >>>>>> I think the manual links I've shown sufficiently explain how the >>>>>> "connection free code generation" works? >>>>>> >>>>>> You might have a *specific* question, but I didn't see it yet... >>>>>> >>>>>> On Mon, Oct 17, 2022 at 6:12 PM akash verma <[email protected]> >>>>>> wrote: >>>>>> >>>>>>> I want to know how the JOOQ get the Metadata from the Database in >>>>>>> the Connection code generation mode. Does it use the >>>>>>> connection.getMetaData() method? >>>>>>> >>>>>>> and In connection-free code generation modes how JOOQ Get the >>>>>>> MetaData from the Script OR XML file? >>>>>>> >>>>>>> >>>>>>> On Monday, 17 October 2022 at 20:37:12 UTC+5:30 [email protected] >>>>>>> wrote: >>>>>>> >>>>>>>> I'm not sure what exactly you're looking for, but these are some >>>>>>>> out of the box alternatives to connecting to a live database instance >>>>>>>> for >>>>>>>> code generation: >>>>>>>> >>>>>>>> - >>>>>>>> https://www.jooq.org/doc/latest/manual/code-generation/codegen-jpa/ >>>>>>>> - >>>>>>>> https://www.jooq.org/doc/latest/manual/code-generation/codegen-xml/ >>>>>>>> - >>>>>>>> https://www.jooq.org/doc/latest/manual/code-generation/codegen-ddl/ >>>>>>>> - >>>>>>>> https://www.jooq.org/doc/latest/manual/code-generation/codegen-liquibase/ >>>>>>>> >>>>>>>> Note that it's not uncommon to spin up a "live" database using >>>>>>>> testcontainers just for code generation (and integration testing): >>>>>>>> >>>>>>>> - https://blog.jooq.org/using-testcontainers-to-generate-jooq-code/ >>>>>>>> >>>>>>>> I hope this helps, >>>>>>>> Lukas >>>>>>>> >>>>>>>> On Mon, Oct 17, 2022 at 9:07 AM akash verma <[email protected]> >>>>>>>> wrote: >>>>>>>> >>>>>>>>> Hello lukas, >>>>>>>>> >>>>>>>>> First of all, thank you for all your replies and for such quick >>>>>>>>> support. I am really thankful. >>>>>>>>> >>>>>>>>> I want to ask as of now JOOQ is generating the POJOS from the SQL >>>>>>>>> Script and Databases. >>>>>>>>> Did JOOQ have different methods for reading from scripts and from >>>>>>>>> databases? >>>>>>>>> >>>>>>>>> for example:- >>>>>>>>> "Assume that as of now, JOOQ is generating Pojos only from the >>>>>>>>> Databases and we want to generate it from the Script now, how and >>>>>>>>> where we >>>>>>>>> should inject our script in JOOQ?" >>>>>>>>> >>>>>>>>> -- >>>>>>>>> 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/cf4068f3-0cf3-4ec3-89f5-3985b5448af1n%40googlegroups.com >>>>>>>>> <https://groups.google.com/d/msgid/jooq-user/cf4068f3-0cf3-4ec3-89f5-3985b5448af1n%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/6d80a3ce-327d-4c76-89c4-5e3918cc251cn%40googlegroups.com >>>>>>> <https://groups.google.com/d/msgid/jooq-user/6d80a3ce-327d-4c76-89c4-5e3918cc251cn%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/c61eea28-2172-4357-9755-93917200e5cbn%40googlegroups.com >>>>> <https://groups.google.com/d/msgid/jooq-user/c61eea28-2172-4357-9755-93917200e5cbn%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/ad87caeb-07fe-4bba-b5b6-426d769eb87en%40googlegroups.com >>> <https://groups.google.com/d/msgid/jooq-user/ad87caeb-07fe-4bba-b5b6-426d769eb87en%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/11ffeaf7-79c2-4bcf-bac2-c928af69cd15n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/11ffeaf7-79c2-4bcf-bac2-c928af69cd15n%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/CAB4ELO5_D0SDnZz8GZfk8vVaWXptnAq4ohTA7TzZj3hR-6t%2B3Q%40mail.gmail.com.
