[#RDBMS-59] JDOQL : navigational query through two levels of collection using declareVariables causes invalid SQL - DataNucleus JIRA

JPOX RDBMS (ARCHIVED)

JDOQL : navigational query through two levels of collection using declareVariables causes invalid SQL

Created: 28/Aug/06 09:49 PM Updated: 23/Mar/09 12:30 PM

Component/s:

Queries

Affects Version/s:

None

Fix Version/s:

None

File Attachments:	1. jpox.zip (2 kB)
Environment:	jpox 1.1.1 - Windows platform - mysql5 - Java5

Forum Thread URL:	http://www.jpox.org/servlet/forum/viewthread?thread=3701
Datastore:	MySQL
Severity:	Development

Description

« Hide

problem reported in forum :
http://www.jpox.org/servlet/forum/viewthread?thread=3701

Summary :

Query aQuery = pm.newQuery(virtualdoc.class, "fieldsList.contains(aField) && aField.name =='fieldName' && aField.values.contains(aValue) && aValue.length()>0")
aQuery.declareImports("import virtual.*");
aQuery.declareVariables("virtual.virtualField aField; java.lang.String aValue");
aQuery.execute();

Error : java.sql.SQLException: Unknown column 'UNBOUND_AFIELD_VALUES_AVALUE.STRING_ELE' in 'where clause'

bug report requested by Erik.

Thanks.

Sort Order:

[ Permalink | « Hide ]

Clinton Lee added a comment - 30/Jul/07 08:19 AM

I am expierencing the same issue using JPOX 1.1.8 and believe this is related to (or dare I say the same as?) bug CORE-2700

[ Permalink | « Hide ]

Andy Jefferson added a comment - 23/Mar/09 12:30 PM

Query issues like this will not be addressed with the legacy JDOQL implementation; wait for "JDOQL2" to be complete