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:[EMAIL PROTECTED] Sent: Wednesday, June 14, 2006 9:43 AM To: [email protected] Subject: Re: raw dataport Joe, Care to elaborate how this will work with a source database that is not MySQL? Andrus
