I am using a tCreateTable to create a table in oracle with an SDO_GEOMETRY column.
The resulting java creates SQL that looks like:
create table XYZ (GEOM SDO_GEOMETRY(0,0))
The (0,0) are invalid, the column should just have a type, nothing more.
In the component there is an error: 'the schema's dbType not correct for this component'
This screenshot shows a way to possibly alter the Oracle schema of Talend to fix the issue, but I do not have the 'Metadata of Talend Type' option in my Studio.
Would it be possible to teach Talend how to add a GEOM column?
(I do not have access to JIRA, so I can not file this as a bug myself. Still evaluating on the Community Version, 7.01
About the data type mapping between Talend type and db type, you can go to
project settings-->General-->Metadata of Talend Type.
Please have a look at my screenshot.
Wonderful. I was looking in the preferences window.
Is there an easy way to provide a patch for this, so my edit could be shared with other users?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables