JPA query.getSingleResult throws java.lang.IllegalStateExcep

[motte1979]

Here is the snippet of code i'm processing

Label l;
for (Label newLabel : labels) {
 l = entityManager.createQuery(
 "from Label where name = :name and appId = :appId")
 .setParameter("name", newLabel.getName())
 .setParameter("appId", appId);
 l = (Label) q.getSingleResult();
 if (l != null) {
 l.setTrafficLight(tl);
 entityManager.merge(l);
 } else {
 newLabel.setTrafficLight(tl);
 newLabel.setAppId(appId);
 newLabels.add(newLabel);
 }
}

The loop iterates once and merges the first existing 'Label'. I got the Exception an next q.getSingleResult() ....

I did no flush between merge and getSingleResult () .....

Any ideas?

[motte1979]

Sorry, i forgot to post versions.

jboss-4.2.0 which uses
* hibernate-entitymanager-3.2.1.ga
* hibernate-annotations-3.2.1.ga
* hibernate-core-3.2.3.ga

[motte1979]

 q.setFlushMode(FlushModeType.COMMIT);

solved this problem ... i'm processing a Set of different labels, therefore the merged data need not to be flushed before processing the next query (it does not affect the results).

Just for those who are interested in the solution ....

see http://java.sun.com/javaee/5/docs/api/javax/persistence/FlushModeType.html for details ...