Thanks Clinton,
I was thinking doing it with IN, but I thinking creating temp table with ids
and doing pagination on it will work faster
Clinton Begin wrote:
>
> Ah, I know what you're talking about.
> There's no way to solve that, other than to load less data, or load each
> object up separ
Thanks Clinton,
I was thinking doing it with IN, but I thinking creating temp table with ids
and doing pagination on it will work faster
Clinton Begin wrote:
>
> Ah, I know what you're talking about.
> There's no way to solve that, other than to load less data, or load each
> object up separ
or you could select * from (select rownum as ro, * from XXXView) where ro
between 1 and 1000.
If you had rownum as part of your view, I guess you could use that as the ID
and Ibatis queryForList might work too.
On Mon, Jul 27, 2009 at 11:30 AM, Clinton Begin wrote:
> Larry,
> He's doing a join,
Larry,
He's doing a join, so each result object is made up of possibly many rows.
So simply skipping arbitrary rows will create incomplete objects.
Clinton
On Mon, Jul 27, 2009 at 12:12 PM, Larry Meadors wrote:
> I'll put this as nicely as I can: What the heck are you talking about?
>
> Larry
>
Ah, I know what you're talking about.
There's no way to solve that, other than to load less data, or load each
object up separately. If I'm not mistaken, not even a full ORM will be able
to do that without first building the entire map of keyed relationships.
For example, an ORM could look up all
The heck I am talking about is that this shit doesn't work for me
Larry Meadors wrote:
>
> I'll put this as nicely as I can: What the heck are you talking about?
>
> Larry
>
> -
> To unsubscribe, e-mail: user-java-unsubscr..
I'll put this as nicely as I can: What the heck are you talking about?
Larry
-
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
>>You could start with the documentation...or even just your IDE code
>>completion... :-)
>>Look up the queryForList method signatures..
queryForList is taking start row number and end row number.
For example if I have temp table with 200k rows which was build using left
joins, and if I will
You could start with the documentation...or even just your IDE code
completion... :-)
Look up the queryForList method signatures..
Clinton
On Fri, Jul 24, 2009 at 4:39 PM, John Seer wrote:
>
> Hello,
>
> I am using in one of my projects ibatis and have a problem with pagination.
>
> For examp
Hi Larry,
I our project for pagination, we use sql. we do the nested select within a
select within a select.
Is there a better way to do it in general and in iBatis.
regards
Ashok
On 7/2/07, Larry Meadors <[EMAIL PROTECTED]> wrote:
..unless you can do it in the SQL instead. :)
Some drivers
..unless you can do it in the SQL instead. :)
Some drivers want to bring back all the data before processing it, so
it can cost you dearly to do this in the Java side.
Larry
On 7/2/07, Clinton Begin <[EMAIL PROTECTED]> wrote:
Right. Don't use the paginator stuff...but feel free to still use
user-java@ibatis.apache.org; [EMAIL PROTECTED]
Subject: Re: Pagination
Right. Don't use the paginator stuff...but feel free to still use the
query limits:
queryForList("statement", param, offset, maxrows)
clinton
On 7/1/07, Larry Meadors <[EMAIL PROTECTED]> wrote:
>
Right. Don't use the paginator stuff...but feel free to still use the
query limits:
queryForList("statement", param, offset, maxrows)
clinton
On 7/1/07, Larry Meadors <[EMAIL PROTECTED]> wrote:
The best example is one that doesn't exist: don't use it. :)
It's not going to be in iBATIS 3 beca
Thanks Larry,
What about transaction management? (start, commit, rollback and end). Can I
use it normally?
On 7/1/07, Larry Meadors <[EMAIL PROTECTED] > wrote:
The best example is one that doesn't exist: don't use it. :)
It's not going to be in iBATIS 3 because it's not really part of the
core
The best example is one that doesn't exist: don't use it. :)
It's not going to be in iBATIS 3 because it's not really part of the
core of what iBATIS does - mapping data.
Most all modern databases provide similar functionality that will
perform better, and use fewer resources.
Larry
On 7/1/07
If you are looking for ibatis to write the jsp that will never happen. Pagination can be achieved by simple jslt and queryForList().NathanOn Aug 10, 2006, at 1:42 AM, puneet arya wrote:Hi, Can anybody tell me the link or way(code) to achieve pagination through Ibatis and Jsp.
Not sure exactly what you're looking for, but there's a
"queryForList(String statementName, Object parameterObject, int
skipResults, int maxResults)" method, but note that it works by
obtaining all the elements(keys) from the DB then just returning the
selected part of the list - if the tables la
n the
specified interval.
Thanks n Regards,
Rambabu
-Original Message-
From: Jerome Gagner [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 25, 2006 12:22 PM
To: user-java@ibatis.apache.org
Subject: Re: ---PaginationNeed help
What database? You can do it in queryForLis
I'm guessing that you're probably trying to combine pagination with join mapping (i.e. groupBy and resultMap attribute).That combination cannot work, and there's really nothing iBATIS can do about it.Is that the case?
Cheers,ClintonOn 7/25/06, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:
H
What database? You can do it in queryForList and have Ibatis limit it,
but I wouldn't recommend doing it that way.
On 7/24/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi,
I have two tables user_info and user_dynamic_info
the following is the table structure
user_info
===
user_id
20 matches
Mail list logo
