SQL issue while running from java

Hello
I have used a similar SQL in a jasperreport:"select
invoice.invoiceNo, fromWh.WhName as fromWhName,
toWh.WhName as toWhName from invoice inner join IcWh
as fromWh on (invoice.whId=fromWh.WhId) inner join
IcWh as toWh on (invoice.Whid=toWh.WhId)"

The report is running fine while I run it from iReport
but it does not find the column fromWhName or toWhName
while I run the report from java program.

Can you help to resolve this issue?

Thanks in advance.

Regards,
Mortoza



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642