Hi,

I am new to Hibernate. I am using EJB3 and Hibernate. I am trying to retrieve values from a table called USER_PROFILE through an entity bean(EJB3 - @Entity) . I am getting an exception. Please find below the select query and the exception message.

Query
====
userData = (em.createQuery("select g from UserProfileEntity g where g.emailAddress= 'email@email.com'")).getResultList();

Exception
======
Exception caught is : javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query

Can someone help on this.

Thanks