Hello, It looks like you're still using the SQLDialect.ORACLE to generate your SQL string, when you're running the routine on PostgreSQL - could that be the case?
Thanks, Lukas On Thu, Aug 16, 2018 at 4:44 PM <[email protected]> wrote: > I'm trying to port a jOOQ-based application from Oracle to PostgreSQL, and > I'm getting exceptions from inside the jOOQ code. > It's throwing a DataAccessException on SQL [begin update > "public"."locked_out_users" set "public"."locked_out_users"."description" = > ?, "public"."locked_out_users"."locked_out" = ?, > "public"."locked_out_users"."name" = ?, > "public"."locked_out_users"."invalid_login_attempts" = ? where > "public"."locked_out_users"."user_id" = ? returning > "public"."locked_out_users"."user_id" into ?; end;]; > Caused by: org.postgresql.util.PSQLException: This statement does not > declare an OUT parameter. Use { ?= call ... } to declare one. > > I'm not sure what I need to do to correct this, since it's inside > generated code and I have no idea how I can control parameter declarations. > Is this something that has been fixed in a recent version? I'm using 3.8 > because of API compatibility with the existing codebase, but if it's a > known and corrected issue I can try to upgrade. > > -- > 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.
