How to declare named queries oustide Hibernate entity classes?

Question

I have a data access class that exposes basic operations for an entity class used on a web site:

public class UserDataAccessService {

   public User login(User u)...
   public User findByUsername(String username)...

I want to define all HQL/SQL queries in this data access class, but I'm having trouble using the hibernate @NamedQuery annotation; Hibernate keeps saying that it can't find the named query. I don't intend to define lookup/find methods in the entity classes because I don't feel it's the appropriate location for it.

I am using annotations and hibernate.cfg.xml only, so where can I declare these queries so that Hibernate can find them?

Hans · Accepted Answer · 2012-01-05 10:23:49Z

1

If you annotate your DAO with @MappedSuperclass then you can put your NamedQueries in the DAO. Don't forget to add the package of the DAO or the DAO-class itself to the list of annotated packages/classes in your Hibernate Configuration

answered Jan 5, 2012 at 10:23

Hans

433 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nayan Wadekar · Accepted Answer · 2011-03-19 11:54:27Z

0

You can write queries in respective XML mapping files.

//---
<query name="findUser"><![CDATA[select o from User o]]>
</query>
//---

Edit :

Named native query:

<sql-query name="findUser">
<return alias="user" class="com.User"/>
//-- native query
</sql-query>

From Documentation :

Named SQL queries can be defined in the mapping document and called in exactly the same way as a named HQL query.

These queries need to be placed in respective mapping(hbm.xml) files.

edited Mar 19, 2011 at 11:54

answered Mar 13, 2011 at 10:31

Nayan Wadekar

11.6k4 gold badges52 silver badges74 bronze badges

2 Comments

user646584 Over a year ago

There is no "query" element in hibernate.cfg.xml, so that's not an option.

Nayan Wadekar Over a year ago

@user646584 : query element need to be placed in mapping file(hbm.xml) not in configuration file(cfg.xml) which you are trying to do. Anyways edited my answer might help you.

Collectives™ on Stack Overflow

How to declare named queries oustide Hibernate entity classes?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related