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 Android Security Essentials Live Lessons this week in the Android 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.....
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: JPQL script query
Similar Threads
Regarding apply JOIN by using JPQL.
jpql, join on?
alternate Floor function in JPA
Join Fetch using EclipseLink
outer join in HQL