Hi - I want to give jOOQ a chance while I refactor my Java-SQL code. I use MySQL and Java 7.
Throughout the years I've created a rather complex StringRegex->PreparedStatement->ResultSet queries using only Java and JDBC. Why? I have a few tables (say 5) for each customer (100s-1000s customers) and for each table I have several proxy tables for different aggregations (needed optimization) so I had to create a "prepared statement" for table names. I only query one customer a time, so the "transaction" doesn't care about the tables of other customers. This separation also enables to scale the database instance out. 1) Is there something similar in jOOQ where I can put a parameterized table name? 2) Today I have a request logic that will pick the correct table. Is there a way to "combine" that with the jOOQ level? Or will I have to separate it as a different layer? (also relevant to the optional multiple connection pools) 3) When inserting data, I insert to all of the tables using INSERT .. ON DUPLICATE KEY UPDATE with several updates (comma separated). Is that supported? I'm excited to get started! but really wish to get some information before diving in to the API and tradeoffs. Thanks! -- 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.
