Multiple database connections

Hi, I am currently using iBatis 2.1 and I am having trouble connecting to different dbs. In my DAOMap.xml, I created to connections to 2 different databases -- when I tested each of the queries in Junit, it works fine, however when I call via the DaoManager, it keeps throwing this error:

nested iteration

I have a statement like this: statement id="getAttributesFiltered" parameterClass="java.util.Map" resultMap="get_attributes_values" iterate property="idList" conjunction = "union" select NVL(attr_display_value, attr_value) AS LABEL, attr_value as VALUE FROM $idList[].partition$ t WHERE zeid

building query using values from 2 lists

HiI have two lists that I need to iterate in order in build my SQL statement. I would like to know how I would go about in doing that using iBatis.I have 2 list: partitionList=[01, 02]; IDList=[10001, 10002];Basically it should look like this: SELECT DISTINCT NVL(attr_display_name,