Group By for one Parent and many Child types.

2007-04-05 Thread Baskar Viswanathan
I m new to Ibatis. I m having trouble with building a map with Ibatis using group by. If the relation is like GrandParent Parent Child It works fine..Since I group by GrandParent and Parent. If the relation is like.. Parent Child list1(a1, a2) Child

Re: Mapping reuslt to to java.util.Map with dynamic key(from column), possible?

2007-04-05 Thread Mikael Andersson
Hi Pretty cool feature which I didn't know about :), thanks for the tip. Could you give an example how the queryForMap feature can be used with a nested resultMap, googled a bit and only found how to use it to populate a Map instead of a List as the result of calling a select from the DAO. Than

insert sql and function calls.

2007-04-05 Thread gumnaam
Hello All, I have just started using iBatis, and I have a question about insert statements. I see, that there is a selectKey for auto generated columns. My situation is I have table that has primary key which is auto generated using a sequence. I use the selectKey for this column. But there is ano

RE: Mapping reuslt to to java.util.Map with dynamic key(from column), possible?

2007-04-05 Thread Daniel Pitts
I think its called queryForMap :-) From: Mikael Andersson [mailto:[EMAIL PROTECTED] Sent: Thursday, April 05, 2007 6:28 AM To: user-java@ibatis.apache.org Subject: Mapping reuslt to to java.util.Map with dynamic key(from column),

Re: Tutorial questions

2007-04-05 Thread [EMAIL PROTECTED]
Thank you very much.. it is working. :) Ohsuria On Wednesday 04 April 2007 22:47, James, Steven wrote: > Well you need to cast the returned from the list to an appropriate type. > Therefore in your for loop do the cast like so > > out.println("Selected " + list.size() + " records."); > for (int i

Mapping reuslt to to java.util.Map with dynamic key(from column), possible?

2007-04-05 Thread Mikael Andersson
Hi I wonder if it is possible to populate a Map via a resultMap so that the key is the value from a column and the value the value of another column? I read how about to create a Map with pre specified key values in the PDF documentation, but I couldn't find how to use dynamic key value. public

RE: Moving sqlmap files to /WEB-INF/sqlmaps/ instead of in the classpath

2007-04-05 Thread Murtaza Goga
The sql map configuration is supports urls as well You could also initialize com.ibatis.common.resources.Resources with a custom implementation of a ClassLoader which does the external lookup. -Original Message- From: Jared Blitzstein [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04