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

["Krzysztof Malinowski (JIRA)" <ji...@apache.org>]

Krzysztof Malinowski created CAY-1867:
-----------------------------------------

             Summary: 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