Hm. I've never thought about specifying the columns and table via
parameters.
Event supposing that this works (not convinced it does/will), do you
actually have a property named 1 in the UserSchedule entity
(select us.:SKDID...setParameter("SKDID",1) => select us.1)?
Try specifying the entity and property names directly. Parameters are
generally used for parameterized values, like:
EJQLQuery query = new EJBQLQuery("select us.sku from UserSchedule us
where us.userId=:id");
query.setParameter("id",1);
Robert
On Apr 8, 2009, at 4/84:48 AM , Francois Eyl wrote:
> Howdy guys,
>
> I'm trying to use EJBQL query and parameters, but I can't get it to
> work. Is
> there something special for ?
> Bellow is a quick sample of what I'm doing :
>
> String queryString = "SELECT us.:SKDID FROM :USCHED
> us WHERE
> us.:UID=1";
> EJBQLQuery query = new EJBQLQuery(queryString);
>
> query.setParameter("SKDID", 1);
> query.setParameter("USCHED",
> UserSchedule.class.getSimpleName());
> query.setParameter("UID",
> UserSchedule.USER_ID_PROPERTY);
>
> try {
> ctx.getContext().performQuery(query);
> } catch (CayenneRuntimeException e) {
> System.err.println(e.getMessage());
> }
>
> I'm getting the following message : "[v.3.0M5 Dec 09 2008 00:42:23]
> Error
> parsing EJB QL statement".
>
> Can somebody tell me where I'm wrong ?
>
> Thanks,
> Francois.
This archive was generated by hypermail 2.0.0 : Wed Apr 08 2009 - 09:30:20 EDT