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: java

nested iteration

I have a statement like this: select NVL(attr_display_value, attr_value) AS LABEL, attr_value as VALUE FROM $idList[].partition$ t WHERE z

building query using values from 2 lists

Hi   I 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_nam