ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nathan Maves" <nathan.ma...@gmail.com>
Subject Re: How to insert a entire table read from access to oracle using ibatis?
Date Mon, 11 Dec 2006 15:27:42 GMT
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