Yeah, that configuration you've shown is the code generator configuration. The code generator doesn't run any update statements, so there had to be another configuration somewhere. Glad you've found it!
On Thu, Aug 16, 2018 at 5:24 PM <[email protected]> wrote: > Wait, I see it now, buried in the initialization of another third-party > library. It's setting it to ORACLE. >< > > On Thursday, August 16, 2018 at 11:13:59 AM UTC-4, Carl Burke wrote: >> >> I'm not actually setting the SQL dialect anywhere, just the JDBC, the >> database and the artefacts to generate: >> >> <configuration> >> <jdbc> >> <driver>org.postgresql.Driver</driver> >> <url>${postgresql.jdbc.url}</url> >> <user>${postgresql.jdbc.user}</user> >> <password>${postgresql.jdbc.password}</password> >> </jdbc> >> <generator> >> <!-- <name>org.jooq.util.DefaultGenerator</name> >> --> >> <database> >> >> <name>org.jooq.util.postgres.PostgresDatabase</name> <!-- change util to >> meta for 3.11.2 --> >> <includes>.*</includes> >> >> <excludes>_.*|st_value.*|st_histogram|st_pixel.*|st_dump.*|st_approx.*|st_quantile.*</excludes> >> <inputSchema>public</inputSchema> >> <customTypes> >> <customType> >> <name>Geometry</name> >> >> <type>com.vividsolutions.jts.geom.Geometry</type> >> >> <binding>net.dmitry.jooq.postgis.spatial.binding.JTSGeometryBinding</binding> >> </customType> >> </customTypes> >> <forcedTypes> >> <forcedType> >> <name>Geometry</name> >> <types>(geometry|GEOMETRY)</types> >> </forcedType> >> </forcedTypes> >> </database> >> <generate> >> <relations>true</relations> >> <records>true</records> >> <pojos>true</pojos> >> <interfaces>true</interfaces> >> <daos>true</daos> >> <jpaAnnotations>true</jpaAnnotations> >> <fluentSetters>true</fluentSetters> >> </generate> >> <target> >> <packageName>org.mitre.caasd.caps.jooq</packageName> >> <!-- >> <packageName>org.mitre.caasd.caps.gen</packageName> --> >> >> <directory>target/main-generated-sources/jooq</directory> >> </target> >> </generator> >> </configuration> >> >> >> On Thursday, August 16, 2018 at 10:51:48 AM UTC-4, Lukas Eder wrote: >>> >>> 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. > -- 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.
