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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2007-07-05 11:35 AM

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)
Labels
282 Views
0 Likes
3 Replies
Anonymous
Not applicable
‎2007-07-06 11:58 AM
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 ?
282 Views
0 Likes
Anonymous
Not applicable
‎2007-07-09 11:17 AM
Author

Ok found the problem.
I click on the "Guess query" and it replace the table name by _MyTable_
282 Views
0 Likes
Anonymous
Not applicable
‎2007-07-09 11:55 AM
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,
282 Views
0 Likes