Return-Path: 
 <user-java-return-5164-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 45433 invoked from network); 1 Dec 2005 13:17:07 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 1 Dec 2005 13:17:07 -0000
Received: (qmail 41927 invoked by uid 500); 1 Dec 2005 13:17:05 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 41908 invoked by uid 500); 1 Dec 2005 13:17:05 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 41897 invoked by uid 99); 1 Dec 2005 13:17:05 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Dec 2005 05:17:05 -0800
X-ASF-Spam-Status: No, hits=0.3 required=10.0
	tests=MAILTO_TO_SPAM_ADDR,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of larry.meadors@gmail.com
 designates 64.233.162.193 as permitted sender)
Received: from [64.233.162.193] (HELO zproxy.gmail.com) (64.233.162.193)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Dec 2005 05:18:32 -0800
Received: by zproxy.gmail.com with SMTP id l8so248354nzf
        for <user-java@ibatis.apache.org>;
 Thu, 01 Dec 2005 05:16:41 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=UTPmptNIialfC8yOa/vCGF7rH+lh5QQTAxNRa/fFRkVNToPCtiPWjHfWlY/oAbVq8amYlzMLXOycYhacKzzH6Y2voDOA7IbOxx6xhIZawPEzq/t5RR73s8XYkUPvfc+j6PRd5e2Kpu8h2l8uyOpcBdlaznFdFAZI/dwKbHzeY8g=
Received: by 10.36.221.17 with SMTP id t17mr1432575nzg;
        Thu, 01 Dec 2005 05:16:41 -0800 (PST)
Received: by 10.36.120.8 with HTTP; Thu, 1 Dec 2005 05:16:41 -0800 (PST)
Message-ID: <a10a823c0512010516j15a4c283ie6a0d5cd916e6ab1@mail.gmail.com>
Date: Thu, 1 Dec 2005 06:16:41 -0700
From: Larry Meadors <lmeadors@apache.org>
Reply-To: lmeadors@apache.org
Sender: larry.meadors@gmail.com
To: user-java@ibatis.apache.org
Subject: Re: Reg queryForList (returns back a list of empty objects)
In-Reply-To: <b60cb06c0512010256g5241db5ve98a41d74add4b50@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <b60cb06c0512010256g5241db5ve98a41d74add4b50@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Try this:

<select id=3D"getDataList" resultClass=3D"java.util.HashMap" remapResults=
=3D"true">

Larry



On 12/1/05, Sathish S <flex2004@gmail.com> wrote:
> Hi All,
>      I wanted to query an unknown table at the runtime ie the user will
> select a table from the list of tables (These tables are created dynamica=
lly
> at the runtime and I am not sure about the table definition) and would li=
ke
> to see the records. I am using the method queryForList("statementName",
> tableNameParameter). But the list that this method returns back is a list=
 of
> empty objects (even though the size of the list is equal to the number of
> records available in the table). Though queryForMap returns me the data, =
I
> cannot use queryForMap because I am not sure about the columnName that ca=
n
> be used for keyParameter (I might not get all the records if that columnN=
ame
> has duplicate values as the records might get overwritten in the Map). I
> have attached my sample code and output in this mail.
>      Can anyone tell me what's wrong in my code or any workaround? I am
> using iBatis version 2.1.5 GA.
>
>  SQLMap:
>  --------------
>  <?xml version=3D"1.0" encoding=3D"UTF-8" standalone=3D"no"?>
>  <!DOCTYPE sqlMap
>      PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
>      "http://ibatis.apache.org/dtd/sql-map-2.dtd">
>
>  <sqlMap namespace=3D"MultiSiteDataCompare">
>
>    <select id=3D"getDataList" resultClass=3D"java.util.List"
> parameterClass=3D"string">
>      Select * from $value$
>    </select>
>  </sqlMap>
>
>
> Code:
>  ---------
>      public List fetchData(String tableName) throws SomeCustomException
>      {
>          logger.debug("Before Execution");
>          List list =3D queryForList("getDataList", tableName);
>          logger.debug("After Execution");
>          logger.debug("Result -> " + list.toString());
>          return list;
>      }
>
>
>  O/P:
>  -------
>  2005-12-01 16:12:29,714 DEBUG
> [com.aspect.eds.dao.datamap.DataCompareSqlMapDao] - Before
> Execution (DataCompareSqlMapDao.java:fetchData:38)
>  2005-12-01 16:12:29,792 DEBUG
> [com.ibatis.common.jdbc.SimpleDataSource] - Created
> connection 2868213. (Log4jImpl.java:debug:22)
>  2005-12-01 16:12:29,792 DEBUG [java.sql.Connection] - {conn-100005}
> Connection (Log4jImpl.java:debug:22)
>  2005-12-01 16:12:29,792 DEBUG [java.sql.PreparedStatement] - {pstm-10000=
6}
> PreparedStatement:      Select * from resource..Server
> (Log4jImpl.java:debug:22)
>  2005-12-01 16:12:29,792 DEBUG [java.sql.PreparedStatement] - {pstm-10000=
6}
> Parameters: [] (Log4jImpl.java:debug:22)
>  2005-12-01 16:12:29,792 DEBUG [java.sql.PreparedStatement] - {pstm-10000=
6}
> Types: [] (Log4jImpl.java:debug:22)
>  2005-12-01 16:12:29,807 DEBUG [java.sql.ResultSet] - {rset-100007}
> ResultSet (Log4jImpl.java:debug:22)
>  2005-12-01 16:12:29,807 DEBUG
> [com.aspect.eds.dao.datamap.DataCompareSqlMapDao] - After
> Execution (DataCompareSqlMapDao.java:fetchData:40)
>  2005-12-01 16:12:29,807 DEBUG
> [com.aspect.eds.dao.datamap.DataCompareSqlMapDao] - Result
> -> [[], [], [], [], [], [], [], []]
> (DataCompareSqlMapDao.java:fetchData:41)
>  2005-12-01 16:12:29,839 DEBUG
> [com.ibatis.common.jdbc.SimpleDataSource] - Returned
> connection 2868213 to pool. (Log4jImpl.java:debug:22)
>
>
>
> --
> Thanks,
> Sathish S