Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: neutral (asf.osuosl.org: local policy)
Subject: RE: sql map via Java API
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Date: Fri, 23 Jun 2006 08:33:32 +0700
content-class: urn:content-classes:message
Message-ID: 
 <BBB07C847BBE5A49B3A849A8DE7E56CF012AB761@ekamailserver.ekalife2000.com>
Thread-Topic: sql map via Java API
Thread-Index: AcaWVG1VnvCMdkR0Qhizv9EH0EVKqQAED5og
From: "Yusuf" <Yusuf@ekalife.co.id>
To: <user-java@ibatis.apache.org>

just my opinion,
but what's the point of using iBatis if you wanted to build a statement
at runtime?=20
maybe you can just use simple jdbc?

yusuf

-----Original Message-----
From: Edwin Lukaweski [mailto:serjann@rogers.com]
Sent: Friday, June 23, 2006 3:28 AM
To: user-java@ibatis.apache.org
Subject: Re: sql map via Java API


Yes - good one!!!

    However, just to carry this a bit further, ideally, I would like to
have=20
iBatis prepare this once and then use the prepared statement.

    As I understand it, 'remapResults=3Dtrue' will force a lot of work =
due
to=20
examining the result set meta data. Also, I would imagine that the=20
$generatedSqlStatement$ will also be prepared on each call.

    I guess I could go straight to the JDBC driver but will that
interfere=20
with iBatis' operation?

Thanks,
Edwin

----- Original Message -----=20
From: "Larry Meadors" <lmeadors@apache.org>
To: <user-java@ibatis.apache.org>
Sent: Thursday, June 22, 2006 2:52 PM
Subject: Re: sql map via Java API


> Yeah, it's risky, but life is about risks, right? :-)
>
> <select id=3D"injectMeBaby"=20
> remapResults=3D"true">$generatedSqlStatement$</select>
>
> Larry
>
>
> On 6/22/06, Edwin Lukaweski <serjann@rogers.com> wrote:
>>
>>
>> Hi:
>>
>>     Is there any way of submitting a new <select>.....</select> SQL
Map
>> snippet via the Java API. Or, alternatively, is there a way of=20
>> contructing
>> an object, from iBatis, that accomplishes the same thing?
>>     What I am trying to do is build a SELECT statement at execution
time,
>> based on parameters entered, but after ibatis has been initialized. I

>> would
>> then like to load it into an SQL-MAP for a specific table (namespace
ID)=20
>> and
>> then use the standard interface calls.
>>
>> Thanks,
>> Edwin
>>
>=20