Query working in Resultset but not jasper report

The following Query works when i directly execute in database and even in java project resultset but does not works in Ireport, i suspect problem is count and sum funtions as when i remove them it works fine ..

Select ISBN,BookTitle,Author1,Author2,Author3,Category,Edition,Publisher,PublishingYear,Price,BookSelfName,Volume,Language,Subject, sum(case when status='Available' then 1 else 0 end) as Available, count(*) as Total
from Book
group by ISBN, BookTitle

Error is

Error:General Problem:null Check username and password;is the DBMS active?!