ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Clinton Begin" <clinton.be...@gmail.com>
Subject Re: How to insert a entire table read from access to oracle using ibatis?
Date Mon, 11 Dec 2006 16:41:16 GMT
But if you REALLY want to use iBATIS, you could use a RowHandler w/baching
(commit after every 1000 records or so).....

Using this approach I was inserting the NetFlix Prize data at 15,000 records
per second from a flat file to SQL Server.

Clinton


On 12/11/06, Nathan Maves <nathan.maves@gmail.com> wrote:
>
> I agree with Larry.  Leave ibatis out.
>
> I have done it two ways in the past.  The first is to export the table as
> a csv and then use Oracle's Sqlldr to load the values into the new table.
>
> The second is as Larry stated.
>
> select 'insert into TableA (col1,col2,col3) values
> ('||col1||','||col2||','||col3||')' from oldTable;
>
> You get the drift.
>
>
>
> On 12/8/06, Larry Meadors <lmeadors@apache.org> wrote:
> >
> > Hm, I wouldn't use iBATIS for this at all - Oracle has bulk data
> > loading tools that would do it WAY faster - if you can get the access
> > data ot to a file in the right format.
> >
> > Heck, even generating a SQL script with a bunch of insert statements
> > would be faster.
> >
> > Larry
> >
> >
> > On 12/8/06, Graeme J Sweeney <ibatis.user@gjsweeney.com> wrote:
> > > On Fri, 8 Dec 2006, puneet arya wrote:
> > >
> > > >  you can use directly JDBC ....to insert data from access to
> > database
> > > without using IBATIS
> > >
> > > For one table you're probably right.
> > >
> > > I use abator, if I have to do this type of a task.
> > >
> > > --
> > > Graeme -
> > >
> >
>
>

Mime
View raw message