File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC 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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
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
Similar Threads
Choice of Implementation
enable jsf logging
Is there another option for Spring AOP Annotations?
syncronizing sql*loader with java
J22E definition