Re: QueryForList : How does maxRows work?

2007-05-11 Thread Clinton Begin
PS: if it hasn't been made clear by my previous posts, if you call queryForList with a maxRows attribute, it will only request that many rows back from the database. It won't bring back all 10k. This of course depends on the driver, but I've never seen one that does something that silly. ;-)

Re: QueryForList : How does maxRows work?

2007-05-11 Thread Clinton Begin
If it's a proc returning that result set, then I doubt setMaxRows would help anyway. You can't just apply a limit outside of the scope of the proc, the result set has already been built. The only applicable performance factor that you have control of outside of the proc is the fetch size, the si

RE: How to map getBytes in iBATIS?

2007-05-11 Thread Paul Sanders
Thanks for the suggestions. I'm going to be quick and say I didn't write this code as I would not have duplicated the getBytes call in the original source. Anyway, I wrote my own custom type handler and it all works just super. Niels Beekman-2 wrote: > > Hi, > > I don't believe there is a way

RE: unable to load dao.xml outside of .war

2007-05-11 Thread Sheehan, Andrew
Have you tried using java.net.Url, or one of its subtypes, to locate it? From: Jane Phillips [mailto:[EMAIL PROTECTED] Sent: Friday, May 11, 2007 8:53 AM To: user-java@ibatis.apache.org Subject: unable to load dao.xml outside of .war Hello, I am new to iBati

unable to load dao.xml outside of .war

2007-05-11 Thread Jane Phillips
Hello, I am new to iBatis and need help on one,maybe simple to you, problem. I need to read dao.xml file from a config path which is out side of the .ear or .war package. I was required to put all those .xml files(dao.xml , sqlMap.xml and datasource.properties etc) under a arbitrary direct

Re: iBatis without Bind variables?

2007-05-11 Thread Koka Kiknadze
Well you can go the $$ way as Larry indicated, but he also did warn you ;) What I liked in iBatis from the very start was that it's ME who controls all the sql and I can add optimizer hints in iBatis statements. I use Oracle, but hope the following applies to DB2 too: I'd try including hints i