[#OPENJPA-199] bulk update gets parsing exception trying to update an attribute of an embedded class

OpenJPA

bulk update gets parsing exception trying to update an attribute of an embedded class

Created: 04/Apr/07 11:34 PM Updated: 11/Dec/07 01:25 AM

Return to search

Component/s:

query

Affects Version/s:

0.9.7

Fix Version/s:

1.0.0

Time Tracking:

Not Specified

File Attachments:

	File Name	Date Attached	Attached By	Size
	embeddedBugWineryTest.zip	2007-04-04 11:36 PM	George Hongell	29 kB

Environment:

0.9.7-incubating-SNAPSHOT

Issue Links:

Duplicate

This issue is duplicated by:

~~OPENJPA-461~~ JPQL: navigation through embedded class field does not work

Resolution Date:

01/Jul/07 09:13 PM

Description

« Hide

<4|false|0.9.7-incubating-SNAPSHOT> org.apache.openjpa.persistence.ArgumentException: An error occurred while parsing the query filter 'update Wine w set w.label.wineName = ?1'. Error message: <4|false|0.9.7-incubating-SNAPSHOT> org.apache.openjpa.kernel.jpql.ParseException: Encountered "." at character 26, but expected: ["="].
at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:1661)
at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.<init>(JPQLExpressionBuilder.java:1641)
at org.apache.openjpa.kernel.jpql.JPQLParser.parse(JPQLParser.java:44)
at org.apache.openjpa.kernel.ExpressionStoreQuery.newCompilation(ExpressionStoreQuery.java:141)
at org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:643)
at org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:625)
at org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:591)
at org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:653)
at org.apache.openjpa.kernel.QueryImpl.getOperation(QueryImpl.java:1475)
at org.apache.openjpa.kernel.DelegatingQuery.getOperation(DelegatingQuery.java:120)
at org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:305)
at com.ibm.websphere.ejb3sample.winetour.bug.BugWineryTest.testBulkUpdate(BugWineryTest.java:551)
at com.ibm.websphere.ejb3sample.winetour.bug.BugWineryTest.main(BugWineryTest.java:141)
Caused by: <4|false|0.9.7-incubating-SNAPSHOT> org.apache.openjpa.persistence.ArgumentException: Encountered "." at character 26, but expected: ["="].
at org.apache.openjpa.kernel.jpql.JPQL.generateParseException(JPQL.java:9322)
at org.apache.openjpa.kernel.jpql.JPQL.jj_consume_token(JPQL.java:9199)
at org.apache.openjpa.kernel.jpql.JPQL.EQ(JPQL.java:5718)
at org.apache.openjpa.kernel.jpql.JPQL.update_item(JPQL.java:729)
at org.apache.openjpa.kernel.jpql.JPQL.set_clause(JPQL.java:706)
at org.apache.openjpa.kernel.jpql.JPQL.update_clause(JPQL.java:701)
at org.apache.openjpa.kernel.jpql.JPQL.update_statement(JPQL.java:147)
at org.apache.openjpa.kernel.jpql.JPQL.parseQuery(JPQL.java:65)
at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:1654)
... 12 more

Description

<4|false|0.9.7-incubating-SNAPSHOT> org.apache.openjpa.persistence.ArgumentException: An error occurred while parsing the query filter 'update Wine w set w.label.wineName = ?1'. Error message: <4|false|0.9.7-incubating-SNAPSHOT> org.apache.openjpa.kernel.jpql.ParseException: Encountered "." at character 26, but expected: ["="]. at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:1661) at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.<init>(JPQLExpressionBuilder.java:1641) at org.apache.openjpa.kernel.jpql.JPQLParser.parse(JPQLParser.java:44) at org.apache.openjpa.kernel.ExpressionStoreQuery.newCompilation(ExpressionStoreQuery.java:141) at org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:643) at org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:625) at org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:591) at org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:653) at org.apache.openjpa.kernel.QueryImpl.getOperation(QueryImpl.java:1475) at org.apache.openjpa.kernel.DelegatingQuery.getOperation(DelegatingQuery.java:120) at org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:305) at com.ibm.websphere.ejb3sample.winetour.bug.BugWineryTest.testBulkUpdate(BugWineryTest.java:551) at com.ibm.websphere.ejb3sample.winetour.bug.BugWineryTest.main(BugWineryTest.java:141) Caused by: <4|false|0.9.7-incubating-SNAPSHOT> org.apache.openjpa.persistence.ArgumentException: Encountered "." at character 26, but expected: ["="]. at org.apache.openjpa.kernel.jpql.JPQL.generateParseException(JPQL.java:9322) at org.apache.openjpa.kernel.jpql.JPQL.jj_consume_token(JPQL.java:9199) at org.apache.openjpa.kernel.jpql.JPQL.EQ(JPQL.java:5718) at org.apache.openjpa.kernel.jpql.JPQL.update_item(JPQL.java:729) at org.apache.openjpa.kernel.jpql.JPQL.set_clause(JPQL.java:706) at org.apache.openjpa.kernel.jpql.JPQL.update_clause(JPQL.java:701) at org.apache.openjpa.kernel.jpql.JPQL.update_statement(JPQL.java:147) at org.apache.openjpa.kernel.jpql.JPQL.parseQuery(JPQL.java:65) at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:1654) ... 12 more

Show »

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

George Hongell made changes - 04/Apr/07 11:36 PM

Field	Original Value	New Value
Attachment		embeddedBugWineryTest.zip [ 12354963 ]

Patrick Linskey made changes - 01/Jul/07 09:13 PM

Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Resolved [ 5 ]

Repository	Revision	Date	User	Message
ASF	#552363	Sun Jul 01 21:13:16 UTC 2007	pcl	~~OPENJPA-199~~. Passed all local tests; I have not run against the CTS though. It should work against the CTS, as it was a bug on our side, and not the spec's side.
				Files Changed
				MODIFY /openjpa/trunk/openjpa-kernel/src/main/jjtree/org/apache/openjpa/kernel/jpql/JPQL.jjt ADD /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/relations/TestBulkUpdatesAndEmbeddedFields.java

[ Permlink | « Hide ]

Patrick Linskey added a comment - 01/Jul/07 09:14 PM

The OpenJPA parser did not allow any path traversals in the left-hand side of SET clause items.

Patrick Linskey made changes - 01/Jul/07 09:14 PM

Fix Version/s

1.0.0 [ 12312341 ]

Patrick Linskey made changes - 11/Dec/07 01:25 AM

Link

This issue is duplicated by ~~OPENJPA-461~~ [ ~~OPENJPA-461~~ ]