Four Stars

Create Oracle SDO_GEOMETRY column creation fails because of wrong template

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

 

 

 

2 REPLIES
Moderator

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

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.

metadataofTalendType.png

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

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

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?