tOracleCDC component usage?

Anonymous — Sat, 16 Nov 2024 13:57:47 GMT

Hello Guys,
Has any one used tOracleCDC -- Component. I am trying to insert and is throwing an exception:
exception in component tOracleCDC_2
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:386)
at relayhealth.test_cdc_0_1.Test_CDC.tOracleCDC_2Process(Test_CDC.java:566)
at relayhealth.test_cdc_0_1.Test_CDC.runJobInTOS(Test_CDC.java:938)
at relayhealth.test_cdc_0_1.Test_CDC.main(Test_CDC.java:850)
Any ideas?
Thanks,
Yogesh

Re: tOracleCDC component usage?

Anonymous — Tue, 12 May 2009 15:30:39 GMT

Hello

ORA-00942: table or view does not exist

As the error message shows, the table does't exist in your database, please make sure the table name is correct or create the table before you insert data into table.
Best regards

shong

topic tOracleCDC component usage? in Talend Studio

tOracleCDC component usage?

Re: tOracleCDC component usage?