Hi, Can somebody please direct me to an example project or discussion where one can mix in tables/records from various modules into a single DSL context. To elaborate - what I find not too obvious (and that not only goes for Jooq but also most other JDBC "orm" libraries for that matter) is how to have one database divided into its constituent logical parts as different Java JARs/modules; and make them participate in the same context (fairly dynamically).
Here is a conceptual example. Same schema/database where: User, Group, UserInGroup, its management etc is in one Java module Document, Version, Meta is in another Java module A third projec that is able to pull these 2 together over a single context and execution within the same transaction context. This also leads to another question in that I can only find Jooq filter of tables by schema. Is there any way that I can filter tables for creation in the project based on table name pattern or manual selection. Not all tables within the same database is part of the same module (jar). BTW - I am trying to do this using Spring; I don't however think that it matters as the problem I am describing is not specific to Spring. Note: For the module segregation issue described above; I have found that all "smart" Db technologies like JPA etc makes this very hard - and that the safest route usually is plain JDBC or JDBC with a very simple JDBC assist layer - this however means writing reams of SQL as well as a separation between your code and the underlying structure; which leads to significant run time risk or/and a lot more work. Regards, Gawie -- 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.
