Hi guys!
I think Lukas is wrong. The easiest way to add a semicolon is just to...
add it:
String sql = DSL.using(myConfiguration)
.update(...)
.set(...)
.where(...)
.getSQL(ParamType.INLINED) + ';';
Voilà! :-)
Regards,
Witold Szczerba
14 mar 2015 11:15 "Lukas Eder" <[email protected]> napisał(a):
> Hi Rohit,
>
> The *easiest* way would be to implement an ExecuteListener and hook into
> the renderEnd() event, adding the semi-colon to your query:
>
> http://www.jooq.org/doc/latest/manual/sql-building/dsl-context/custom-execute-listeners/
>
> So, you'd have to setup your own DefaultConfiguration and pass it to
> DSL.using:
>
> String sql = DSL.using(myConfiguration)
> .update(...)
> .set(...)
> .where(...)
> .getSQL(ParamType.INLINED);
>
> Note that once you're working with your own DefaultConfiguration, you
> might as well add a Setting to enforce the inlining of bind variables:
>
> http://www.jooq.org/doc/latest/manual/sql-building/dsl-context/custom-settings/
>
> That can be achieved with the StatementType.STATIC_STATEMENT setting.
>
> Hope this helps,
> Lukas
>
> 2015-03-13 23:48 GMT+01:00 Rohit <[email protected]>:
>
>> Hi,
>> I am using jOOQ as a simple SQL builder for Postgres database with inline
>> parameters:
>>
>> String sql = DSL.using(SQLDialect.POSTGRES)
>> .update(MY_TABLE)
>> .set(A, 1)
>> .where(B.greaterThan(5))
>> .getSQL(ParamType.INLINED);
>>
>> This returns: "update MY_TABLE set A = 1 where B > 5"
>>
>> Is there way to add a semicolon at the end in that result?
>>
>> Thanks for your help!
>>
>> - Rohit
>>
>> --
>> 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.
>>
>
> --
> 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.
>
--
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.
