Referencing iterable fields as properties of a dynamic SQL statement

2008-12-01 Thread Pieper, Aaron (SAIC)
I'm having a problem using iBatis to implement a dynamic SQL query. For this query, the user specifies a list of strings, and they're allowed to specify "null". I want iBatis to query for the records matching the strings they specify. If they specify "null" as one of the list elements, then I want

IBATIS and OSGI performance issues

2008-12-01 Thread dereje abay
I tried to integrate IBATIS-2.3.4 with OSGI framework. But the performance of my application becomes so slow when it loads the ibatis configuration file. It is taking significant time to load and parse the configuration file (almost 4 minutes). After it loads the configuration, it is also taking ti

Re: Laziness, downcasting and associations

2008-12-01 Thread Kai Grabfelder
@Carlos: yes I'm pretty much using a dedicated set of statement per usecase. Of course I'm reusing as much as I can, e.g. using the generic ibator generated example classes and my result mappings. But Rick summarized my points to a pretty good extend I think. @Rick: thanks to your post I don't n

Re: Laziness, downcasting and associations

2008-12-01 Thread Rick
I also noticed that you mentioned a "web application." As a web app, I doubt you really need 'lazy loading' and my guess is you'd be just fine without it. On Mon, Dec 1, 2008 at 4:42 PM, Rick <[EMAIL PROTECTED]> wrote: > I haven't read the entire post, but when I saw all your comments on "lazy,"

Re: Laziness, downcasting and associations

2008-12-01 Thread Rick
I haven't read the entire post, but when I saw all your comments on "lazy," I started to wonder what you are needing it for. I'm not an expert in iBATIS by any stretch but I typically find I don't need the lazy features and I have some pretty complex relationships. (Side note, I'm also coverting

Re: Define Hashmap

2008-12-01 Thread Rick
2008/12/1 John Chien <[EMAIL PROTECTED]> > Dear sir: > > This is my first time of using HashMap. > I defined the following structure and statement. > > Are they correct ? > What is the key for the HashMap ? > > > > > > resultMap="facilityIdBEAN"> >SELECT LPAD(COUNTY_ID, 3,

Define Hashmap

2008-12-01 Thread John Chien
Dear sir: This is my first time of using HashMap. I defined the following structure and statement. Are they correct ? What is the key for the HashMap ? resultMap="facilityIdBEAN"> SELECT LPAD(COUNTY_ID, 3,'0') || LPAD(FAC_TYPE, 2,'0') || LPAD(FAC_ID_NUMBER, 4,'0') as facility_id,

Re: Laziness, downcasting and associations

2008-12-01 Thread Carlos Pita
> > I have to admit that I never used the lazy features of iBATIS. Lazyness by > Default was one of the reasons why > I moved over from hibernate to iBATIS. And I know a bunch of other devs > that are not and will not use lazy > loading. Imho it does not make sense for web applications or restful >

Re: Laziness, downcasting and associations

2008-12-01 Thread Kai Grabfelder
Hi, I have to admit that I never used the lazy features of iBATIS. Lazyness by Default was one of the reasons why I moved over from hibernate to iBATIS. And I know a bunch of other devs that are not and will not use lazy loading. Imho it does not make sense for web applications or restful servic

Laziness, downcasting and associations

2008-12-01 Thread Carlos Pita
Hi, I'm evaluating the possibility to migrate a web application that is already in production from hibernate to ibatis. As a part of this I'm implementing skeletal versions of our most complex mappings, as a proof of concept. The application contains some overlapping hierarchies rooted at interfac