ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Edwin Lukaweski" <serj...@rogers.com>
Subject Re: sql map via Java API
Date Mon, 26 Jun 2006 13:56:43 GMT
Hi:

    I do want to add that the reason I am still using iBatis is due to one 
of the basic goals.....it does 80% of the JDBC work for me.

    The one unique requirement, that I have outlined will not prevent me 
from using iBatis.

Thanks,
Edwin

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


> The advantages would be parameter mapping, resource management, and
> result mapping.
>
> The disadvantages are the increased potential for sql injection, a
> slight loss of performance, and potentially less concrete results (if
> you are putting them into a Map).
>
> Larry
>
>
> On 6/22/06, Yusuf <Yusuf@ekalife.co.id> wrote:
>> just my opinion,
>> but what's the point of using iBatis if you wanted to build a statement
>> at runtime?
>> 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
>> iBatis prepare this once and then use the prepared statement.
>>
>>     As I understand it, 'remapResults=true' will force a lot of work due
>> to
>> examining the result set meta data. Also, I would imagine that the
>> $generatedSqlStatement$ will also be prepared on each call.
>>
>>     I guess I could go straight to the JDBC driver but will that
>> interfere
>> with iBatis' operation?
>>
>> Thanks,
>> Edwin
>>
>> ----- Original Message -----
>> 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="injectMeBaby"
>> > remapResults="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
>> >> 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)
>> >> and
>> >> then use the standard interface calls.
>> >>
>> >> Thanks,
>> >> Edwin
>> >>
>> >
>>
>>
>>
> 



Mime
View raw message