From open-jpa-dev-return-2610-apmail-incubator-open-jpa-dev-archive=incubator.apache.org@incubator.apache.org Fri Mar 02 20:14:14 2007 Return-Path: Delivered-To: apmail-incubator-open-jpa-dev-archive@locus.apache.org Received: (qmail 36444 invoked from network); 2 Mar 2007 20:14:11 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 2 Mar 2007 20:14:11 -0000 Received: (qmail 48386 invoked by uid 500); 2 Mar 2007 20:14:20 -0000 Delivered-To: apmail-incubator-open-jpa-dev-archive@incubator.apache.org Received: (qmail 48243 invoked by uid 500); 2 Mar 2007 20:14:20 -0000 Mailing-List: contact open-jpa-dev-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: open-jpa-dev@incubator.apache.org Delivered-To: mailing list open-jpa-dev@incubator.apache.org Received: (qmail 48173 invoked by uid 99); 2 Mar 2007 20:14:19 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Mar 2007 12:14:19 -0800 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Received: from [192.18.42.249] (HELO nwk-ea-fw-1.sun.com) (192.18.42.249) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Mar 2007 12:14:07 -0800 Received: from d1-sfbay-09.sun.com ([192.18.39.119]) by nwk-ea-fw-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id l22JWZ5p025087; Fri, 2 Mar 2007 11:32:35 -0800 (PST) Received: from conversion-daemon.d1-sfbay-09.sun.com by d1-sfbay-09.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) id <0JEA00J01JJ8M600@d1-sfbay-09.sun.com> (original mail from Craig.Russell@Sun.COM); Fri, 02 Mar 2007 11:32:35 -0800 (PST) Received: from [129.145.133.119] by d1-sfbay-09.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPSA id <0JEA0036HJMA0P30@d1-sfbay-09.sun.com>; Fri, 02 Mar 2007 11:32:34 -0800 (PST) Date: Fri, 02 Mar 2007 11:32:38 -0800 From: Craig L Russell Subject: Fwd: White space in xml queries Sender: Craig.Russell@Sun.COM To: roller-dev@incubator.apache.org, open-jpa-dev@incubator.apache.org Message-id: MIME-version: 1.0 X-Mailer: Apple Mail (2.752.2) Content-type: multipart/signed; protocol="application/pkcs7-signature"; boundary=Apple-Mail-162--864253115; micalg=sha1 References: <7883FD5F-05CD-40E4-AB78-508425441F67@apache.org> X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail-162--864253115 Content-Type: multipart/alternative; boundary=Apple-Mail-161--864253484 --Apple-Mail-161--864253484 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Begin forwarded message: > From: Marc Prud'hommeaux > 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: >> >>> - 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 >>> - >>> + 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! --Apple-Mail-161--864253484 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=ISO-8859-1

Begin = forwarded message:

From: = Marc Prud'hommeaux <mprudhom@apache.org>
Date: = March 2, 2007 9:05:11 AM PST
To: open-jpa-dev@incubator.a= pache.org
Subject: Re: White space in xml = queries
Reply-To: open-jpa-dev@incubator.a= pache.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:

=
-=A0 =A0 =A0 =A0 =A0 =A0 = <query>SELECT COUNT(c), c.weblogEntry.website.handle, = c.weblogEntry.anchor, c.weblogEntry.title
- =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = FROM CommentData c WHERE c.weblogEntry.website =3D ?1 AND = c.weblogEntry.pubTime < ?2
-=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = GROUP BY c.weblogEntry.website.handle, c.weblogEntry.anchor, = c.weblogEntry.title
-=A0 =A0 =A0 =A0 =A0 =A0 = </query>
+=A0 =A0 =A0 =A0 =A0 =A0 = <query>SELECT COUNT(c), c.weblogEntry.website.handle, = c.weblogEntry.anchor, c.weblogEntry.title FROM CommentData c WHERE = c.weblogEntry.website =3D ?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!

