I'm creating a select query using entity manager createQuery and execute it with getSingleResult() which throws a NoResultException.
However, it should return a result. The query that is executed (which I get from the MySQL query log) returns exactly what I would expect it to return but somehow this result cannot be turned into a result by the entity manager.
Any hints how to debug this? This is JBoss AS 4.2.1 with MySQL 4.1. Thanks, Georges