[jira] [Commented] (CAY-1867) Getting unique ID from Oracle Sequnce in batch input proces

["Andrus Adamchik (JIRA)" <ji...@apache.org>]

    [ 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