Mailing-List: contact commits-help@roller.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@roller.apache.org
Received-SPF: pass (athena.apache.org: local policy)
Message-ID: 
 <80484622.1185819325265.JavaMail.j2ee@atlassian01.managed.contegix.com>
Date: Mon, 30 Jul 2007 13:15:25 -0500 (CDT)
From: "David Johnson (JIRA)" <noreply@atlassian.com>
To: roller-commits@incubator.apache.org
Subject: [Roller-JIRA] Updated: (ROL-1506) ArgumentException occurs when
 select to query comments with date data
In-Reply-To: 
 <97766049.1185581910944.JavaMail.j2ee@atlassian01.managed.contegix.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable


     [ http://opensource.atlassian.com/projects/roller/browse/ROL-1506?page=
=3Dcom.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

David Johnson updated ROL-1506:
-------------------------------

         Assignee: David Johnson  (was: Roller Unassigned)
    Fix Version/s: 4.0

Looks like a JPA issue

> ArgumentException occurs when select to query comments with date data
> ---------------------------------------------------------------------
>
>                 Key: ROL-1506
>                 URL: http://opensource.atlassian.com/projects/roller/brow=
se/ROL-1506
>             Project: Roller
>          Issue Type: Bug
>          Components: Weblog Categories
>    Affects Versions: 4.0
>         Environment: glassfish V2 / winXP
>            Reporter: Davis Nguyen
>            Assignee: David Johnson
>            Priority: Critical
>             Fix For: 4.0
>
>
> when select to query comments with using filter data as date field,  Argu=
mentException occurs
> STEPS TO REPRODUCE:
> 1. Install glassfish V2 with Sun custom Roller (7/27/2007) build
> 2. Start Roller > register a user > create a weblog > a log entry
> 3. Go to Create & Edit > Comments > select to query with filter as
>        Start date: 07/27/07
>        End date: 07/27/07
>    Click Query button
> BUG:
> Status Code 500=20
> Message <0.9.7-incubating nonfatal user error> org.apache.openjpa.persist=
ence.ArgumentException: An error occurred while parsing the query filter 'S=
ELECT c FROM WeblogEntryComment c WHERE c.weblogEntry.website =3D ?1 AND (c=
.url LIKE ?2 OR c.content LIKE ?2) AND c.postTime >=3D ? AND c.postTime <=
=3D ? ORDER BY c.postTime DESC'. Error message: <0.9.7-incubating nonfatal =
user error> org.apache.openjpa.kernel.jpql.ParseException: Encountered "c .=
 postTime >=3D ? AND" at character 115, but expected: ["(", "*", "+", "-", =
".", "/", ":", "<", "<=3D", "<>", "=3D", ">", ">=3D", "?", "ABS", "ALL", "A=
ND", "ANY", "AS", "ASC", "AVG", "BETWEEN", "BOTH", "BY", "CONCAT", "COUNT",=
 "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP", "DELETE", "DESC", "DI=
STINCT", "EMPTY", "ESCAPE", "EXISTS", "FETCH", "FROM", "GROUP", "HAVING", "=
IN", "INNER", "IS", "JOIN", "LEADING", "LEFT", "LENGTH", "LIKE", "LOCATE", =
"LOWER", "MAX", "MEMBER", "MIN", "MOD", "NEW", "NOT", "NULL", "OBJECT", "OF=
", "OR", "ORDER", "OUTER", "SELECT", "SET", "SIZE", "SOME", "SQRT", "SUBSTR=
ING", "SUM", "TRAILING", "TRIM", "UPDATE", "UPPER", "WHERE", <DECIMAL_LITER=
AL>, <IDENTIFIER>, <INTEGER_LITERAL>, <STRING_LITERAL>].=20
> Type =20
> Exception Roller has encountered and logged an unexpected exception.=20
> DENTIFIER>, <INTEGER_LITERAL>, <STRING_LITERAL>].

--=20
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: htt=
p://opensource.atlassian.com/projects/roller/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira