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?