This week's book giveaway is in the OCMJEA forum. We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line! See this thread for details.
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).