Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: domain of larry.meadors@gmail.com
 designates 66.249.82.197 as permitted sender)
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=Dx+EIacbylze4aZJNQRMAPMpmGm0nzQprZo3x1m7/lP/npbLUsgIS7xaKK2SxGQ4BuhLVSfGn6we0vWOdw/sJJdMRK/I4TFs0p6b0gaGXc81+R3nxozqS0UTJy6ywuMa9oGXlMUSrWABJVwEmo4pNX2gaU5Nh/aDMTZlYNaCkqM=
Message-ID: <a10a823c0601071212q6e72d7d5y3de62c4a16b4c4d2@mail.gmail.com>
Date: Sat, 7 Jan 2006 13:12:17 -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: Problems with displaying contents of table
In-Reply-To: <Pine.GSO.4.10.10601071451001.12369-100000@log3.in.utoronto.ca>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <43C015A8.5060500@aladin.ca>
	 <Pine.GSO.4.10.10601071451001.12369-100000@log3.in.utoronto.ca>

On 1/7/06, zarar.siddiqi@utoronto.ca <zarar.siddiqi@utoronto.ca> wrote:
>
> The first time you called "select", IBatis determined a way to process al=
l
> calls to the statement.  So the next time you call it, IBatis is trying t=
o
> process the query the same way it did earlier (which is understandable).
> But alas, the table has changed and whatever IBatis has stored in memory
> is no longer applicable.

Correct.

>
> One solution might be to re-initialize the SqlMapClient again the same wa=
y
> you did on application startup.  This should fix the problem but you will
> lose any caching that you might be doing or IBatis might have done.

There is an easier way! :-)

>
> IBatis' behavior is correct as it can't afford to analyze maps on
> every single call and does the work once.  Altering a table is a fairly
> large move, are you sure you can't avoid it?

It can - remapResults=3D"true" in the select tag will do just that.

Larry