This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan 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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
Can we execute sql query with outer join in hibernate
Entity EJB and SQL