probleme with insert or update with the date of the day
hello i want to insert or update into a table
when the join is realised i update informations
when it s a rejet i insert a new row into the table
i have a probleme with my job
it s the error message :
Starting job testdatemodifetcre at 14:17 18/02/2008.
Exception in thread "main" java.lang.Error: Unresolved compilation problems:
This method must return a result of type Date
This method must return a result of type Date
at decisionel.testdatemodifetcre.testdatemodifetcre.tRowGenerator_1Process(testdatemodifetcre.java:1309)
at decisionel.testdatemodifetcre.testdatemodifetcre.tOracleInput_1Process(testdatemodifetcre.java:289)
at decisionel.testdatemodifetcre.testdatemodifetcre.runJob(testdatemodifetcre.java:1469)
at decisionel.testdatemodifetcre.testdatemodifetcre.main(testdatemodifetcre.java:1405)
Job testdatemodifetcre ended at 14:17 18/02/2008.
Exception in component tOracleOutput_2
java.sql.SQLException: ORA-00936: missing expression
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 decisionel.testdatemodifetcre.testdatemodifetcre.tOracleInput_1Process(testdatemodifetcre.java:776)
at decisionel.testdatemodifetcre.testdatemodifetcre.runJob(testdatemodifetcre.java:1371)
at decisionel.testdatemodifetcre.testdatemodifetcre.main(testdatemodifetcre.java:1307)
Job testdatemodifetcre ended at 16:09 19/02/2008.
i have found the solution, i have one job for the insert and an other for the update.
inj the end of the insert, the update run automatically
i have deleted the pb of same name of colonnes
