More over if from that destination table if i want to read the data as timestamp will the Teiid support for that. Primary key is save as number 10 in this oracle table. This content has been marked as final. All forum topics Previous Topic Next Topic. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
|Date Added:||23 November 2006|
|File Size:||64.33 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Hi, i have a column typed Date on talend.
Join the world’s largest interactive community dedicated to Oracle technologies.
I have a entity as shown in the code.
SS’ as x From Source. The Definitive Guide to Data Quality. This content has been marked as final.
OK, but now the question is how I can get integer value from rowID? I am able to fetch data from the view directly.
Definitive Guide to Data Integration Practical steps to developing your data integration strategy. Conversion to integer failed at oracle. Please type your message and try again. Yes, as long as you fog using the View table Bar from above to populate your destination table then the column is of type “timestamp”.
ROWID is a class. Learn from thousands of community experts Get answers to your technical clxss Share your knowledge with peers 1, In the new window, change the date field pattern according to the source table as shown in Picture5.
Solved: [resolved] SQLException: Invalid column type: getT – Talend Community
I download another jdbc driver ojdbc These fields are probably stored in a column of type Date in database, and the database driver doesn’t know how to convert a date to an integer. I am using oracle DB. Please type your message gettimestanp try again.