Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Invoking SQL Loader from java vs JDBC application

 
vishwanath nadimpally
Ranch Hand
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
SQLLDR will in general be faster than anything you can write in Java.

The manual is online, here:
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14215/part_ldr.htm
(free registration required, I think).
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic