Cannot find the $ prefix used for named parameters in generated SQL about jooq HOT 3 CLOSED

Thanks for your message.

But how are you using jOOQ? I don't see why the $ prefix is important to you. You're not using R2DBC, I take? Nor the parser?

Can you show an example of a jOOQ query that doesn't work for you, and how you execute/parse/use it, etc.?

from jooq.

I submitted queries in PL/pgSQL format, but I decided to use a simple query in the format of
SELECT country_id FROM country WHERE name = $1.

which is passed to the method along with an array of parameters

int affectedRows = dsl.query(parameters.getSql(), parameters.getSqlParameters()).execute();

at the moment of entering the query method it throws the error “parameter $1 does not exist”, but when I use :1 the data is substituted as it should be. You are right I don't use R2DBC.

from jooq.

Ah, I see what you're trying to do. jOOQ's plain SQL templates don't support alternative named parameter prefixes yet, see:

• #8822

There's currently no workaround for this. I hope this helps.

from jooq.