= --Apple-Mail-161--864253484-- --Apple-Mail-162--864253115 Content-Transfer-Encoding: base64 Content-Type: application/pkcs7-signature; name=smime.p7s Content-Disposition: attachment; filename=smime.p7s MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGUDCCAwkw ggJyoAMCAQICECpJVMO68ii+Xfsc1O1YYFIwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkEx JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA2MTIwOTE5NTEwNVoXDTA3MTIwOTE5NTEw NVowbDEQMA4GA1UEBBMHUnVzc2VsbDEUMBIGA1UEKhMLQ3JhaWcgTGFpcmQxHDAaBgNVBAMTE0Ny YWlnIExhaXJkIFJ1c3NlbGwxJDAiBgkqhkiG9w0BCQEWFUNyYWlnLlJ1c3NlbGxAU3VuLkNPTTCC ASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAMNAB4Ih+ShsCt89HzqIdwEx8L4o1UHiY6V7 16mrCedfd4Y0/uI7z9Zam8ysgEh+F7aDnQEKmEsVFN35G4nPMfLU6dZYkvADwUjbq82t/dJ3FDDg Q945nHHpqECZff/S/UMho9AFfj6PZvZBAlDCJAayb4RdKIlfuvPW9YcQStQ1IfVJcVuKnC0Q+tdc a4A7zn7IzLOQohO1lTc3hXSBigEIGiGYn6Ny0wmexfA3X1WsXekFx5czd+M4GjDjswn8CNoBmnBr jOTGK1mOsXR6GSRHnly2s9xTdE4qv9qimM+7C2yzMHbKcszV7OQoLsRsZKDh+6u9wYU+TrjcY4ym bA8CAwEAAaMyMDAwIAYDVR0RBBkwF4EVQ3JhaWcuUnVzc2VsbEBTdW4uQ09NMAwGA1UdEwEB/wQC MAAwDQYJKoZIhvcNAQEFBQADgYEAU/EpPDztnb55Fz7iGSVm1mYEVj5m2OQKTYG26POUAomCBRrt /CdBBvqYmcHUTpra0qLELHAQadYFl2v11iQkqwF5PPJs19oU/zA0m5qFnOMTAiCvel7IprIwA2r6 eJR9siaPwDRgVJ/Sj71dD+utwf+nRrNy0/7PMNK5y+ocsYQwggM/MIICqKADAgECAgENMA0GCSqG SIb3DQEBBQUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQH EwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZp Y2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwgRnJlZW1h aWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5jb20wHhcNMDMw NzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3Rl IENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWls IElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMSmPFVzVftOucqZWh5owHUE cJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTlUAow1wJjWiyJFXCO3cnwK4Vaqj9xVsuvPAsH5/Ef kTYkKhPPK9Xzgnc9A74r/rsYPge/QIACZNenprufZdHFKlSFD0gEf6e20TxhBEAeZBlyYLf7AgMB AAGjgZQwgZEwEgYDVR0TAQH/BAgwBgEB/wIBADBDBgNVHR8EPDA6MDigNqA0hjJodHRwOi8vY3Js LnRoYXd0ZS5jb20vVGhhd3RlUGVyc29uYWxGcmVlbWFpbENBLmNybDALBgNVHQ8EBAMCAQYwKQYD VR0RBCIwIKQeMBwxGjAYBgNVBAMTEVByaXZhdGVMYWJlbDItMTM4MA0GCSqGSIb3DQEBBQUAA4GB AEiM0VCD6gsuzA2jZqxnD3+vrL7CF6FDlpSdf0whuPg2H6otnzYvwPQcUCCTcDz9reFhYsPZOhl+ hLGZGwDFGguCdJ4lUJRix9sncVcljd2pnDmOjCBPZV+V2vf3h9bGCE6u9uo05RAaWzVNd+NWIXiC 3CEZNd4ksdMdRv9dX2VPMYIDEDCCAwwCAQEwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhh d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt YWlsIElzc3VpbmcgQ0ECECpJVMO68ii+Xfsc1O1YYFIwCQYFKw4DAhoFAKCCAW8wGAYJKoZIhvcN AQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDcwMzAyMTkzMjM5WjAjBgkqhkiG9w0B CQQxFgQUIeRuog/PhNOCsn/i7236toREmMswgYUGCSsGAQQBgjcQBDF4MHYwYjELMAkGA1UEBhMC WkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0 ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhAqSVTDuvIovl37HNTtWGBSMIGHBgsqhkiG 9w0BCRACCzF4oHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQ dHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhAq SVTDuvIovl37HNTtWGBSMA0GCSqGSIb3DQEBAQUABIIBAEOF5Txtw2HI4UgHG/y51s1931Di3xT8 5lx8RcyUtSwYSf6MWc6ywv3U0bvvHoexkYGtDEGECjLHq8hKUVpHBE4cytRqCP3Vux7L0fcrfPJ1 aHPFYmjKHgZKGChnFi8FPf4B9F008zcuvuWAJXpi2qEX+e5MLe7A7rcNCwebR2b9gd49IIQvtVsa l/rWoYdB34NMGIgtYAaYJBpK28LOB15F9FSUzldVNKi1tjBhjDm0N8wRbjpWgEk1e/XTirV3RqB7 +trwRKj3kQNb5d8UGxgZ0eKOhPHjGg7s10exz1IOYYB4OT33ecK8iicWp6P1dXkl0XnHIwRhZKfE nAsWDnkAAAAAAAA= --Apple-Mail-162--864253115--