aspose file tools*
The moose likes EJB and other Java EE Technologies and the fly likes problem with accessing resultset from multiple tables Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "problem with accessing resultset from multiple tables" Watch "problem with accessing resultset from multiple tables" New topic
Author

problem with accessing resultset from multiple tables

Angellika desai
Greenhorn

Joined: Nov 06, 2011
Posts: 8
hello.. my problem is that i have a query which has inner join connected with 5 tables in a databae..the result is to be fetched lyk one column from all of this tables...
my question is..How to get access to such a result?
can List be used or something else is needed?
if yes then how? please..reply
Hebert Coelho
Ranch Hand

Joined: Jul 14, 2010
Posts: 754

You could create a Class and map all the other tables in it.

JPA Mapping two Tables in one Class I show how to map two but you can map more.


[uaiHebert.com] [Full WebApplication JSF EJB JPA JAAS with source code to download] One Table Per SubClass [Web/JSF]
 
 
subject: problem with accessing resultset from multiple tables