Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 76103 invoked from network); 11 Dec 2006 15:28:08 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 11 Dec 2006 15:28:08 -0000 Received: (qmail 24839 invoked by uid 500); 11 Dec 2006 15:28:14 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 24820 invoked by uid 500); 11 Dec 2006 15:28:13 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 24804 invoked by uid 99); 11 Dec 2006 15:28:13 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 11 Dec 2006 07:28:13 -0800 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of nathan.maves@gmail.com designates 64.233.166.182 as permitted sender) Received: from [64.233.166.182] (HELO py-out-1112.google.com) (64.233.166.182) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 11 Dec 2006 07:28:03 -0800 Received: by py-out-1112.google.com with SMTP id n39so880793pyh for ; Mon, 11 Dec 2006 07:27:42 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=DaiX8uvgdHNnm21L/uJFkc/pMH80vAXJmwKEDjbPNuI39aCi7eDnXwPqVmnO6RM3i9/XBoEFojaeAZTl0trmm7/2ZiIIF+WaXUD8SpEiboq0SxE7KFBgV9hTP5Iey0GDWL8kn9gceTU5npLid8MrWORzXISdBYJWHlGg90Kk4Vk= Received: by 10.35.27.2 with SMTP id e2mr7390011pyj.1165850862673; Mon, 11 Dec 2006 07:27:42 -0800 (PST) Received: by 10.35.26.2 with HTTP; Mon, 11 Dec 2006 07:27:42 -0800 (PST) Message-ID: <2f55db670612110727u2e55bf8p1a37558a38d8ef05@mail.gmail.com> Date: Mon, 11 Dec 2006 08:27:42 -0700 From: "Nathan Maves" To: user-java@ibatis.apache.org, lmeadors@apache.org Subject: Re: How to insert a entire table read from access to oracle using ibatis? In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_77735_17301314.1165850862553" References: <20061208054237.29137.qmail@web8411.mail.in.yahoo.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_77735_17301314.1165850862553 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 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 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 - > > > ------=_Part_77735_17301314.1165850862553 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 -
>

------=_Part_77735_17301314.1165850862553--