File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes Selecting data from more than one table: I am getting exception 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 » Databases » Object Relational Mapping
Bookmark "Selecting data from more than one table: I am getting exception" Watch "Selecting data from more than one table: I am getting exception" New topic
Author

Selecting data from more than one table: I am getting exception

Arun R. S. Chandran
Ranch Hand

Joined: Oct 08, 2008
Posts: 81
Hi everybody,

I am usin Hibernate as JDBC. I want to select datas fro two tables.
For example the field names are datavalue and reportindex. I wish to take reportindex which is a PRIMARY KEY field of table: funnelguagemain and it is a FORIEGN KEY field of table: funnelguagecontens.

The data value field content coming under funnelguagecontents table. I wish to select the report index by some condition and accoring to that reportindexes I've select datavalue from funnelguage tables.
Thes getting values shoul be store in a single list.
In that list reportindex may repeat. Imeant the reportindex field is repeating in tne table report contents.

I tried in may ways, but I couldn't reach a solution can anybody help me..
please..
Tanks
-Arun
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


I am getting exception

And what is that exception?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Arun R. S. Chandran
Ranch Hand

Joined: Oct 08, 2008
Posts: 81
Different times I got different exceptions.
1. Right paranthesis missing
2. single query returns more than one row.

Like that I got exceptions.

But I correct allthose exceptions and I run the query It is running and not stopping. I more thing I am not using a loop.. Then Why it is not stopping .

The Query I wrot is given below

"Select new GuageReportdata(fgrc.datavalue,fgrc.funnelguagereportmain.reportindex)
from Funnelguagereportcontents fgrc, Funnelguagereportmain fgrm where fgrm.shopnumber=?
and fgrm.guagetype=? and to_char(fgrm.datetime,'DD-mm-yyyy hh24:mi:ss') between ? and ?
and fgrm.totalpoints > 0 and fgrm.entry1=? order by fgrm.reportindex desc

"

Thanks
-Arun
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Selecting data from more than one table: I am getting exception
 
Similar Threads
Need more values from Other DB
Dynamic addition of items to combo inJSP
java data structures
Storing multiple query string and execute them using result set
Files vs Arrays?