topic Re: tOracleOutputBulk and tOracleBulkExec components in Talend Studio

tOracleOutputBulk and tOracleBulkExec components

Anonymous — Thu, 23 Jul 2015 14:46:13 GMT

Hi,
I created a DB connection (oracle11g) and created a job using toraceloutput componet and it works fine.
Now I used same connection but with tOracleOutputBulk and tOracleBulkExec components and suddenly it giving me error .

SQL*Loader-704: Internal error: ulconnect: OCIServerAttach
ORA-12545: Connect failed because target host or object does not exist
Exception in component tOracleOutputBulkExec_1_tOBE
java.lang.Exception
at testparallelprocessing.testpapo_0_1.TestPaPo.tFileInputDelimited_1Process(TestPaPo.java:5308)
at testparallelprocessing.testpapo_0_1.TestPaPo$6.run(TestPaPo.java:6843)

Thanks,
Pankaj

Re: tOracleOutputBulk and tOracleBulkExec components

Anonymous — Fri, 24 Jul 2015 04:25:52 GMT

Hi Pankaj,
Did your DB oracle support for "bulk"? Have you tried to use tOracleOutputBulkExec to see if it works?
Best regards
Sabrina

Re: tOracleOutputBulk and tOracleBulkExec components

Anonymous — Mon, 27 Jul 2015 12:05:01 GMT

Hi Sabarina,
I was trying out tOracleOutputBulkExec component and it gave me above error.

Did your DB oracle support for "bulk"? Have you tried to use tOracleOutputBulkExec to see if it works?

How to check if my DB supports "Bulk" . If you talking about bulk collect then oracle supports it.

---------------
After this I defined connection using option "Oracle SID" .
Now it doest give me any error but doesn't commit also .
and console output :

Starting job TestPaPo at 16:34 27/07/2015.
connecting to socket on port 3871
connected
SQL*Loader: Release 11.XX.XXXX - Production on Mon Jul 27 16:34:59 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
disconnected
Job TestPaPo ended at 16:35 27/07/2015.

M I missing something???