[jira] Created: (OPENJPA-466) Primary key constraint violated using (Oracle) sequence to generate ID in multithreaded app

[Frank Le (JIRA)]

Primary key constraint violated using (Oracle) sequence to generate ID in 
multithreaded app
-------------------------------------------------------------------------------------------

                 Key: OPENJPA-466
                 URL: https://issues.apache.org/jira/browse/OPENJPA-466
             Project: OpenJPA
          Issue Type: Bug
    Affects Versions: 1.0.0
         Environment: OpenJPA 1.0.0 (also tried 1.0.1 and 1.1.0-SNAPSHOT)
Oracle XE 10g (JDBC driver 10.2.0.3.0)
Windows XP Pro
            Reporter: Frank Le
            Priority: Blocker


Here's how I annotate the ID:
    @Id
    @SequenceGenerator(name = "FooSeq", sequenceName = "seq_foo", 
allocationSize = 20)
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "FooSeq")
    private Long id;

Here's how I create the (Oracle) sequence:
CREATE SEQUENCE seq_foo START WITH 1 INCREMENT BY 1;

I get a primary key unique constraint violated in a multithreaded app i.e. it 
doesn't happen in single-threaded!

You can simply reproduce this error by either create blocking queue or blocking 
thread pool say size 5 to insert 10000+ object.


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.