topic Re: Create Oracle SDO_GEOMETRY column creation fails because of wrong template in Talend Studio

Create Oracle SDO_GEOMETRY column creation fails because of wrong template

reinier1 — Thu, 24 May 2018 11:02:55 GMT

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-this-component/m-p/114630/highlight/true#M72147

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

Re: Create Oracle SDO_GEOMETRY column creation fails because of wrong template

Anonymous — Thu, 31 May 2018 10:23:27 GMT

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

Re: Create Oracle SDO_GEOMETRY column creation fails because of wrong template

reinier1 — Thu, 31 May 2018 10:41:01 GMT

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?