Re: Questions regd ibatis best practices - need some help here

2009-07-27 Thread Clinton Begin
LOL... I have a feeling that we'll deprecate them, but kind of like how Sun deprecated the Date methods. They'll always be there. Don't be offended by the strikethroughs in the documentation. :-) Clinton On Mon, Jul 27, 2009 at 1:04 PM, Hugh Ross wrote: > Sorry to hear about the deprecation o

Re: Questions regd ibatis best practices - need some help here

2009-07-27 Thread Hugh Ross
Sorry to hear about the deprecation of Parameter Maps in iBATIS3. I like them for keeping the SQL parts of our SqlMaps cleaner. Also seems consistent with use of Result Maps for Selects... On 7/24/09, Jeff Butler wrote: > You don't need a parameter map for procedures in iBATIS2. This is > from

Re: Pagination by objects

2009-07-27 Thread John Seer
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

Re: Pagination by objects

2009-07-27 Thread John Seer
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

Re: Pagination by objects

2009-07-27 Thread Sundar Sankar
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,

Re: Pagination by objects

2009-07-27 Thread Clinton Begin
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 >

Re: Pagination by objects

2009-07-27 Thread Clinton Begin
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

Re: Pagination by objects

2009-07-27 Thread John Seer
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..

Re: Pagination by objects

2009-07-27 Thread Larry Meadors
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

Re: Pagination by objects

2009-07-27 Thread John Seer
>>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

Need to iterate over table names dynamically

2009-07-27 Thread dyptee
Hi I have a list of tables(versions of a master table) . I need to iterate over all the versions of the master table and search for a particular entry. I know for dynamic table name we can use $table$, however I cant figure out how to apply iterate tag here basic idea is select * from (v1/v2/v3)

Re: LazyLoading and CGLIB return wrong types

2009-07-27 Thread Clinton Begin
Have you tried serializing to XStream or another alternative, instead of using Java's serialization? While this is a limitation of iBATI 2 (version 3 solves it somewhat, but still not between systems), you should never depend on Java serialization for connecting two systems. You should choose a m

Re: LazyLoading and CGLIB return wrong types

2009-07-27 Thread Dawson Lewis
Hi, Do you have any clue in how to do that ? I created a clone method for the Address class so every object is cloned before it is serialized. It works fine but do you think this is a good idea ? Best Regards Stelio Larry Meadors wrote: > > You should be able to, yeah. > > Larry > > > On T