This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes EJB and other Java EE Technologies and the fly likes using join sql statements on EJB with cmp Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "using join sql statements on EJB with cmp" Watch "using join sql statements on EJB with cmp" New topic
Author

using join sql statements on EJB with cmp

ram v
Greenhorn

Joined: Jul 17, 2001
Posts: 1
Hi All,
Thanx in advance.
Can you please mail me an example for using a sql join statement with the EJB using Container Managed Persistance.
Thanx and Regards,
Ram
There is an expert in everyone.


Regards,<BR>Ram
anup vachali
Ranch Hand

Joined: Oct 17, 2000
Posts: 54
Use a custom sql finder method:
select a.* from XYZ a, ABC b where a.field_name = b.field_name
Matt Midcap
Sheriff

Joined: Jan 07, 1999
Posts: 440
"ram v",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please log in with a new name which meets the requirements.
Thanks.


Best Regards,<br />Matt Midcap
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: using join sql statements on EJB with cmp
 
Similar Threads
Null Values
question about CMP?
Ejb ql ORDER BY with null cmr
Entity EJB and SQL
Can we execute sql query with outer join in hibernate