Forums Register Login

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

+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
 


I am getting exception


And what is that exception?
+Pie Number of slices to send: Send
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
How do they get the deer to cross at the signs? Or to read this tiny ad?
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 906 times.
Similar Threads
Storing multiple query string and execute them using result set
Need more values from Other DB
java data structures
Dynamic addition of items to combo inJSP
Files vs Arrays?
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 19, 2024 03:02:00.