Hi Lukas, Thanks very much for your response.
Could you please provide more details how to do this with a Firebird view
? lets say I have a view called TEST and ID_TEST will be the syntetic
primary key, How should I pass this to code gen. via Maven ?
<configuration>
<generator>
<database>
<syntheticPrimaryKeys>???????</syntheticPrimaryKeys>
</database>
</generator></configuration>
BR,
Buddhika E.
On Monday, 16 October 2017 03:15:33 UTC+5:30, Lukas Eder wrote:
>
> Hi Buddhika,
>
> I think the notion of synthetic primary keys that you can configure in the
> code generator might be the solution to your problem:
>
> https://www.jooq.org/doc/latest/manual/code-generation/codegen-advanced/codegen-config-synthetic-primary-keys
>
> Hope this helps,
> Lukas
>
> 2017-10-15 20:31 GMT+02:00 Buddhika Ekanayake <[email protected]
> <javascript:>>:
>
>> Hello to all,
>>
>> I have an View that performs inserts & updates via triggers(Firebird 3).
>> When
>> I generate pojos, JOOQ doesn't recognize the view as an "Updatable" record
>> though extended using the TableRecordImpl. As I'm pretty much settle
>> with record level "STORE" and "REFRESH" for insertions and updates, this
>> makes me unable to perform both these operations. :(
>>
>> So I manually changed this record to updatable and force a primary key to
>> handle the store operation. It's works well, triggers do their job too &
>> nothing much to complain. But real problem raises later part, when I'm
>> trying to do the "refresh". :) Yes, its unable to catch the generated key
>> value from underlying table for an insert attempt.
>>
>> I know its logical, but I'd like to know, is there any way to perform
>> this operation within record level approach. (I didn't uses much the insert
>> statements with returning though)
>>
>> Many Thanks !
>>
>> Buddhika E.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> --
>> 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.
