Re: problem with removing item from a paginated list

2009-07-24 Thread Brandon Goodin
ri, Jul 24, 2009 at 8:03 AM, Odelya YomTov wrote: > Hi! > > I tried your advice, but with no solution to my problem.. > > I problem is when writing the paginated list to the jsp, not in the JAVA > code. > > > > Thanks! > > > > *From:* Jon Moores [mailto:

RE: problem with removing item from a paginated list

2009-07-24 Thread Odelya YomTov
Hi! I tried your advice, but with no solution to my problem.. I problem is when writing the paginated list to the jsp, not in the JAVA code. Thanks! From: Jon Moores [mailto:jonathan.moo...@gmail.com] Sent: Friday, July 24, 2009 1:59 PM To: user-java@ibatis.apache.org Subject: Re

Re: problem with removing item from a paginated list

2009-07-24 Thread Jon Moores
Also on the assumptions thats = your ProductData class implements the equality and hashcode methods = those methods use your 'id' field = You have a ProductData constructor that takes the id field you should simply be able to do: productList.remove(new ProductData(workingItemId)); no need to it

Re: problem with removing item from a paginated list

2009-07-24 Thread Jon Moores
Hi, I dont think you should be removing from the list while iterating at the same time. Create a separate list (deleteProductList) and replace the productList.remove() call with deleteProductList.add(tmpData). After you finish iterating productList iterate over deleteProductList calling the prod

problem with removing item from a paginated list

2009-07-24 Thread Odelya YomTov
Hi! After deleting an item, I thought to delete it from my paginated list like this: yalkutService.deleteProduct(workingItemId); ProductData tmpData; for (int i = 0; i < productsList.size(); i++) { tmpData = (ProductData) productsList.get(i); if (String.valueOf(tmpData.getMa

RE: size of paginated list

2009-07-22 Thread Andrey Rogov
RE: size of paginated list Right But I prefer not to call 2 different queries.. can I do it in one query? -Original Message- From: Andrey Rogov [mailto:konu...@gmail.com] Sent: Wednesday, July 22, 2009 9:44 PM To: user-java@ibatis.apache.org Subject: RE: size of paginated list select count

RE: size of paginated list

2009-07-22 Thread Odelya YomTov
Right But I prefer not to call 2 different queries.. can I do it in one query? -Original Message- From: Andrey Rogov [mailto:konu...@gmail.com] Sent: Wednesday, July 22, 2009 9:44 PM To: user-java@ibatis.apache.org Subject: RE: size of paginated list select count(*) From your_table

RE: size of paginated list

2009-07-22 Thread Andrey Rogov
select count(*) From your_table Your expression Before select. -Original Message- From: Odelya YomTov [mailto:ode...@jpost.com] Sent: Wednesday, July 22, 2009 11:17 PM To: user-java@ibatis.apache.org Subject: size of paginated list Hi! I need to know the size of the

size of paginated list

2009-07-22 Thread Odelya YomTov
Hi! I need to know the size of the paginated list (not per page). Because if I do: orderList.getPageSize - I get the amount of records per page, and I need to know in general how many records are there in the database. For example: If my page size is 10, and the query should return 15, it should

RE: paginated list

2005-11-04 Thread Zsolt
04, 2005 8:45 AM >To: user-java@ibatis.apache.org >Subject: Re: paginated list > >On Fri, Nov 04, 2005 at 08:22:29AM +0100, Zsolt wrote: >> The MySql driver loads everything into the memory (unless you use LIMIT), >> thus if paginated list just skips records it seems to be u

Re: paginated list

2005-11-03 Thread Eugeny N Dzhurinsky
On Fri, Nov 04, 2005 at 08:22:29AM +0100, Zsolt wrote: > The MySql driver loads everything into the memory (unless you use LIMIT), > thus if paginated list just skips records it seems to be use less. Its > functionality can be replaced with List.subList(int fromIndex, int toIndex). &g

RE: paginated list

2005-11-03 Thread Zsolt
The MySql driver loads everything into the memory (unless you use LIMIT), thus if paginated list just skips records it seems to be use less. Its functionality can be replaced with List.subList(int fromIndex, int toIndex). My log just show java.sql.ResultSet returned by ibatis, and that contains

Re: paginated list

2005-11-03 Thread Larry Meadors
Agreed - if you want pagination and performance, expect to do some stored procedures, and to get your hands dirty - it is not going to be a one step process. I am not keen on the idea of making iBATIS behave differently based on the database it is using unless it can be done by users via extension

Re: paginated list

2005-11-03 Thread Clinton Begin
PainatedList is a convenience feature, not a performance feature.  Those two goals generally work against each other.  If you're after performance, definitely DO NOT use PaginatedList.  ClintonOn 11/3/05, Michael Campbell <[EMAIL PROTECTED]> wrote: On 11/3/05, Zarar Siddiqi <[EMAIL PROTECTED]>

Re: paginated list

2005-11-03 Thread Michael Campbell
On 11/3/05, Zarar Siddiqi <[EMAIL PROTECTED]> wrote: > Woah. I was under the impression that internally it's doing what's optimal > by considering what database is being used. I noticed the "i believe" in > your post. Can you please confirm this? If so, do future releases of IBatis > plan on cons

Re: paginated list

2005-11-03 Thread Zarar Siddiqi
g PaginatedList. It doesn't seem like it should be too difficult. Zarar - Original Message - From: "Niels Beekman" <[EMAIL PROTECTED]> To: Sent: Thursday, November 03, 2005 10:07 AM Subject: RE: paginated list It doesn't, it just skips results in the R

Re: paginated list

2005-11-03 Thread Eugeny N Dzhurinsky
On Thu, Nov 03, 2005 at 04:07:11PM +0100, Niels Beekman wrote: > It doesn't, it just skips results in the ResultSet I believe. If you > want to get optimal performance, roll your own implementation of paging > and use the LIMIT/OFFSET statements, however, it won't be > database-independent. Okay,

RE: paginated list

2005-11-03 Thread Niels Beekman
lto:[EMAIL PROTECTED] Sent: donderdag 3 november 2005 16:04 To: user-java@ibatis.apache.org Subject: paginated list Can somebody please explain how this work? I need to show results from some table, i'm using limit/offset statements in SQL query, but I saw iBATIS can handle pages in result se

paginated list

2005-11-03 Thread Eugeny N Dzhurinsky
Can somebody please explain how this work? I need to show results from some table, i'm using limit/offset statements in SQL query, but I saw iBATIS can handle pages in result set somehow, so I might not be forced to add limit/offset statements in the SQL clauses. But I'm wandering how does iBATIS h

Re: Paginated List Problem

2005-11-02 Thread Clinton Begin
You can't use the same paginated list for two different threads.  The root of this problem seems to have nothing to do with iBATIS...but does suggest a serious design problem in your application.  Sorry to sound harsh, but I wouldn't be doing you any favors if I softened th

Re: Paginated List Problem in Ibatis

2005-10-26 Thread Sabyasachi Biswas
Hi Larry,   Thank You for your response.   I have a instance variable Paginated List , that all my methods use . There are a large number of methods that use this Paginated List object. I had thought it would not be feasible by making so many objects of The Paginated List in each of my methods

Re: Paginated List Problem in Ibatis

2005-10-24 Thread Larry Meadors
Why do you "have to use only one object of Paginated List"? You can use as many as you want. It sounds like your dao is storing the paginated list..that would be a really bad idea. Maybe you can explain what you are trying to do in more detail... Larry On 10/24/05, Sabyasachi Bisw

Paginated List Problem in Ibatis

2005-10-24 Thread Sabyasachi Biswas
Hi all,   I am having a problem using paginated List in my Project.   I am using the same Paginated List object for various purposes(I have to use only one object of Paginated List). The problem arises when there are concurrent users ,  the Paginated List Object returned should be different for

Paginated List Problem

2005-10-24 Thread Sabyasachi Biswas
Hi all,   I am having a problem using paginated List in my Project.   I am using the same Paginated List object for various purposes(I have to use only one object of Paginated List). The problem arises when there are concurrent users ,  the Paginated List Object returned should be different for

RE: Question about paginated list.

2005-09-29 Thread Steve Biondi
From: anton [mailto:[EMAIL PROTECTED] Sent: Thu 2005-09-29 7:27 PM To: user-java@ibatis.apache.org Subject: Question about paginated list. Hi, Recently im working with paging feature in my web application, and I need to get a ranged results from a query, lets say that my query will get 10.000

Question about paginated list.

2005-09-29 Thread anton
Hi, Recently im working with paging feature in my web application, and I need to get a ranged results from a query, lets say that my query will get 10.000 records but I want to get only 10 records from it,(eg starting from record 9.980 until record 9.990), I already know iBATIS paginated