Create Oracle SDO_GEOMETRY column creation fails because of wrong template

Highlighted
Six 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.
Six 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?

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch