Win a copy of Mastering Corda: Blockchain for Java Developers this week in the Cloud/Virtualization forum!

umair naqvi

Greenhorn
+ Follow
since Nov 08, 2008
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by umair naqvi

I have two tables namely deliverydetails and supplybilldetails with following SQL create statements





Their respective classes are

getters and setters are omitted……..


getters and setters are omitted……..


Tables are connected with supplybilldetail.id  deliverydetails.billdetailid

Problem is that I need to find the HQL query for the group sum of deliverydetails.qty on deliverydetails.billdetailid but I simply can’t. Following query works



I want to add something like
“ where s.qty > sum(d.qty) group by s.id “ can somebody help me out???
I'm trying to generate reports with jasper in netbeans 6.1 with Tomcat 6.0 Jasper Report 2.0.5. My code given below, runs well in Java desktop application but not in jsp nor does not give any error.
Why does it work in java desktop application but not in JSP?
Thanks in advance.

[ November 10, 2008: Message edited by: umair naqvi ]