Re: 1:N:M

2007-07-05 Thread Nils Winkler
On Wed, 4 Jul 2007 19:03:21 -0600, Clinton Begin [EMAIL PROTECTED] said: Yes, you should be able to map any depth or breadth. Simply use two joins, two groups and two result map chains. Cheers, Clinton But that means that the size of the result set will increase with each additional

RE: IBATIS map and Cache

2007-07-05 Thread Gabriel Macerot
I try to do the same thing, queries cached by value and in fact the cache do something (I tried without and it was worth). I have another question: the cache store response data from a query … Then, if hundred users call this query, the first call store the data in the cache and the 99 others

Re: I18N best practices with iBatis

2007-07-05 Thread Larry Meadors
Is this a web app or a desktop app? Larry On 7/4/07, Collin Peters [EMAIL PROTECTED] wrote: On 6/29/07, Larry Meadors [EMAIL PROTECTED] wrote: So you have a field for each locale? Yes, a column for each locale in the i18n table I'd think it would be easier to if that were a compound key

Re: Inner select statements in resultMaps

2007-07-05 Thread Lisa Jenkins
Hi paul, Why not just hard code it in the query ? *select ORD_ID, ORD_CST_ID* *from PAYMENT* *where/ PAY_ORD_ID/ = #itemId#* *and/ PAY_CST_TYPE/ = **/'BIG_SPENDER'/* MCCORMICK, Paul wrote: Dear List, I'm using lazy loading for inner select statements in results maps.

Re: I18N best practices with iBatis

2007-07-05 Thread Larry Meadors
OK, so here's what I'd do. Initialize one sqlmapclient instance per locale, pass in the locale as a property when you initialize it, and use the property notation ${locale} in your sql maps to substitute the value when the sql map is created. Create a ThreadLocalSqlMapFactory: === public class

Re: Which to choose : iBatis or Hibernate

2007-07-05 Thread Henry Lu
iBatis is the way to go. -Henry Ashok Madhavan wrote: Hi All, we are presently using iBatis in one of our project. In that project there are lots of objects which need the CRUD and some CRUD + something more. we really like the namespace feature in iBatis and use to the max here. We use

Re: New [EMAIL PROTECTED]

2007-07-05 Thread Nathan Maves
If you dont mind once the site/app is done, could use them on the Powered By page? Nathan On 7/5/07, Clinton Begin [EMAIL PROTECTED] wrote: Cool! Thanks for letting us know. Cheers, Clinton On 7/4/07, VRL Swamy Vadali [EMAIL PROTECTED] wrote: Friends, I am responsible for building

Re: 1:N:M

2007-07-05 Thread Larry Meadors
No, that is a different issue - like if a person has multiple cats and dogs and you want person.dogList and person.catList populated. What you are doing should work. Have you tried simplifying it to just one child list? Larry On 7/5/07, Collin Peters [EMAIL PROTECTED] wrote: I think this is

Re: 1:N:M

2007-07-05 Thread Collin Peters
one child list does work (but that is just regular N+1). This ticket also looks like it could be the culprit: https://issues.apache.org/jira/browse/IBATIS-406 As a summary of what I am doing: The data structure is for a fitness program and looks like this. A Program object has multiple(List)

Re: Which to choose : iBatis or Hibernate

2007-07-05 Thread Jiming Liu
Using Hibernate, you have a high learning curve, so I think iBatis is OK. On 7/6/07, Henry Lu [EMAIL PROTECTED] wrote: iBatis is the way to go. -Henry Ashok Madhavan wrote: Hi All, we are presently using iBatis in one of our project. In that project there are lots of objects which need

Re: 1:N:M

2007-07-05 Thread Zoran Avtarovski
Hi Colin, I know I've done a three level m2m relationship model using Ibatis, I just can't find the code at the moment. But simply we had a company domain object which contained multiple workplace objects which contained multiple locations. I don't remember there being any issues, but I'll keep

Re: Which to choose : iBatis or Hibernate

2007-07-05 Thread Zoran Avtarovski
This being an iBatis list I dare say you will get overwhelming support for it (which I agree with). There are a lots of independent comparisons out there. Try googling ibatis v. Hibernate. You will see that each has its advantages and disadvantages with relation to the type of project you are