JOOQ: generating update SQL for table named by String

Question

I just want to use JOOQ to generate SQL without it validating tables, columns, etc., and without it generating classes for said tables, columns, etc.

How can I generate a SQL update, and just specify the name of the schema & table with Strings?

Maybe later I'll setup the table-generated Java code, but it's not necessary right now. If I can't use JOOQ without such generated code, then I'll use some other library for now.

Thanks.

See also stackoverflow.com/q/27083958/521799

Lukas Eder
– Lukas Eder

2015-08-04 09:03:11 +00:00
Commented Aug 4, 2015 at 9:03 — Lukas Eder
– Lukas Eder, Commented Aug 4, 2015 at 9:03

Lukas Eder · Accepted Answer · 2015-08-04 09:06:52Z

3

You don't have to use source code generation to use jOOQ's DSL API. See, for instance:

In your case, given you want to generate a SQL update, how about:

// Assuming this static import
import static org.jooq.impl.DSL.*;

using(configuration)
   .update(table("my_table"))
   .set(field("id", Integer.class), 1)
   .set(field("value", String.class), "A")
   .where("x > ?", 3)
   .execute();

answered Aug 4, 2015 at 9:06

Lukas Eder

223k138 gold badges731 silver badges1.6k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

JOOQ: generating update SQL for table named by String

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related