On Sat, 2012-05-19 at 14:27 +0200, Lukas Eder wrote: > Hello Murray, > > > Does jOOQ have any Java API for creating a database and then creating > > tables within that database? I mean, other than just concatenating > > strings to build a raw SQL command and then execute()ing that. > > This has been on the roadmap for a while: > https://sourceforge.net/apps/trac/jooq/ticket/883 > > Currently, the TRUNCATE statement is the only DDL statement supported > by jOOQ. The problem with DDL is the fact that it is far less trivial > to find a sensible common API for all 13 supported databases. While it > will be easy to allow for a couple of simple create table statements, > constraints, indexes, and alter table commands are a lot less > standardised.
Yes, I agree. Hopefully there is some simple sub-set at least. > Nevertheless, this should be implemented for completeness, also > because Apache GORA will rely on this, soon. I'll increase the > priority of #883 again. What kind of features do you need most? Nothing complicated. Just creating the empty database and then adding the tables, with the field (column) definitions. I could also use API to add or later field (column) definitions, but that's less important for me. Thanks. -- [email protected] www.murrayc.com www.openismus.com
