Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (athena.apache.org: domain of mprudhomapache@gmail.com
 designates 209.85.198.185 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=received:message-id:from:to:in-reply-to:content-type:content-transfer-encoding:mime-version:subject:date:references:x-mailer:sender;
        b=D4ovBNGQagLud/ptbWT2LI6Lmq2GRB2sBC7ATuUDcKNU4dthl9VPat31FrgNRrvyxqd7tC/8AsEP5H6FJbS4uFrT/jQ+2xZ3Sue7pEyf9Xibed/cMXXl+FcEFYewSKQzNwoPQtYFaA3SZYVcWYdY0/YsDn5iXpIUZcgld4Mm2Gc=
Message-Id: <6F5C2901-BE53-48E9-A13F-B29FCF08DF01@apache.org>
From: Marc Prud'hommeaux <mprudhom@apache.org>
To: users@openjpa.apache.org
In-Reply-To: <47572D46.7000702@spree.de>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v915)
Subject: Re: update query syntax for embedded class field
Date: Wed, 5 Dec 2007 15:05:10 -0800
References: <0D1719326D64BD4E9F92A0C12023767804421A56@eserv.covergence.com>
 <47572D46.7000702@spree.de>
Sender: Marc Prud'hommeaux <mprudhomapache@gmail.com>


I think we might only support setting top-level attributes, but you  
are right: it does look like we are supposed to support navigation  
through an arbitrary number of 1-1 relations.


On Dec 5, 2007, at 2:59 PM, Michael Bouschen wrote:

> Hi Ajay Aggarwal,
>
> I think your query is correct and should work. According to the Java  
> Persistence query language BNF the expression following the keyword  
> SET might be a state_field and state_field includes navigation  
> through an embedded:
> state_field ::= {embedded_class_state_field.}*simple_state_field
>
> I propose you file a JIRA issue.
>
> Regards Michael
>
>> I am trying to update a field of the embedded class using query,  
>> but its
>> not working. In the following code, 'registration' is an embedded  
>> class
>> field inside 'User' and 'authenticated' is a boolean field inside  
>> this
>> embedded class.
>>
>>
>> Query q = em.createQuery("UPDATE User s SET  
>> s.registration.authenticated
>> = :auth");
>>
>> q.setParameter("auth", false);
>>
>>
>> I am getting following error. What is the correct syntax for such a
>> query?
>>
>>
>> openjpa.persistence.ArgumentException: An error occurred while  
>> parsing
>> the query filter 'UPDATE User s SET s.registration.authenticated =
>> :auth'. Error message: <4|false|0.9.7>
>> org.apache.openjpa.kernel.jpql.ParseException: Encountered "." at
>> character 33, but expected: ["="].
>>
>>
>> Thanks.
>>
>>
>>
>>
>
>
> -- 
> Tech@Spree Engineering GmbH  Tel.: +49/(0)30/235 520-33
> Buelowstr. 66                Fax.: +49/(0)30/217 520-12
> 10783 Berlin                 mailto:mbo.tech@spree.de  
> Geschaeftsfuehrung: Anna-Kristin Proefrock
> Sitz Berlin, Amtsgericht Charlottenburg, HRB 564 52
>