topic Re: load data from a file to oracle table using bulk exec in Talend Studio

load data from a file to oracle table using bulk exec

Anonymous — Fri, 11 Jul 2014 14:16:01 GMT

hi talend pro
i have a problem i use tfileinputdelimited --> toracleoutputbulkexec
but it does'nt work
because this error : java.io.FileNotFoundException: C:\out.csv (Access is denied)
i need help please can you show me how i do the bulk load from a file to a oracle table
and thanks for your great help

Re: load data from a file to oracle table using bulk exec

Anonymous — Fri, 11 Jul 2014 14:34:11 GMT

hi,
as message tell you : you don't have permission to write in C:/ .
choose another location.
regards
laurent

Re: load data from a file to oracle table using bulk exec

Anonymous — Fri, 11 Jul 2014 14:35:41 GMT

Whether the metadata is created for input file?
Error says that the file is not generated based on input file.. Whether the file exists in the c:\?
vaibhav

Re: load data from a file to oracle table using bulk exec

Anonymous — Fri, 11 Jul 2014 14:44:25 GMT

Thanks laurent for your reply
but what's the problem with the c:/ i don't think so
Thanks vaibhav for your reply , can you explain to me how can i do this becaue there is a file which his path in the file name generated by the same data of my tfileinputdelimited ? and what should i do
thanks for your help

Re: load data from a file to oracle table using bulk exec

Anonymous — Fri, 11 Jul 2014 15:04:02 GMT

could you try to bulk your data with OracleBulk + OracleExec (do the same think that OutputBulkExec but using 2 components)
Also try to write a simple flat file in c:\ (just a test
regards

Re: load data from a file to oracle table using bulk exec

Anonymous — Fri, 11 Jul 2014 15:13:05 GMT

Thanks kzone for your help
i try of course with toracleoutputbulk and toraclebulkexec
then if i met in the file name of the component toracleoutputbulk the path of my tfileinputdelimited
this componenent writes data in the same data
and if i met a new path i have this error :Exception in component tOracleOutputBulk_1
java.io.FileNotFoundException: C:\out.csv (Access is denied)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(Unknown Source)
at java.io.FileOutputStream.<init>(Unknown Source)
can you show me by example how i do this and thanks