aspose file tools*
The moose likes Object Relational Mapping and the fly likes is there a limit on the number of records returned by queryForList method of SqlMapClientTemplate? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "is there a limit on the number of records returned by queryForList method of SqlMapClientTemplate?" Watch "is there a limit on the number of records returned by queryForList method of SqlMapClientTemplate?" New topic
Author

is there a limit on the number of records returned by queryForList method of SqlMapClientTemplate?

Vinny Menon
Ranch Hand

Joined: Jan 10, 2006
Posts: 62

Hi fellow ranchers,
i am using ibatis 2.3.0.

i am using a oracle database query which returns 150019 records when run in the database through regular database ide tools.

when i map the same query to sqlmap,and call it from my java code,it returns me only 50007 records

hence my question:is there a limit to the number of records for the method queryForList of SqlMapClientTemplate

thanks in advance,

cheers

Vinny



Regards,Vinny M.
proud Fan of European Champion CHELSEA FC
"If you don't see the bug where you're looking, perhaps you're looking in the wrong place" -James Gosling
Vinny Menon
Ranch Hand

Joined: Jan 10, 2006
Posts: 62

Hi fellow ranchers,
i am using ibatis 2.3.0.

i am using a oracle database query which returns 150019 records when run in the database through regular database ide tools.

when i map the same query to sqlmap,and call it from my java code,it returns me only 50007 records

hence my question:is there a limit to the number of records for the method queryForList of SqlMapClientTemplate

thanks in advance,

cheers

Vinny


Vinny Menon
Ranch Hand

Joined: Jan 10, 2006
Posts: 62

i got the result properly. the object mapping was such that the final records numbers would be 50007 which is correct.this issue can be closed.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: is there a limit on the number of records returned by queryForList method of SqlMapClientTemplate?
 
Similar Threads
Number of EJB Instances returned from findBy method
Want clarification for some of the methods of Criteria class of org.hibernate
Thread.interrupt kills database connection
How to use streaming when query the database opposed to retrieve all data at once in resultset.
executeBatch() failing for 100 and above