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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 -
> >
>
