How do I prevent Runtime Exception in NamedQueries

Question

How can I make a JUnit Test that tests NamedQueries?

I want a fail on syntaxis error like:

@Entity
@NamedQueries({
    @NamedQuery(name="Country.findByName",
            query="SELECT c FROM Country c WHERE c.wrongname = :name")
}) 
public class Country {
    private String name;
//...
}

The test should be fail because name < > wrongname

I only need syntaxis check, not DB check

StackTrace on runtime:

Caused by: javax.persistence.PersistenceException: [PersistenceUnit: unit] Unable to build EntityManagerFactory
...
Caused by: org.hibernate.HibernateException: Errors in named queries: Country.findByName
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:397)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1327)
at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)

clearly down to the specific JPA implementation you use, why not mention it? and the exception + stack trace too — DataNucleus, Nov 07 '13 at 19:21
My JPA Implempentation is Hibernate, I prefer that Hibernate don't be part of the solution, this is possible? – — Omar Hrynkiewicz, Nov 07 '13 at 20:40

score 0 · Answer 1 · answered Nov 12 '13 at 23:46

Although you talk about checking only the syntax, your example is about checking the query is consistent with the table columns. The most practical way to testing this isusing a database. Unit testing using a real client-server database is fraught with problems. But you can instead use an in memory embedded database such as Apache Derby for your unit tests. Recent versions of Spring have some helper code to make this even easier. The database unit tests will still be much slower than other unit tests, so you will need to keep them few in number to prevent your unit tests being slow.

Thanks for your reply. But I don't want a DB column check. I want check the HQL query, and the entity (java object) atributes. — Omar Hrynkiewicz, Nov 13 '13 at 17:25

How do I prevent Runtime Exception in NamedQueries

1 Answers1