sql loader and java

[lowbk]

i have a data file that i'm loading into oracle8 using java. but the data file can has so many as 1000 records and i don't think 1000 sql insert statement is efficient.

i am thinking of using sql loader, but don't know if it is possible to activate it within java. if so, can anyone advise on what settings are needed, eg jar files, driver, api etc?

thanks

 

[lmorgansky]

As far as I am aware, there is no API to interact with SQL*Loader. You will have to perform a system call to the OS and start the tool.

If you have not used SQL*Loader before, then you should be aware that it loads flat files to the database. You will have to create a SQL*Loader control file to describe your file layout and target table.

Lonnie