IBatis and decode parameter mapping in resultMap?

Since the Oracle decode() function is just a if-then-else statement in disguise, you'd map the result (GROUP_ASSIGNED) column to an object property just like you would map any other returned column. Assuming you are mapping to an object with a property named GroupAssigned: resultMap ....

Since the Oracle decode() function is just a if-then-else statement in disguise, you'd map the result (GROUP_ASSIGNED) column to an object property just like you would map any other returned column. Assuming you are mapping to an object with a property named GroupAssigned.

The following is my experience with Java version of IBatis (version 2.3.4). My scenario was I wanted Ibatis to return me a map of keys and values for a given list of parameters. Done using Ibatis queryForMap method to return a map where the key is an Object and the values are a collection of Objects (this example Key is a Wrapper while the values are a list of Wrapper Longs).

Create a placeholder (with the getters/setters) to hold the data when the query executes. My initial troubles was getting the alias' right and the groupBy syntax on the parent map. Having the groupBy will get Ibatis to get the same object for the elementId to populate the children.

One instance without the groupBy I found that for each key the previous child added to the list was replaced by the latest child as a new list was initialized (note I have not had a peep at the internals of Ibatis yet as I write this example). The placeholders alias must match the parent and child's resultMap. Ibatis 3 seems to have better syntax to define and handle a scenario as above.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions