aspose file tools*
The moose likes Oracle/OAS and the fly likes SQL Loader and Runtime.exec() Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "SQL Loader and Runtime.exec()" Watch "SQL Loader and Runtime.exec()" New topic
Author

SQL Loader and Runtime.exec()

John Dinglasan
Greenhorn

Joined: Oct 19, 2004
Posts: 5
Hi guys!

I'm having a problem with running sql loader using Runtime.exec.
Actually, the records are loaded but only up to 512 records.

There is no Exception and inside the log file geenrated by SQL loader it says that all records were successfully loaded.

I tried loading the same file manually using SQL Loader and there was no problem.

I'm using "Oracle 9i" and "Java 1.4.1".

Here is the String inside Runtime.exec:
sqlldr tmt_final/tmt_final@shogun control=C:\eclipse\workspace\TMT_Final\Archive_Files\20040825_raw.csv.gz.ctllog=
C:\eclipse\workspace\TMT_Final\Archive_Files\20040825_raw.csv.gz.log skip=2

And my control file
LOAD DATA
INFILE 'C:\eclipse\workspace\TMT_Final\Archive_Files\Historical_Raw_Data\20040825_raw.csv'
BADFILE 'C:\eclipse\workspace\TMT_Final\Archive_Files\20040825_raw.csv.gz.bad'
REPLACE
INTO TABLE ARCHIVE_HIST_RAW_VALUE
FIELDS TERMINATED BY ","
(
fk_measurement,
fk_hist_kind,
year,
month,
day,
hour,
minute,
raw_value,
raw_quality,
update_date "TO_TIMESTAMP(:update_date,'YYYY/MM/DD HH24:MI:SS')",
update_user,
date_time "TO_DATE( ate_time,'YYYY/MM/DD HH24:MI')"
)


Any input is appreciated.

Thank you very much.

EJ

[ Jess added a carriage return so the text wouldn't stretch the screen ]
[ October 19, 2004: Message edited by: Jessica Sant ]

SCJP 1.4, SCWCD
John Dinglasan
Greenhorn

Joined: Oct 19, 2004
Posts: 5
In addition, I've tried createing a batch file which calls the sql loader.

This batch file is executed by Runtime.exec(). After exection, records loaded was down to 192.

Summary:
Total records : 1030
Manual call to sql loader : 1030
Runtime.exec calls sql loader : 512
Runtime.exec calls batch file : 192

I'm also using the same user account for all execution.

And I'm running under Windows 2003 Server, Oracle 9i and Java 1.4.1

Thank you very much! =)
Jessica Sant
Sheriff

Joined: Oct 17, 2001
Posts: 4313

I'm moving this to the Oracle forum where I think it's a better fit.

So please post your replies there, thanks!
[ October 19, 2004: Message edited by: Jessica Sant ]

- Jess
Blog:KnitClimbJava | Twitter: jsant | Ravelry: wingedsheep
srikanth nallapaneni
Greenhorn

Joined: Jun 08, 2009
Posts: 4
Guys,

I have a problem in using the sqlldr in Windows2003 Server. I calling the batch file from java, I don't find any error in log, sqlldr is not loading the data.
This application I developed in WindowsXP and deployed in Win2003. It is working fine in winXP.

Is there any suggestions for this, Do I need to make any settings before I run this in windows 2003 server.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL Loader and Runtime.exec()