Execute sqlldr command from java code.

[Ritu Kapoor]

Hi,

I am not able to transfer the data from txt to oracle table using sqlldr. If I execute the same command from cmd, it executes fine but does not work if I execute from java code.

Please find the code below

  
		try {
			String[] cmd = new String[5];
			Runtime rt = Runtime.getRuntime();
			String osName = System.getProperty("os.name");
			System.out.println("Operating System: " + osName);
			
			String sqlLoaderCommand = data.getProperty("command");
			//sqlLoaderCommand=sqlLoaderCommand+"  control="+controlFilePath;
			System.out.println("sqlLoaderCommand " + sqlLoaderCommand);

			if (osName.equals("Windows XP")) {
				cmd[0] = "cmd.exe";
				cmd[1] = "/C";
				cmd[2] = "set ORACLE_HOME = d:\\oracle\\ora92";
				cmd[3] = "set PATH=d:\\oracle\\ora92\\bin";
				cmd[4] = "sqlldr abc@dev\\x10 control='D:\\loader.ctl'";
			}
			
			System.out.println("Before executing rt.");
			Process proc = rt.exec(cmd);

			// any error?
			int exitVal;
			exitVal = proc.waitFor();
			System.out.println("ExitValue: " + exitVal);
			
			if (exitVal != 0) 
			{
			System.out.println("The command line job did not execute successfully");
			}
			else
			{
			System.out.println("The command line job executed successfully."+exitVal); 
			}
			
			
		} catch (InterruptedException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			
			
		}

 
loader.ctl
-----------------------
load data 
infile 'datafile.csv' into table emp 
fields terminated by "," optionally enclosed by '"'		   
( empno, empname, sal, deptno )
 

Please help to resolve it.

[William Brogden]

Process proc = rt.exec(cmd);

Executes one command line. You appear to have multiple commands you want to run. In that case, I would write a .bat file containing all of those commands and exec() the batch file.

You must also provide for consuming the stdOut and stdErr streams created by the process - see the Process JavaDocs.

Bill