[eclipselink-users] Order of persist operations

[Deyan Tsvetanov <deyan@xxxxxxxxxxxx>]

Hi guys, 

I am experiencing a weird imho behaviour of Eclipselink and I'd really like to hear some other opinions . 

I have a pretty simple entity with assigned IDs; 

@Entity @Table(name="ROLE")

public class Role implements Serializable {

private static final long serialVersionUID = 1L;

@Id @Column(name="ID", length=20, nullable=false)

    public String id;

   

}

I am executing the following operations: 

public static void main(String[] args) {

EntityManagerFactory emf = Persistence.createEntityManagerFactory("EclipseLinkJPATest");

EntityManager em = emf.createEntityManager();

em.getTransaction().begin();

for (int i = 0; i < 10; i++) {

Role r = new Role();

r.id = "TEST" + i;

em.persist(r);

}

em.getTransaction().commit();

em.close();

emf.close();

}

And I'd expect that the INSERT queries will be executed in the same order as the persist() method is called: 

TEST0, TEST1, TEST2 , etc.

But in the real life the insert queries are in a random order every time: 

EL Fine]: sql: 2013-01-17 12:13:58.11--ClientSession(1694665796)--Connection(1795160456)--INSERT INTO ROLE (ID) VALUES (?)

bind => [TEST1]

[EL Fine]: sql: 2013-01-17 12:13:58.113--ClientSession(1694665796)--Connection(1795160456)--INSERT INTO ROLE (ID) VALUES (?)

bind => [TEST6]

[EL Fine]: sql: 2013-01-17 12:13:58.114--ClientSession(1694665796)--Connection(1795160456)--INSERT INTO ROLE (ID) VALUES (?)

bind => [TEST2]

[EL Fine]: sql: 2013-01-17 12:13:58.115--ClientSession(1694665796)--Connection(1795160456)--INSERT INTO ROLE (ID) VALUES (?)

bind => [TEST7]

[EL Fine]: sql: 2013-01-17 12:13:58.117--ClientSession(1694665796)--Connection(1795160456)--INSERT INTO ROLE (ID) VALUES (?)

bind => [TEST4]

[EL Fine]: sql: 2013-01-17 12:13:58.121--ClientSession(1694665796)--Connection(1795160456)--INSERT INTO ROLE (ID) VALUES (?)

bind => [TEST8]

[EL Fine]: sql: 2013-01-17 12:13:58.123--ClientSession(1694665796)--Connection(1795160456)--INSERT INTO ROLE (ID) VALUES (?)

bind => [TEST3]

[EL Fine]: sql: 2013-01-17 12:13:58.124--ClientSession(1694665796)--Connection(1795160456)--INSERT INTO ROLE (ID) VALUES (?)

bind => [TEST9]

[EL Fine]: sql: 2013-01-17 12:13:58.126--ClientSession(1694665796)--Connection(1795160456)--INSERT INTO ROLE (ID) VALUES (?)

bind => [TEST5]

[EL Fine]: sql: 2013-01-17 12:13:58.127--ClientSession(1694665796)--Connection(1795160456)--INSERT INTO ROLE (ID) VALUES (?)

bind => [TEST0]

As you can see the order if insert queries is: 

TEST1, TEST6, TEST2, TEST7, TEST4, etc. 

That is really weird and wrong ! :) 

I dug a lot and could not find a solution. 

Please help :)

Thanks in advance,

Deyan