[
https://issues.apache.org/cayenne/browse/CAY-909?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12571
]
Andrus Adamchik commented on CAY-909:
-------------------------------------
A few notes :
* My preference would be this implementation: "capture the appropriate SQL
error when trying to update the PK (and failing due to the missing row) and
then automatically add the row and try again." otherwise startup time can
become a serious bottleneck (see the next comment why)
* we need to abstract the implementation to reset whatever PK generator the
adapter is using (e.g. a sequence, AUTO_PK_SUPPORT, a stored procedure, etc.)...
* It would be nice to not only create the appropriate PK entry if missing, but
also reset its max value on failures... IIRC there is another Jira somewhere
with a similar request
> Automatic AUTO_PK_SUPPORT row creation
> --------------------------------------
>
> Key: CAY-909
> URL: https://issues.apache.org/cayenne/browse/CAY-909
> Project: Cayenne
> Issue Type: Improvement
> Components: Cayenne Core Library
> Reporter: Ari Maniatis
> Assignee: Andrus Adamchik
> Priority: Minor
> Fix For: 3.0
>
>
> When a user of Cayenne adds new tables to their schema, they must currently
> remember to add a new row to the AUTO_PK_SUPPORT table for primary keys
> managed by Cayenne. This should not be necessary if Cayenne could at startup
> read all rows of that table and automatically add any rows missing, or else
> capture the appropriate SQL error when trying to update the PK (and failing
> due to the missing row) and then automatically add the row and try again.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
