[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [Newsgroup Home]
[news.eclipse.rt.eclipselink] 2 same queries => different results?

Hello,

I try to invoke the same query twice and I didn't get same results?!
What could be wrong (see source code and output below)?

I tried to disable Query Cache but still different results...

I am using EclipseLink 2.0.0 Milestone Build.

Thanks a lot for your help.

andiqo

//-- source code
Query query1 = em.createQuery("SELECT o FROM Node o WHERE o.name = :name");
query1.setParameter("name", "w1");
List<?> results1 = query1.getResultList();
System.out.println("** results1.size is: " + results1.size());
Query query2 = em.createQuery("SELECT o FROM Node o WHERE o.name = :name");
query2.setParameter("name", "w1");
List<?> results2 = query2.getResultList();
System.out.println("** results2.size is: " + results2.size());


//-- output
[EL Fine]: 2009-04-18 12:42:02.684--ServerSession(485367518)--Connection(1485037089)--Thread(Thread[main,5,main])--SELECT ID, VERSION, NODETYPE_ID FROM NODE WHERE (NAME = w1)
** results1.size is: 1
[EL Fine]: 2009-04-18 12:42:04.329--ServerSession(485367518)--Connection(20566293)--Thread(Thread[main,5,main])--SELECT ID, VERSION, NODETYPE_ID FROM NODE WHERE (NAME = w1)
** results2.size is: 0