You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-cs@ibatis.apache.org by "vinay.a" <vi...@yahoo.com> on 2009/11/05 10:05:05 UTC
Re: batch inserts
The link for 'SqlCommandSet.cs' has changed. See below:
http://rhino-tools.svn.sourceforge.net/viewvc/rhino-tools/trunk/commons/Rhino.Commons/ToPublic/SqlCommandSet.cs
Ron Grabowski wrote:
>
> Have you seen this?
>
> https://rhino-tools.svn.sourceforge.net/svnroot/rhino-tools/trunk/rhino-commons/Rhino.Commons/ToPublic/SqlCommandSet.cs
>
>
> ----- Original Message ----
> From: Gilles Bayon <ib...@gmail.com>
> To: user-cs@ibatis.apache.org
> Sent: Monday, June 30, 2008 3:43:57 PM
> Subject: Re: batch inserts
>
> In ADO.NET there is no simple way to do batch statement in a db provider
> independent manner as in JBDC.
>
> For now, I haven't think of a good solution to implement batch support in
> iBATIS.NET.
> Perhaps other people have some ideas ?
>
> If you use SQL Server you do that with a store procedure and an XML in
> parameter.
>
> --
> Cheers,
> Gilles
>
>
--
View this message in context: http://old.nabble.com/batch-inserts-tp18124219p26208634.html
Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-cs-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-cs-help@ibatis.apache.org
Re: batch inserts
Posted by panji aryaputra <pa...@gmail.com>.
Hi all, can we use sql fragments as some sort of function? Is there a way to
pass "parameters" to an sql fragment. My need is something like this (within
one sql):
fragment1(parameter1)
union
fragment1(parameter2)
Or probably there is another way to achieve the same thing in ibatis? My
intention is to simplify the application codes while at the same time I do
not want to create functions in the DBMS. Hope I made my self clear.
TIA,
Panji
On Thu, Nov 5, 2009 at 9:23 PM, Michael McCurrey <mm...@gmail.com>wrote:
> The exposed SqlCommandSet would definitely be a nice to have. However, I
> do see a problem with the license and being able to just drop it in the
> source for iBatis as its currently licensed. It could be wrapped as a
> third-party dll and reference that was as we currently do with the Castle
> dll's. But that would bring the number of DLL's up to 5
> DataMapper,Common,Castle.Core,Castle.DynamicProxy2,Rhino.Commons.Clr
>
> thoughts?
>
>
> On Thu, Nov 5, 2009 at 2:05 AM, vinay.a <vi...@yahoo.com> wrote:
>
>>
>> The link for 'SqlCommandSet.cs' has changed. See below:
>>
>>
>> http://rhino-tools.svn.sourceforge.net/viewvc/rhino-tools/trunk/commons/Rhino.Commons/ToPublic/SqlCommandSet.cs
>>
>>
>> Ron Grabowski wrote:
>> >
>> > Have you seen this?
>> >
>> >
>> https://rhino-tools.svn.sourceforge.net/svnroot/rhino-tools/trunk/rhino-commons/Rhino.Commons/ToPublic/SqlCommandSet.cs
>> >
>> >
>> > ----- Original Message ----
>> > From: Gilles Bayon <ib...@gmail.com>
>> > To: user-cs@ibatis.apache.org
>> > Sent: Monday, June 30, 2008 3:43:57 PM
>> > Subject: Re: batch inserts
>> >
>> > In ADO.NET there is no simple way to do batch statement in a db
>> provider
>> > independent manner as in JBDC.
>> >
>> > For now, I haven't think of a good solution to implement batch support
>> in
>> > iBATIS.NET.
>> > Perhaps other people have some ideas ?
>> >
>> > If you use SQL Server you do that with a store procedure and an XML in
>> > parameter.
>> >
>> > --
>> > Cheers,
>> > Gilles
>> >
>> >
>>
>> --
>> View this message in context:
>> http://old.nabble.com/batch-inserts-tp18124219p26208634.html
>> Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-cs-unsubscribe@ibatis.apache.org
>> For additional commands, e-mail: user-cs-help@ibatis.apache.org
>>
>>
>
>
> --
> Michael J. McCurrey
> Read with me at http://www.mccurrey.com
> http://chaoticmindramblings.blogspot.com/
>
Re: batch inserts
Posted by Michael McCurrey <mm...@gmail.com>.
The exposed SqlCommandSet would definitely be a nice to have. However, I do
see a problem with the license and being able to just drop it in the source
for iBatis as its currently licensed. It could be wrapped as a third-party
dll and reference that was as we currently do with the Castle dll's. But
that would bring the number of DLL's up to 5
DataMapper,Common,Castle.Core,Castle.DynamicProxy2,Rhino.Commons.Clr
thoughts?
On Thu, Nov 5, 2009 at 2:05 AM, vinay.a <vi...@yahoo.com> wrote:
>
> The link for 'SqlCommandSet.cs' has changed. See below:
>
>
> http://rhino-tools.svn.sourceforge.net/viewvc/rhino-tools/trunk/commons/Rhino.Commons/ToPublic/SqlCommandSet.cs
>
>
> Ron Grabowski wrote:
> >
> > Have you seen this?
> >
> >
> https://rhino-tools.svn.sourceforge.net/svnroot/rhino-tools/trunk/rhino-commons/Rhino.Commons/ToPublic/SqlCommandSet.cs
> >
> >
> > ----- Original Message ----
> > From: Gilles Bayon <ib...@gmail.com>
> > To: user-cs@ibatis.apache.org
> > Sent: Monday, June 30, 2008 3:43:57 PM
> > Subject: Re: batch inserts
> >
> > In ADO.NET there is no simple way to do batch statement in a db provider
> > independent manner as in JBDC.
> >
> > For now, I haven't think of a good solution to implement batch support
> in
> > iBATIS.NET.
> > Perhaps other people have some ideas ?
> >
> > If you use SQL Server you do that with a store procedure and an XML in
> > parameter.
> >
> > --
> > Cheers,
> > Gilles
> >
> >
>
> --
> View this message in context:
> http://old.nabble.com/batch-inserts-tp18124219p26208634.html
> Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-cs-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-cs-help@ibatis.apache.org
>
>
--
Michael J. McCurrey
Read with me at http://www.mccurrey.com
http://chaoticmindramblings.blogspot.com/