[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-6721?page=c... ] Strong Liu updated HHH-6721: ---------------------------- Description: If I have the following bean: {code} @Entity public class Foobar { @Id private int id; private String name; } and the following unit tests: @PersistenceContext(unitName = "reports2") private EntityManager em; @Test public void testGoodColumnName() { em.createNativeQuery("select 1 id, 'name' name from dual",Foobar.class) .getResultList(); } @Test public void testBadColumnName() { em.createNativeQuery("select 1 id, 'name' name2 from dual",Foobar.class) .getResultList(); } {code} the first unit test will succeed, but the second will fail with an "Invalid column name" SQLException. The reason for this is that the "name" field in the class doesn't have a corresponding "name" column in the query. Because I'm using Oracle I'm used to getting error messages which are unhelpful because they don't mention the column name that is invalid when I write an invalid query. As a result I spent a lot of time trying to figure out why the query worked when run in Squirrel SQL but not when run with Hibernate. Of course, I eventually figured out that the problem was the one I outlined above. It would have been much simpler for me if the error message had simply said something like "The query does not specify a column which corresponds to the 'name' field of bean com.foo.Foobar.". was: If I have the following bean: @Entity public class Foobar { @Id private int id; private String name; } and the following unit tests: @PersistenceContext(unitName = "reports2") private EntityManager em; @Test public void testGoodColumnName() { em.createNativeQuery("select 1 id, 'name' name from dual",Foobar.class) .getResultList(); } @Test public void testBadColumnName() { em.createNativeQuery("select 1 id, 'name' name2 from dual",Foobar.class) .getResultList(); } the first unit test will succeed, but the second will fail with an "Invalid column name" SQLException. The reason for this is that the "name" field in the class doesn't have a corresponding "name" column in the query. Because I'm using Oracle I'm used to getting error messages which are unhelpful because they don't mention the column name that is invalid when I write an invalid query. As a result I spent a lot of time trying to figure out why the query worked when run in Squirrel SQL but not when run with Hibernate. Of course, I eventually figured out that the problem was the one I outlined above. It would have been much simpler for me if the error message had simply said something like "The query does not specify a column which corresponds to the 'name' field of bean com.foo.Foobar.". -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira