Re: 1:N:M

2007-07-04 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 additi

Re: 1:N:M

2007-07-04 Thread Clinton Begin
Yes, you should be able to map any depth or breadth. Simply use two joins, two groups and two result map chains. Cheers, Clinton On 7/4/07, Collin Peters <[EMAIL PROTECTED]> wrote: Does iBatis have support to map out queries that are more than just 1:N? For example, imagine in the tutorial

1:N:M

2007-07-04 Thread Collin Peters
Does iBatis have support to map out queries that are more than just 1:N? For example, imagine in the tutorial that a category not only has products as children, but also has some tags as children. So in the developer guide on page 37 the section called "1:N & M:N Solution", if that SQL had anoth

Re: I18N best practices with iBatis

2007-07-04 Thread Collin Peters
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 instead: SELECT a.activity_id, i.name as name FROM activities a JOIN i18n i ON (a.name_i18n_

RE: transaction rollback

2007-07-04 Thread Poitras Christian
Can you send the SqlMap class doing the inserts in a while loop (matching bean positionManager I guess) and the sqlmap config xml file.? Christian From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, 04 July 2007 10:24 To: user-java@ibatis.apach

RE: transaction rollback

2007-07-04 Thread bharathi.mani
I find that each operation on the object gets committed as and when it is executed. For example, I have defined a method insert in service layer. I have made the service class transactional. When I invoke the insert method on the object in a while loop, for each iteration, the statement is getting

RE: transaction rollback

2007-07-04 Thread Poitras Christian
Spring calls rollback only when a RuntimeException is encountered. Normal exceptions cause commits (unless stated otherwise in @Transactional tag). This may be the cause of your problem. If this is not the case, what database are you using? And can you send your spring

New [EMAIL PROTECTED]

2007-07-04 Thread VRL Swamy Vadali
Friends, I am responsible for building a scalable and high performance data access layer for our keyword search application, which is of distributed nature, and have convinced the team for IBATIS. We did some pilot and comparative studies for our requirements IBATIS is winner among pure JDBC, I

RE: IBATIS map and Cache

2007-07-04 Thread Gabriel Macerot
Thanks for your answers. I will try what you’ve just said and check the logging (I wonder why I didn’t do that yet ….) Mohicane _ De : Meindert [mailto:[EMAIL PROTECTED] Envoyé : mercredi 4 juillet 2007 11:22 À : user-java@ibatis.apache.org Objet : RE: IBATIS map and Cache Ma

RE: IBATIS map and Cache

2007-07-04 Thread Meindert
Maybe try adding readOnly="false" serialize="true" to the cacheModel I had huge issues trying to use queries cached by value (meaning your use of ‘WHERE id=#value#’ ) it did not work for me. It didn’t return the right object out of the read-only cache. Or it didn’t find the object in the cache

RE: IBATIS map and Cache

2007-07-04 Thread Gabriel Macerot
Yes, I did. _ De : Niels Beekman [mailto:[EMAIL PROTECTED] Envoyé : mercredi 4 juillet 2007 10:19 À : user-java@ibatis.apache.org Objet : RE: IBATIS map and Cache Did you enable the cache globally in your SqlMap config? _ From: Gabriel Macerot [mailto:[EMAIL PRO

RE: IBATIS map and Cache

2007-07-04 Thread Niels Beekman
Did you enable the cache globally in your SqlMap config? From: Gabriel Macerot [mailto:[EMAIL PROTECTED] Sent: woensdag 4 juli 2007 10:17 To: user-java@ibatis.apache.org Subject: IBATIS map and Cache I build a web application. Then I store data in a mys

IBATIS map and Cache

2007-07-04 Thread Gabriel Macerot
I build a web application. Then I store data in a mysql data base and I use ibatis in order to map the requests for my application. For optimization I use LRU cache with the mapping about game_object_template (these objects may not change a lot). Here is my code :