Create Oracle SDO_GEOMETRY column creation fails because of wrong template

[reinier1]

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.

https://community.talend.com/t5/Design-and-Development/resolved-the-schema-s-dbType-not-correct-for-...

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

[Anonymous]

Hello,

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.

Best regards

Sabrina

[reinier1]

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?