• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Liutauras Vilda
  • Paul Clapham
  • paul wheaton
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Piet Souris
  • Mike London

How to get fixed size of data from Stored Poc using Ibatis

Posts: 29
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am using stored procedure and inside that a cursor will return data to my Ibatis Layer.
Now I have see in some cases the data size is huge (1lakh) . My JVM will not be able to hold that size of data .
How i can set a Max size of data using ibatis ? say I will just return only first 1000 row , no more than that .

Note:I know it can be using by changing SP , but is anything can be done in Ibatis layer to ask my procedure to return only 1000 row.
    Bookmark Topic Watch Topic
  • New Topic