Eclipse Community Forums: EclipseLink » JPQL queries on Virtual Access Method fields

Home » Eclipse Projects » EclipseLink » JPQL queries on Virtual Access Method fields(JPQL queries on Virtual Access Method fields (Extensible Entities))

JPQL queries on Virtual Access Method fields [message #1061731]

Mon, 03 June 2013 11:50

Eclipse User

I was wondering if its possible to write JPQL queries against fields that are defined as Virtual? If so, whats the syntax?

For example:

@VirtualAccessMethods(get = "getFlexField", set = "setFlexField")
class SomeEntity{
Map<String,Object> flexFields;

Object getFlexField(String field);
void setFlexField(String field, Object value);
}

if i have the following dynamically defined:

<entity class="SomeEntity">
<attributes>
<basic name="FLEX_1" attribute-type="java.lang.Double" access="VIRTUAL">
<column name="FLEX_1"/>
</basic>
</attributes>
</entity>

Can I write a JPQL query that will load all 'SomeEntity' objects where FLEX_1 is some value?

"SELECT e FROM SomeEntity e WHERE e.FLEX_1 = 3"

(syntax is bogus but something like this)

Re: JPQL queries on Virtual Access Method fields [message #1061883 is a reply to message #1061731]

Tue, 04 June 2013 09:54

Eclipse User

The virtual attribute's "name" can be used in JPQL or Criteria. In your case this would be "FLEX_1".

(your syntax is correct)

Previous Topic:	EclipseLink DBWS with JPQL
Next Topic:	Accesing Eclipselink DBWS

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 27 04:34:00 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter