You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by Craig L Russell <Cr...@Sun.COM> on 2007/03/02 18:00:31 UTC
White space in xml queries
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 < ?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!
Fwd: White space in xml queries
Posted by Craig L Russell <Cr...@Sun.COM>.
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 < ?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!
Fwd: White space in xml queries
Posted by Craig L Russell <Cr...@Sun.COM>.
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 < ?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!
Re: White space in xml queries
Posted by Marc Prud'hommeaux <mp...@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 < ?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!
>