topic Re: [resolved] Compilation error! in Talend Studio

[resolved] Compilation error!

Anonymous — Sat, 16 Nov 2024 14:30:02 GMT

Hello my friends, I need some help for this error message when I run my job:
Starting job acteur at 10:04 28/11/2007.
Exception in component tOracleOutput_1
java.sql.SQLException: ORA-00001: unique constraint (DATAMART.PK_OP) violated
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:543)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2960)
at datamart.acteur.acteur.tAccessInput_1Process(acteur.java:1058)
at datamart.acteur.acteur.runJob(acteur.java:1223)
at datamart.acteur.acteur.main(acteur.java:1169)
Job acteur ended at 10:04 28/11/2007.

Re: [resolved] Compilation error!

Anonymous — Wed, 28 Nov 2007 10:40:57 GMT

Hi
I think it's not a compilation error. It is caused by the same primary key, for example:
table content example :
id, name (id is primary key)
1, a
2, b
Data's in Talend tDBOUtput in insert mode :
1, x
Best regards
shong

Re: [resolved] Compilation error!

Anonymous — Wed, 28 Nov 2007 11:21:39 GMT

Thank you, it's work. I change Insert to Insert or update.

Re: [resolved] Compilation error!

Anonymous — Wed, 28 Nov 2007 11:51:09 GMT

And this what does it mean?
Starting job aha at 11:48 28/11/2007.
Exception in component tOracleOutput_1
java.sql.SQLException: ORA-00957: duplicate column name
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:543)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2960)
at datamart.aha.aha.tAccessInput_1Process(aha.java:650)
at datamart.aha.aha.runJob(aha.java:814)
at datamart.aha.aha.main(aha.java:761)
Job aha ended at 11:48 28/11/2007.

Re: [resolved] Compilation error!

Anonymous — Wed, 28 Nov 2007 13:23:41 GMT

Search for ORA-00957: duplicate column name on Internet
Answer :
ORA-00957: duplicate column name
Cause: A column name was specified twice in a CREATE or INSERT statement. Column names must be unique within a table, view, or cluster.
Action: In a CREATE statement, change one of the column names to a new, unique column name. In an INSERT statement, remove one of the duplicate names.
Answer in Talend : You are using the create table and didn't check the dbcolumn name in the schema.
Regards,

Re: [resolved] Compilation error!

Anonymous — Thu, 29 Nov 2007 12:23:34 GMT

Thank you very much Mhirt and Shong.