topic Re: tOracleBulkExec in Talend Studio

tOracleBulkExec

Anonymous — Thu, 10 May 2012 01:56:26 GMT

Hello,
I want to know why this error occured?
Please help me.
=========================================================================
connecting to socket on port 3541
connected
Exception in component tOracleBulkExec_2
java.io.IOException: Cannot run program "sqlldr": CreateProcess error=2, ??d?? Æ???; ?; ¼? ¾ø
at java.lang.ProcessBuilder.start(ProcessBuilder.java:460)
at java.lang.Runtime.exec(Runtime.java:593)
at java.lang.Runtime.exec(Runtime.java:431)
at java.lang.Runtime.exec(Runtime.java:369)
at tbmd_spot_ord.tbmd_spot_ord_tmp1_0_1.TBMD_SPOT_ORD_TMP1.tOracleBulkExec_2Process(TBMD_SPOT_ORD_TMP1.java:492)
at tbmd_spot_ord.tbmd_spot_ord_tmp1_0_1.TBMD_SPOT_ORD_TMP1.runJobInTOS(TBMD_SPOT_ORD_TMP1.java:858)
at tbmd_spot_ord.tbmd_spot_ord_tmp1_0_1.TBMD_SPOT_ORD_TMP1.main(TBMD_SPOT_ORD_TMP1.java:717)
Caused by: java.io.IOException: CreateProcess error=2, ??d?? Æ???; ?; ¼? ¾ø
at java.lang.ProcessImpl.create(Native Method)
at java.lang.ProcessImpl.<init>(ProcessImpl.java:81)
at java.lang.ProcessImpl.start(ProcessImpl.java:30)
at java.lang.ProcessBuilder.start(ProcessBuilder.java:453)
... 6 more
disconnected
=============================================================

Re: tOracleBulkExec

Anonymous — Thu, 10 May 2012 03:09:09 GMT

Hi
The tOracleBulkExec component uses sqlldr program to load a flat file for better performance.
You need to make sure two things.
No.1: Check whether there is Oracle or sqlldr installed in your local machine.
No.2: Check whether you have set Oracle environment variables for sqlldr correctly.
Regards,
Pedro

Re: tOracleBulkExec

Anonymous — Thu, 10 May 2012 08:09:21 GMT

Thanks pedro.
How can I do setting sqlldr in tOracleBulkExec component?
And how can I do mapping from input data to output table?
tOracleInput ---------------- tFileOutputDelimited (input data)
|
|
|
tOracleBulkExec (output table)

Re: tOracleBulkExec

Anonymous — Thu, 10 May 2012 08:16:49 GMT

Hi
The setting of sqlldr, in fact, is an issue about Oracle. So do you install Oracle in your local machine?
For sqlldr environment variable, you might find info from google.
Besides, I think you'd better use tOracleOutputBulk instead of tFileOutputDelimited.
Regards,
Pedro

Re: tOracleBulkExec

Anonymous — Mon, 14 May 2012 08:44:39 GMT

Oracle 10g setting
NLS_LANG : AMERICAN_AMERICA.KO16MSWIN949

How do I set up in tOraclebulkExec??
Is it right?

Re: tOracleBulkExec

Anonymous — Mon, 14 May 2012 09:01:09 GMT

Hi
In fact, this is not an issue about how to configure tOraclebulkExec.
It's an issue about SQLLDR environment variables.
Type 'SQLLDR' in cmd. If this command is recognized and you can see parameters info about 'SQLLDR', tOracleBulkExec will work fine.
If not, you need to configure SQLLDR environment variables.
Here is the URL about SQLLDR.
http://www.ordba.net/Tutorials/OracleUtilities~SQLLoader.htm
In short, make sure 'sqlldr' can run in commandline.
Regards,
Pedro