autoIncrement of oracle sequence with talend

[Anonymous]

I have a quastion can i generate the next value of an oracle sequence ,  to insert into a primary key of a table ,with talend in the composant troaclerow , or what should i do 

thanks for help 

[Anonymous]

Tell what does not work. Please post the error message.

[Anonymous]

This is my screen shot  
 
 
when i run i have that RA-00957: duplicate column name
what should i put in the advanced Settings of the toraceOutPut in the additional columns to generates the next val of the sequence
Thanks jlolling

[Anonymous]

I bet you have forget to remove the ID_HTTP_TRACE in the schema - as I suggested in my first post.
Of course you will get this error when you simply add this column the additional columns without removing it from the schema.

[Anonymous]

If I delete the id of the table from the schema in the component , I can't add it in the refrenced Column 
how to do it please 
Thanks

[Anonymous]

What you mean with "referenced Column" ?
In your first picture in the post#12 you have added this column name as a String with the correct SQL expression - why this does not work anymore?
You have done everything right, only you forgot to delete the column from the schema.

[Anonymous]

in the additional column i should put the refrenced column 
and when i delete the id of the table from the schema it propose for me in selected item the other column of the table 

how to do please 
Thanks

[Anonymous]

Aahh sorry, OK this reference column is actual nothing else than the column where the new column have to set before or after in the list of columns. You do not have to take care on this. It doesn't matter on which position your additional ID column is located in the generated insert statement.

[Anonymous]

When i run i have this error :
ORA-01400: cannot insert NULL into ("KPI"."HTTP_TRACE"."ID_HTTP_TRACE")
ORA-01400: cannot insert NULL into ("KPI"."HTTP_TRACE"."ID_HTTP_TRACE")
also i put in the SQL expression : "KPI.ID_SEQ_HTTP_TRACE.NEXTVAL"
Then i would insert the next value of the sequence in the column Id of the table 
help please 
Thanks

[Anonymous]

Please post also the schema here as screenshot and again the advanced settings. There must something wrong here. The method I explained to you is very common for Talend.

[Anonymous]

the schema without after i delete the id in the main
 
and in the additional colmun i should put the name , the sql expression , the position and the refrence column