optimistic locking

2010-01-16 Thread OBender
Hi All, I've noticed that as of iBatis 2.5.x there were no optimistic locking support (as per Google search :)) in iBatis. Has anything changed since then? Thanks.

read large result set in Ibatis3

2010-01-16 Thread Tomáš Procházka
Hi. I need read large result set from DB (like 300 000 rows). It's possible use this: @Select({"SELECT * FROM send) List getAllItems(); ? but instead of read all rows to List use server cursor and read only items which will be accessed by Iterator. I found some old article about this proble

Re: read large result set in Ibatis3

2010-01-16 Thread Clinton Begin
Yes, you can use ResultHAndler in iBATIS 3. The key to know is that the large result set will be fine if the query is as simple as you've presented. However, if you use associations or collections mappings, then you could run into memory issues. Cheers, Clinton 2010/1/16 Tomáš Procházka > > H