Re: nested ArrayLists

2009-04-07 Thread Nathan Maves
You will have to do this programatically and it is a classic n+1 problem. I would suggest that you write a 3rd stored proc or query that returns the people + there address. Once that is done you can use the group by feature of ibatis to fill the nested properties. On Tue, Apr 7, 2009 at 4:10 PM,

Using Connection.commit() in place of SqlMapSession.commitTransaction(). "commitRequired" Benefit

2009-04-07 Thread I L
Hi guys, This is a two part question. 1) Is there a significant performance pickup if you use commitRequired="false". As you know this attribute is set to false by default. I couldn't find any information on the benefit of keeping that field false. 2) I would like to run an sql update query u

Re: Does Ibatis support recursive sql maps?

2009-04-07 Thread Eric T. Blue
Hi, I had to do something similar to this a few years ago. However, I chose to model that parent-child hierarchy (tree) in code rather than trying to solve via SQL and iBatis. In fact, this may be preferable from a performance standpoint if the number of entities you're trying to model are large

nested ArrayLists

2009-04-07 Thread bpamarti
Lets say Person is a bean public class Person implements Serializable { String firstName; String lastName; ArrayList addresses; ... getters and setters ... } Address is another bean public class Address implements Serializable { String city; String state; ... getters and sette

Does Ibatis support recursive sql maps?

2009-04-07 Thread stang
Hi there, I'm trying to use IBatis to model a parent-child relationship where i have some object that has a parent, and that parent has its own parent, and so on. Is this supported? I am having trouble making it work and I suspect that I may not be doing it right because my results are always n

Re: Can I use Set instead of List?

2009-04-07 Thread Nathan Maves
I took this one step further ArrayList list = new ArrayList(); list.add(1); list.add(1); list.add(2); list.add(3); HashSet set = new HashSet(); set.addAll(list); System.out.println(list.size()); System.out.println(set.size()); output: 4 3 So java will remove all duplicates that it finds. On

[SOLVED] Update Postgres Array with IBatis

2009-04-07 Thread beppes
It works Thank you so much!!! Giuseppe -- View this message in context: http://www.nabble.com/Update-Postgres-Array-with-IBatis-tp22924852p22930040.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Re: Can I use Set instead of List?

2009-04-07 Thread Brandon Goodin
Wrote this too and it worked: ArrayList list = new ArrayList(); list.add("a"); list.add("b"); list.add("c"); list.add("d"); list.add("e"); list.add("f"); HashSet set = new HashSet(list); System.out.println(set.size()); Bra

Re: Can I use Set instead of List?

2009-04-07 Thread Brandon Goodin
I took a few seconds and wrote this ArrayList list = new ArrayList(); list.add("a"); list.add("b"); list.add("c"); list.add("d"); list.add("e"); list.add("f"); HashSet set = new HashSet(); set.addAll(list); Syste

Re: Update Postgres Array with IBatis

2009-04-07 Thread Ingmar Lötzsch
Hello, > I need to update an array of integers in Postgres with Ibatis 2.3.4 (and > Spring). I want to execute the following query: > UPDATE data SET='{1,2}' WHERE dataid=10 I prefer the use of java.sql.Array and a custom TypeHandler. > The query is > > > UPDATE data > >

Re: Can I use Set instead of List?

2009-04-07 Thread Ingmar Lötzsch
> This is a fundamental java issue. You will never be able to cast a list > to a set because a list allows duplicates whereas a set dose not. The duplicates are not the reason. ArrayList is not a subtype of Set. And how does the query select * from Products produce duplicates? Lists accept dup

Update Postgres Array with IBatis

2009-04-07 Thread beppes
Hi to everybody. I'm new to this forum. I need to update an array of integers in Postgres with Ibatis 2.3.4 (and Spring). I want to execute the following query: UPDATE data SET='{1,2}' WHERE dataid=10 The query is UPDATE data #arrayD