You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@roller.apache.org by Craig L Russell <Cr...@Sun.COM> on 2007/03/02 20:32:38 UTC

Fwd: White space in xml queries


Begin forwarded message:

> From: Marc Prud'hommeaux <mp...@apache.org>
> Date: March 2, 2007 9:05:11 AM PST
> To: open-jpa-dev@incubator.apache.org
> Subject: Re: White space in xml queries
> Reply-To: open-jpa-dev@incubator.apache.org
>
>
> We should be ignoring the whitespace. What is the error message?
>
>
> On Mar 2, 2007, at 6:00 PM, Craig L Russell wrote:
>
>> Hey,
>>
>> The Roller project found that OpenJPA didn't like line endings  
>> (white space) in JPAQL queries in metadata. This is a surprise.  
>> Don't we ignore white space in queries unless quoted?
>>
>> Craig
>>
>> Begin forwarded message:
>>
>>> -            <query>SELECT COUNT(c),  
>>> c.weblogEntry.website.handle, c.weblogEntry.anchor,  
>>> c.weblogEntry.title
>>> -                   FROM CommentData c WHERE  
>>> c.weblogEntry.website = ?1 AND c.weblogEntry.pubTime &lt; ?2
>>> -                  GROUP BY c.weblogEntry.website.handle,  
>>> c.weblogEntry.anchor, c.weblogEntry.title
>>> -            </query>
>>> +            <query>SELECT COUNT(c),  
>>> c.weblogEntry.website.handle, c.weblogEntry.anchor,  
>>> c.weblogEntry.title FROM CommentData c WHERE  
>>> c.weblogEntry.website = ?1 AND
>>
>> Craig Russell
>> Architect, Sun Java Enterprise System http://java.sun.com/products/ 
>> jdo
>> 408 276-5638 mailto:Craig.Russell@sun.com
>> P.S. A good JDO? O, Gasp!
>>
>

Craig Russell
Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
408 276-5638 mailto:Craig.Russell@sun.com
P.S. A good JDO? O, Gasp!