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!