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. 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? Cheers Lukas
