Ah yes, I totally missed that. Do you recall what may have been the rationale behind duplicating the variable? I don't recall any changes in jOOQ that would have produced the regression you've encountered. Did you perhaps also update the JDBC driver at the same time? Recent pgjdbc versions implemented a feature where ?? is now the way to escape the ? character if you want to use the ? operator, e.g. for JSON. See: https://stackoverflow.com/q/38370972/521799
On Tue, Mar 28, 2023 at 7:42 PM Sahil Dogra <[email protected]> wrote: > > Thank you both for your responses, I was actually just able to figure out > my issue! Changing the line > > > bindingSQLContext.render().sql(bindingSQLContext.variable()).sql("?::jsonb"); > to > bindingSQLContext.render().sql("?::jsonb"); > > resolved it. > > On Tuesday, March 28, 2023 at 5:07:22 AM UTC-4 Lukas Eder wrote: > >> For the record, I'm fine with screenshots. >> >> On Monday, March 27, 2023 at 11:52:39 PM UTC+2 [email protected] wrote: >> >>> On 3/27/23 14:43, Sahil Dogra wrote: >>> > Hello, I am currently working on migrating jOOQ from version 3.11.3 to >>> > 3.14.9 and making all the necessary changes. For the most part, the >>> > migration is complete, but when I deploy my code and >>> > insertions/updates are made (via DSLContext's executeInsert and >>> > executeUpdate) to our Postgres DB via jOOQ DSL methods, for resources >>> > that have been created via jOOQ code generation from a production >>> > table, I am encountering an indexing issue. >>> >>> (Always best to copy paste text rather than screen shots) >>> You might need to look at the exact classpaths in play as you run your >>> tests: The code and the database disagree on at least one table so I >>> suspect you're pointing new code at old database or vice versa. >>> >>> >>> -- > 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]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/571135e3-0703-41a0-a85c-69c5ce749334n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/571135e3-0703-41a0-a85c-69c5ce749334n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO7rY5nprD_CfAb27TJiGVgbjOQEAFNtby%2BcS-4hmaCBzg%40mail.gmail.com.
