File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JPA Certification (OCEJPA) and the fly likes JPQL script query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Certification » JPA Certification (OCEJPA)
Bookmark "JPQL script query" Watch "JPQL script query" New topic

JPQL script query

Winifred Leung

Joined: May 04, 2013
Posts: 2
Hi all,

I'm new to JPQL, there is a select statement on 2 Objects.
TN object will refer to TNChar object, there relationship is 1 TN to multiple TNChars; in TN object, there is a primary key 'entityId' refer to a foreign key 'charowner' in TNChar.
If I want to search basing on the multiple TNChars to get the TN object, how I can write the JPQL.

Here is some detail about
TN.entityid = 1000 ~'PREFIX' &TNChar.value='123'
~'Region' &TNChar.value='Cen1'
refer to the sample, i want to base on the 2 TNChar records to get the TN.


Winifred Leung

Joined: May 04, 2013
Posts: 2
can anyone help? i have been stuck there for few days.....
I agree. Here's the link:
subject: JPQL script query
jQuery in Action, 3rd edition