The xml and java code are following :

(The object "RequestTemplateData" has the appropriate getters and setters, i don;t think it needs to be listed)

The SqlMap piece:
__________________________________

<sqlMap namespace="TemplatesList">
<select id="getTemplatesList" resultClass="gr.forthnet.staff.objects.RequestTemplateData">

<![CDATA[
select
RequestTemplateDataId as REQUESTTEMPLATEDATAID,
RequestTemplateId as REQUESTTEMPLATEID,
KeyId as KEYID,
Required as REQUIRED,
DefValue as DEFVALUE
from RequestTemplateData
]]>

</select>

__________________________________

The Java piece is here :

////////////////////////////////////////////////////////////////////////////////
//            iBATIS SQL MAPS TEST AREA        //
            try {
            String resource = "ibatis/SqlMapConfig.xml";
            //String resource = "file:///C:/workspace/Praxis2k/WEB-INF/src/ibatis/SqlMapConfig.xml";
            Reader reader = Resources.getResourceAsReader(resource);

            SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);

            sqlMap.startTransaction();
            List<RequestTemplateData> TList= sqlMap.queryForList("getTemplatesList", null);
           
            sqlMap.commitTransaction();
       
            for (RequestTemplateData rtd : TList){
                System.out.print(rtd.getREQUESTTEMPLATEDATAID() + " ~ ");
                System.out.print(rtd.getREQUESTTEMPLATEID() + " ~ ");
                System.out.print(rtd.getKEYID() + " ~ ");
                System.out.print(rtd.getREQUIRED() + " ~ ");
                System.out.println(rtd.getDEFVALUE() + " \n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ");
            }
           
///////////////////////////////////////////////////////////////////////////////////////////////////////

The result output in my console is  (the last row of the table RequestTemplateData) :

10 ~ 2 ~ 8 ~ 1 ~ null
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
10 ~ 2 ~ 8 ~ 1 ~ null
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
10 ~ 2 ~ 8 ~ 1 ~ null
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
10 ~ 2 ~ 8 ~ 1 ~ null
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
10 ~ 2 ~ 8 ~ 1 ~ null
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
10 ~ 2 ~ 8 ~ 1 ~ null
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
10 ~ 2 ~ 8 ~ 1 ~ null
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
10 ~ 2 ~ 8 ~ 1 ~ null
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
10 ~ 2 ~ 8 ~ 1 ~ null
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
10 ~ 2 ~ 8 ~ 1 ~ null
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

while it should be (the outcome I get with pure JDBC):

1 ~ 1 ~ 1 ~ 0 ~ null
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2 ~ 1 ~ 2 ~ 1 ~ null
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3 ~ 1 ~ 3 ~ 1 ~ null
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
4 ~ 1 ~ 7 ~ 1 ~ null
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
5 ~ 1 ~ 8 ~ 1 ~ null
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
6 ~ 2 ~ 1 ~ 0 ~ null
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
7 ~ 2 ~ 2 ~ 1 ~ null
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
8 ~ 2 ~ 3 ~ 1 ~ null
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
9 ~ 2 ~ 7 ~ 1 ~ null
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
10 ~ 2 ~ 8 ~ 1 ~ null
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~