Hi,
I'm using jOOQ as a simple SQL builder. The goal of my project is to
produce a list of SQL queries, not to run them.
To do so I access statically the DSL and create my INSERT with it.
temp = DSL.insertInto(table("distances"),
field("event_id"),
field("from"),
field("to"),
field("dist_km"))
.values(
x.getType(),
x.getFrom(),
x.getTo(),
x.getDistance()
)
.getSQL(ParamType.INLINED);
They query seems to work, but it miss all type of quotation. So the String
produced by that insertInto is like:
insert into distances (event_id, from, to, dist_km) values (3, 424, 10,
22.01);
but what I need is something like:
insert into `distances` (`event_id`, `from`, `to`, `dist_km`) values ('1',
'449', '2', '1.19');
I've tried switching from DSL to MySQLDSL and to use the factory DSLContext
mine = DSL.using(org.jooq.SQLDialect.MYSQL) with no result.
Any hint how to control the quotation of a query produced wth getSQL ?
Thanks in advance,
AL
--
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/d/optout.
