Hi,

I having an issue with using createFilter.

When I use the following I'm get 25 records (there are 25 records in database).

(List)this.getSession().createFilter( cust.getInvoices(), "order by this.invoicedate DESC" ).list()).size()

But When I use the following createFilter, I'm getting only 10 records. Executing the same in other environments like DEV, I'm getting 15 records

(List) this.getSession().createFilter(
cust.getInvoices(),
"order by this.invoicedate DESC").setFirstResult(0).setMaxResults(15).list()

Can somebody please help me understand why I'm getting less number of records when I'm using setMaxResults()..?

Thanks,
Anu

Hi,
are you working with the same customer instance in both the cases and both of them have the same invoices in the databases you are working with?
-Srilatha.

Yes,

I'm working with same customer and same number of invoices.

using the original query in your Dev environment returns the expected results?

(List)this.getSession().createFilter( cust.getInvoices(), "order by this.invoicedate DESC" ).list()).size()

using this query
(List)this.getSession().createFilter( cust.getInvoices(), "order by this.invoicedate DESC" ).list()).size()
is giving correct value.

Actually the code is in Production and sometimes the following query is displaying 15 records and sometimes 10. It is consistently displaying 15 records in all other environments and hence not able to reproduce the issue in other environments..


(List) this.getSession().createFilter(
cust.getInvoices(),
"order by this.invoicedate DESC").setFirstResult(0).setMaxResults(15).list();

I changed the above query to the following and I'm getting the 15 records consistently. I', not able to understand why the above query is not working all the time.

(List) this.getSession().createFilter(
cust.getInvoices(),
"order by this.invoicedate DESC").list().subList(0, 15);

what kind of collection does the cust.getInvoices() returns? List or Set of Invoice instances? Also does the Invoice instance has implementation of hashCode and equals method?

Cust.getInvoices() returns Set. Invoice has no implementation of hashCode and equals methods

Enable 'show_sql' property in configuration file and get the corresponding generated SQL query for your HQL.

execute that SQL in database and see the result

It is generating the following query . When I executed it in DB giving teh rownum as 15, I'm getting 15 Invoices. How do we know what value is being used for rownum ?

select * from ( select invoice0_.INVOICEID as INVOICEID82_, invoice0_.DUEDATE as DUEDATE82_, invoice0_.TOTALAMOUNTDUE as TOTALAMO3_82_, invoice0_.INVOICEDATE as INVOICED4_82_, invoice0_.CREATEDDATE as CREATEDD5_82_, invoice0_.CREATEDBY as CREATEDBY82_, invoice0_.MODIFIEDDATE as MODIFIED7_82_, invoice0_.MODIFIEDBY as MODIFIEDBY82_, invoice0_.INVOICEGROUPID as INVOICEG9_82_, invoice0_.INVOICEFILENAME as INVOICE10_82_, invoice0_.ISFILEAVAILABLE as ISFILEA11_82_, invoice0_.TOTALNEWCHARGE as TOTALNE12_82_, invoice0_.FILEAVAILABLEDATE as FILEAVA13_82_, invoice0_.CUSTID as CUSTID82_ from INVOICE invoice0_ where invoice0_.CUSTID = ? order by invoice0_.INVOICEDATE DESC ) where rownum <= ?

Hi,

I suggest you to do the remote debugging to know what value is passed to rownum.

not sure which server and IDE you are using, but there are lot of articles in web to know how to do remote debugging for any server with and IDE.

you can find the number of objects inside the set/collection in your case if you do remote debugging