I'm creating an open source tool which needs to: 1. Extract a schema from a JDBC connection 2. Execute SQL to create a schema from scratch
It seems that jOOQ might have solved this problem in a database agnostic way... I've had a bit of a look at jOOQ-meta and it seems to be what I want. So, a couple of questions: 1. I can see the Database and SQLDialect classes which seem to be a generic way to access meta data and generate SQL. Are there any pieces of code I can look at to see the proper use for these classes? A good test case perhaps? 2. Can I use jOOQ-meta to extract the meta information from a JDBC connection (including tables, columns, column types, auto-increments, primary keys, foreign keys) 3. Can I use a jOOQ utility to create a schema based on a schema model? 3. Can I use a jOOQ util to generically insert into a table and retrieve the generated auto-increment in a database agnostic way? Please note that I'm creating a tool. I do not wish to generate the jOOQ model for a database. I want to use the generic "under the hood" utils that jOOQ uses. Thanks, Lance. -- 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/groups/opt_out.
