Hi Ian,

There's not much magic performed by jOOQ when returning that value. I
suspect this is the exact value returned by your JDBC driver. Can you try
running the same statement through JDBC directly? You can extract the
statement from your debug / trace log:
http://www.jooq.org/doc/3.2/manual/sql-execution/logging/

Cheers
Lukas


2013/12/5 Ian Clarke <[email protected]>

> We're (still) using Jooq 2.4.0.
>
> I'm using the onDuplicateKeyUpdate() method to insert or update to a table
> with a uniqueness constraint across several columns.  In the insert values
> are specified for all of the columns in the uniqueness constraint.
>  Moreover, when I manually convert the insertInto into a select() on those
> columns, only one column is returned.
>
> Yet, execute() keeps returning a value of 2, which I believe indicates
> that two rows were inserted/updated, whereas only one should have been.
>
> Does anyone have any ideas?
>
> Ian.
>
> --
> 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/groups/opt_out.
>

-- 
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/groups/opt_out.

Reply via email to