Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (2)
3 Replies
Anonymous
Not applicable
Author

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

Ok found the problem.
I click on the "Guess query" and it replace the table name by _MyTable_
Anonymous
Not applicable
Author

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,