One Star

[resolved] Compilation error!

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.
1 ACCEPTED SOLUTION

Accepted Solutions
Community Manager

Re: [resolved] Compilation error!

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
5 REPLIES
Community Manager

Re: [resolved] Compilation error!

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] Compilation error!

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

Re: [resolved] Compilation error!

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.
Employee

Re: [resolved] Compilation error!

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,
One Star

Re: [resolved] Compilation error!

Thank you very much Mhirt and Shong.