Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@openjpa.apache.org
Message-ID: <21976961.138831294165607458.JavaMail.jira@thor>
Date: Tue, 4 Jan 2011 13:26:47 -0500 (EST)
From: "Fay Wang (JIRA)" <jira@apache.org>
To: dev@openjpa.apache.org
Subject: [jira] Commented: (OPENJPA-1914) Issue with OpenJPA 1.2.1 while
 using subquery.
In-Reply-To: <22889028.130181294135545173.JavaMail.jira@thor>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/OPENJPA-1914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12977392#action_12977392 ] 

Fay Wang commented on OPENJPA-1914:
-----------------------------------

According to the spec, the BNF of the in_expression, subquery are:

in_expression ::=
state_field_path_expression [NOT] IN ( in_item {, in_item}* | subquery)

subquery ::= simple_select_clause subquery_from_clause [where_clause][groupby_clause] [having_clause]

simple_select_clause ::= SELECT [DISTINCT] simple_select_expression

As can be seen from the BNF, the LHS of the in_expression can be one and only one path expression and the subquery can select one and only one expression or variable. 

The where clause in your JPQL, therefore, is incorrect: 
WHERE (jrNbr.countryCode,jrNbr.sourceCode) NOT IN (SELECT vNbr.countryCode,vNbr.sourceCode FROM VoucherNumber vNbr,Country ctyEntity WHERE vNbr.countryCode = ctyEntity.cty AND ctyEntity.cln_identity=:clnIdentity)"; 


> Issue with OpenJPA 1.2.1 while using subquery.
> ----------------------------------------------
>
>                 Key: OPENJPA-1914
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1914
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 1.2.1
>         Environment: Database server        = DB2 z/OS 9.1.5   in AIX system. Working from standalone java program. using log4j-1.2.14.jar and geronimo-jpa_3.0_spec-1.0.jar
>            Reporter: JaiKumar
>
> On using below code to update an JournalNumber entity .. 
> tx = entityManager.getTransaction();
>         	tx.begin();
>         	System.out.println("...Clone :" + cloneId);
>         	String query = "UPDATE JournalNumber jrNbr SET jrNbr.updated_on=:updatedOn WHERE (jrNbr.countryCode,jrNbr.sourceCode) NOT IN(SELECT vNbr.countryCode,vNbr.sourceCode FROM VoucherNumber vNbr,Country ctyEntity WHERE vNbr.countryCode = ctyEntity.cty AND ctyEntity.cln_identity=:clnIdentity)";
>         	Query q = entityManager.createQuery(query);
>         	q.setParameter("updatedOn", new Date());
>         	q.setParameter("clnIdentity", cloneId);
>         	q.executeUpdate();
>             tx.commit();
> I get below error ..
> <openjpa-1.2.1-r752877:753278 nonfatal user error> org.apache.openjpa.persistence.ArgumentException: Encountered "jrNbr . countryCode ," at character 67, but expected: ["(", ")", "*", "+", "-", ".", "/", ":", "<", "<=", "<>", "=", ">", ">=", "?", "ABS", "ALL", "AND", "ANY", "AS", "ASC", "AVG", "BETWEEN", "BOTH", "BY", "CONCAT", "COUNT", "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP", "DELETE", "DESC", "DISTINCT", "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", "SUBSTRING", "SUM", "TRAILING", "TRIM", "UPDATE", "UPPER", "WHERE", <DECIMAL_LITERAL>, <IDENTIFIER>, <INTEGER_LITERAL>, <STRING_LITERAL>].

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.