Create Oracle SDO_GEOMETRY column creation fails because of wrong template

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

 

 

 

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?

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.