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.
posted 10 years ago
SQLLDR will in general be faster than anything you can write in Java.