Hi Andrus,
I have not tried this except in MySQL. Basically, all one does is write
out a file and then call the LOAD for that file in JDBC exactly as if
one were working in a typical DB client tool. I ran across this in the
RDF database front-end to MySQL 3Store (also sometimes called
ThreeStore). For Oracle, I could not see that one can call the Oracle
Bulk Loader command LOAD DATA from JDBC as one can in MySQL -- if you
can, then the approach would work in Oracle, too. Oracle does not have
the REMOTE option so the data being loaded has to be locally visible to
the database.
It has been a while since I used Oracle -- I could find nothing in the
available docs that indicates something like the LOAD DATA command is
available in Oracle's JDBC. This approach, while far faster than an
INSERT may not work in Oracle.
Joe
-----Original Message-----
From: Andrus Adamchik [mailto:andru..bjectstyle.org]
Sent: Wednesday, June 14, 2006 9:43 AM
To: cayenne-use..ncubator.apache.org
Subject: Re: raw dataport
Joe,
Care to elaborate how this will work with a source database that is not
MySQL?
Andrus
This archive was generated by hypermail 2.0.0 : Wed Jun 14 2006 - 16:25:57 EDT