Re: NamedQuery / SQLTemplate keyPath validation

From: Lachlan Deck (lachlan.dec..mail.com)
Date: Tue Jun 10 2008 - 03:52:51 EDT

  • Next message: Andrus Adamchik: "Re: NamedQuery / SQLTemplate keyPath validation"

    Hi Andrus,

    On 10/06/2008, at 5:37 PM, Andrus Adamchik wrote:

    > On Jun 10, 2008, at 10:31 AM, Lachlan Deck wrote:
    >
    >> Perhaps I should describe what I'm actually doing. All I need is a
    >> way to get a count of a select query (without having to fault in
    >> all the related objects). So is there a way to trigger that, in
    >> order to just get a count back, with a SelectQuery without going
    >> the sqltemplate or namedquery route?
    >
    > I think EJBQL route is the way to go for aggregate object queries.
    > In fact Expression has 'toEJBQLString' method, but you may not even
    > care about it. Anyways here is an example:
    >
    > EJBQLQuery countQuery = new EJBQLQuery("SELECT count(a) FROM Artist
    > a WHERE a.artistName like 'A%'");

    The problem is that we have a list controller that's doing its select
    given the combination of various Expressions. These expressions get
    broken out (at points) in order to obtain a relevant count via some
    other query. So I don't have the option of constructing the where
    clause as simply as above (or, in other words, by hand).

    i.e., will EJBQLQuery cope with an expression.toString() where clause?

    with regards,

    --
    

    Lachlan Deck



    This archive was generated by hypermail 2.0.0 : Tue Jun 10 2008 - 03:53:29 EDT