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] <javascript:>> 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] <javascript:>.
>> 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.
