cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrus Adamchik (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CAY-1867) Getting unique ID from Oracle Sequnce in batch input proces
Date Thu, 29 Aug 2013 17:04:51 GMT

    [ https://issues.apache.org/jira/browse/CAY-1867?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13753815#comment-13753815
] 

Andrus Adamchik commented on CAY-1867:
--------------------------------------

This is really odd. PK generator never gives much trouble, no matter how many objects you'd
save. Can you maybe post the code that creates and commits the objects in question, and the
Cayenne-generated SQL that happens on commit? 
                
> Getting unique ID from Oracle Sequnce in batch input proces
> -----------------------------------------------------------
>
>                 Key: CAY-1867
>                 URL: https://issues.apache.org/jira/browse/CAY-1867
>             Project: Cayenne
>          Issue Type: Bug
>         Environment: Oracle 10/11g
>            Reporter: Krzysztof Malinowski
>
> Problem appears only when trying to get unique ID from Oracle Sequnce in case of inserting
about 30 more new rows in iteration procedure. Then Cayenne can't get new ID by executing
statement:
> select PK_ANY_TABLE_NAME.nextval from dual
> Besides Cayenne uses the same value of ID then some PK constraint turns on.
> The problem doesn't appear when inserting one new row from time to time then Cayenne
correct reads new value of ID from Oracle Sequnce

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message