execute a select with sql parameters

[bernie....@nurego.com]

Hi,

I have some fairly complex analytical queries on vertica using sql bind parameters - I can't seem to find a way to do this with jooq... can someone point me in the right direction?

Cheers,

Bernie 

[Lukas Eder]

Hi Bernie,

Thanks for your message. All values that you pass to a jOOQ query are sent to the server as bind variables behind the scenes. Some details can be found here:

- https://www.jooq.org/doc/latest/manual/sql-execution/statement-type

- https://www.jooq.org/doc/latest/manual/sql-building/bind-values/indexed-parameters

If you mean to use the plain SQL API, you can pass the bind values that correspond to any plain SQL string directly to the constructing API, as documented here:

https://www.jooq.org/doc/latest/manual/sql-building/plain-sql

I hope this helps. Please let me know if you have any additional questions.

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