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
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