Issue Details (XML | Word | Printable)

Key: NUCRDBMS-324
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Unassigned
Reporter: André
Votes: 1
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
DataNucleus RDBMS

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

Created: 28/Aug/06 09:49 PM   Updated: 17/Mar/10 08:52 PM   Resolved: 04/Mar/10 06:04 PM
Component/s: Queries
Affects Version/s: None
Fix Version/s: 2.0.2

File Attachments: 1. Zip Archive 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: Ascending order - Click to sort in descending order
André made changes - 28/Aug/06 09:49 PM
Field Original Value New Value
Attachment jpox.zip [ 10305 ]
Andy Jefferson made changes - 06/Sep/06 10:06 AM
Fix Version/s 1.2.0 [ 10021 ]
Andy Jefferson made changes - 03/Oct/06 06:19 PM
Assignee JPOX Administrator [ admin ]
Andy Jefferson made changes - 16/Jul/07 06:47 PM
Summary navigational query through two levels of collection using declareVariables JDOQL : navigational query through two levels of collection using declareVariables causes invalid SQL
Andy Jefferson made changes - 09/Dec/07 11:45 AM
Project Core [ 10000 ] RDBMS [ 10111 ]
Key CORE-2951 RDBMS-59
Component/s Queries [ 10111 ]
Component/s Queries [ 10030 ]
Fix Version/s 1.2.0 [ 10021 ]
Affects Version/s 1.1.1 [ 10130 ]
Andy Jefferson made changes - 04/Mar/10 06:01 PM
Project JPOX RDBMS (ARCHIVED) [ 10111 ] DataNucleus RDBMS [ 10144 ]
Key RDBMS-59 NUCRDBMS-324
Component/s Queries [ 10142 ]
Component/s Queries [ 10111 ]
Andy Jefferson made changes - 04/Mar/10 06:04 PM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 2.0.2 [ 10870 ]
Resolution Fixed [ 1 ]
Andy Jefferson made changes - 17/Mar/10 08:52 PM
Status Resolved [ 5 ] Closed [ 6 ]