Hi David,
2013/7/10 David Lee <[email protected]> > I converted most parts of my code to use jooq now however, there is a part > I could not do without using a raw query. > > > create.query("CREATE TEMPORARY TABLE desctable( `stylenumber` varchar(20), > `description` text, UNIQUE KEY `stylenumber` (`stylenumber`) )") > create.query("drop table desctable") > > > Any way to change this part to using normal jooq code? If by "normal" you mean using jOOQ's typesafe DSL API, then the above DDL statements are currently not supported. Support is on the long-term roadmap but hasn't been a priority so far: https://github.com/jOOQ/jOOQ/issues/883 Note, though that you could generate desctable artefacts from a regular table and make that generated code part of your codebase. You could then use generated artefacts to inline into your plain SQL statement: create.query("CREATE TEMPORARY TABLE {0}({1} VARCHAR(20), {2} TEXT, UNIQUE KEY {1}({1})", DESCTABLE, DESCTABLE.STYLENUMBER, DESCTABLE.DESCRIPTION); create.query("DROP TABLE {0}", DESCTABLE); This might be useful if you have lots of temporary tables like that. Cheers Lukas -- 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.
