This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Invoking SQL Loader from java vs JDBC application Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Invoking SQL Loader from java vs JDBC application" Watch "Invoking SQL Loader from java vs JDBC application" New topic

Invoking SQL Loader from java vs JDBC application

vishwanath nadimpally
Ranch Hand

Joined: Jan 25, 2005
Posts: 116
I have written a java applicaiton that uses JDBC to query a SQLServer database and writes tables to Oracle 10g. I know I can use SQLLoader to achieve the same thing, using control files and reading the result sets off a text file. Plus I am using log4j framework in the JDBC app to do all my logging stuff. With SQLLoader I dont have to worry about any of the logging stuff because that is taken care of by SQLLoader.

But the problem is I still have to use a java application just to invoke SQLLoader.That's how my requirements are.

I need suggestion as to whether I should still be using the JDBC app or should I think about calling SQLLoader from java to get the job done. If so, does SQLLoader take any parameters (ofcourse apart from the username/password and SID).

Thanks for any suggestions.
stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333
SQLLDR will in general be faster than anything you can write in Java.

The manual is online, here:
(free registration required, I think).
I agree. Here's the link:
subject: Invoking SQL Loader from java vs JDBC application
It's not a secret anymore!