Hi Andrus,
thanks for the reply...
On 10/06/2008, at 5:12 PM, Andrus Adamchik wrote:
> there is nothing there that would let you do that outside the
> context of query execution. One reason why we never pursued such
> functionality is because ... well, such context is needed:
>
> * you need a place to stick joins as you walk the expression path
> * you need a way to match bound variables against "?" in prepared
> statement (we don't do conversion from Date to String for instance,
> as there is no sane way to do that for all databases; we let JDBC
> driver handle bindings)
> * you need access to specific DbAdapter to generate correct SQL and
> correctly process bindings.
okay.
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?
> The closest thing to what you describe is a procedure of translation
> of an EJBQL query (which is logically, but not semantically is a
> close analog of SelectQuery) to SQLTemplate. It is also done in the
> context of query execution, but with some effort it can probably be
> converted to a standalone SQLTemplate without execution.
Would that help here?
Sorry the subject was misleading... I ended up changing the body from
its original - where I was finding that foreign keys in the expression
were being validated and it was throwing an exception because they
weren't public members... but that's another (albeit related) topic.
with regards,
--Lachlan Deck
This archive was generated by hypermail 2.0.0 : Tue Jun 10 2008 - 03:32:08 EDT