SQL Loader not working

[chinna]

Dear Gurus,

I've tried to use sql loader to load data to to my DB but an error was occurred.
My Java Code

public class TestLoader {

    public static void main(String[] args) {
        Runtime Rt;
        Process Prc;
        String cmd = "";
        cmd = "SQLLDR sa/password@pcms_tm_test control=C://Java/testloader.ctl";
        Rt = Runtime.getRuntime();
        try {
            Prc = Rt.exec(cmd);
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
}

My Control File

LOAD DATA
INFILE '/C:/Java/'
INTO TABLE cust_info_test_loader
FIELDS TERMINATED BY '|'
(
Cust_Acct_no, Cust_Acc_Name,Service_No
)

Hope some can help me. Thanks.

[chinna]

Error : java.io.IOException: Cannot run program "SQLLDR": CreateProcess error=2, The system cannot find the file specified

[chinna]

Please help. Still haven't fix. Thanks.

[Tolls]

Does that command work directly from the command line when you copy and paste it?

[chinna]

Hi Tolls,
The issue have fixed actually. Im using mssql server 2005 and sql loader only supported in Oracle. I've use BULK INSERT instead of sql loader.
Currently im searching how to do column mapping using bulk insert.
Thanks a lot Tolls.

[Tolls]

It's not about it being supported only in Oracle.
It's an Oracle tool...