Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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


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 "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]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: problem with accessing resultset from multiple tables
 
Similar Threads
I/O Streams: Object not reconstructing on client side
Linking internal frames with a line
Table Formating
Joining two tables using hibernate
How to implement this? Map database tables to a java object