What is am after is just a simple way to confim that it either exists or not without hydrating entities. So select e.id would do it? Example api does not provide IncludeProperties just ExcludeProperties. Is there a reason other then time?
On Dec 18, 10:41 am, "Fabio Maulo" <[email protected]> wrote: > I prefer use DAO/Repository that is the only tier knowing something about > persistence.Where I need a specific Exists method based on a NaturalId I'm > not using Count but only > select e.id from .... where ..... > > 2008/12/18 epitka <[email protected]> > > > > > > > Thanks Fabio, > > I look into named query, I think I found another thread that talks > > about this. I put this in the "service" rather then "repository". My > > repositories only fetch and persist. Anything else like get the total > > of something, check this or that go into service classes. Does this > > make sense? > > > On Dec 18, 10:08 am, "Fabio Maulo" <[email protected]> wrote: > > > - Create a method in your DAO/Repository named Exists(YourEntity example) > > - > > > In the mapping write a namedQuery named "YourEntity.Exists" > > > - the query may look like : select count(*) from YourEntity e where > > > e.NaturalIdProperty1 = :pp1 and e.NaturalIdProperty2 = :pp2 > > > - Implements the Exists method using the named query > > > > If you don't want use HQL you can use Criteria but, in this case where > > you > > > have a static query, HQL is better candidate. > > > > 2008/12/18 epitka <[email protected]> > > > > > Hi, > > > > I use surrogate keys on my tables, but some tables have columns that > > > > are unique. For example one cannot create a project that has the same > > > > name. So I am wondering what is the best way to query using NH to > > > > check if name already exists in the table, so I can make a check > > > > rather then catching exception. I do not want to populate the entity > > > > with that name just return count. Can anybody give example. > > > > -- > > > Fabio Maulo > > -- > Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
