Syntax error in jOOQ select query

[ankitah...@gmail.com]

Hi,

Can someone pls help me the syntax error in the query below?

type Exception report

message SQL [select "empdb"."emp"."id", "empdb"."emp"."name", "empdb"."emp"."city" from "empdb"."emp" where "empdb"."emp"."id" = cast(? as int)]; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '."emp"."id", "empdb"."emp"."name", "empdb"."emp"."city" from "empdb"."emp" where' at line 1

Any help on this is very much appreciated. Thanks in advance!

Regards,

Ankita

[Lukas Eder]

Hello Ankita,

 

(I'm reproducing the same e-mail that I've sent you off this user group):

Thanks for your enquiry. You are not using the MySQL SQLDialect that you should provide your jOOQ Configuration with. This is why SQL standard “double quotes” are generated around your table / column names, instead of MySQL’s vendor-specific `back-ticks`. You’ll find some pointers here:

http://www.jooq.org/doc/latest/manual/sql-building/dsl-context

 

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 jooq-user+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.