One Star

Error with tOracleInput

Exception in component tOracleInput_2
disconnected
java.sql.SQLException: Type de colonne non valide: getLong not implemented for class oracle.jdbc.driver.T4CDateAccessor
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.driver.Accessor.unimpl(Accessor.java:387)
at oracle.jdbc.driver.Accessor.getLong(Accessor.java:526)
at oracle.jdbc.driver.OracleResultSetImpl.getLong(OracleResultSetImpl.java:521)
Same problem when using double columns
Thnaks for your help
3 REPLIES
Employee

Re: Error with tOracleInput

I tried my best but I can't reproduce it.
Can you give us detail about TOS Version, Oracle version and you db schema ?
One Star

Re: Error with tOracleInput

Ok found the problem.
I click on the "Guess query" and it replace the table name by _MyTable_
Employee

Re: Error with tOracleInput

OK, I understand now.
I have created an entry in bugtracker to deactivate Guess button if schema is Buit-in : http://talendforge.org/bugs/view.php?id=1458

Regards,