Results 1 to 6 of 6
  1. #1
    chinna is offline Member
    Join Date
    Jul 2011
    Posts
    14
    Rep Power
    0

    Default SQL Loader not working

    Dear Gurus,

    I've tried to use sql loader to load data to to my DB but an error was occurred.
    My Java Code
    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
    Java Code:
    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.

  2. #2
    chinna is offline Member
    Join Date
    Jul 2011
    Posts
    14
    Rep Power
    0

    Default

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

  3. #3
    chinna is offline Member
    Join Date
    Jul 2011
    Posts
    14
    Rep Power
    0

    Default

    Please help. Still haven't fix. Thanks.

  4. #4
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,997
    Rep Power
    19

    Default

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

  5. #5
    chinna is offline Member
    Join Date
    Jul 2011
    Posts
    14
    Rep Power
    0

    Default

    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.

  6. #6
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,997
    Rep Power
    19

    Default

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

Similar Threads

  1. java.system.class.loader Not Working
    By kg1 in forum Advanced Java
    Replies: 2
    Last Post: 12-06-2010, 09:41 PM
  2. class loader problems!
    By alacn in forum New To Java
    Replies: 6
    Last Post: 08-11-2010, 10:51 PM
  3. Class loader
    By JavaJunkie in forum New To Java
    Replies: 1
    Last Post: 05-06-2009, 01:17 PM
  4. Smart Cache Loader 0.31
    By JavaBean in forum Java Software
    Replies: 0
    Last Post: 08-11-2007, 10:45 PM
  5. Smart Cache Loader 0.29
    By levent in forum Java Software
    Replies: 0
    Last Post: 07-26-2007, 08:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •