You are not logged in.

Unanswered posts

Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at We look forward to hearing from you there!

#1 2014-06-10 13:29:20

Johannes Kutterer

Johannes Kutterer said:

Write tOracleInput into Shapefile

I've tried to read a OracleDb-Table with an sdo_geometry using the tOracleInput. When I tried to write the db table as an shapefile with sShapefileOutput (tOracleInput ---->  sShapefileOutput) I get the following error message:

Exception in thread "main" java.lang.Error: Unresolved compilation problem:
    Type mismatch: cannot convert from Object to Geometry

    at etl_test.db2db_spatial_0_1.db2db_spatial.tOracleInput_1Process(
    at etl_test.db2db_spatial_0_1.db2db_spatial.runJobInTOS(
    at etl_test.db2db_spatial_0_1.db2db_spatial.main(

In the tOracleInput I have to select Object as Type (geoemtry don't work) and as DB Type I select MDSYS.SDO_GEOMETRY

In the sshapefileOutput if selected geometry as type.

Shouldn't it possible to read an sdo_geometry from an oracle db into a geometry datatype in talend?

#2 2016-02-08 16:37:02

3 posts

Ananth_Rallapalli said:

Re: Write tOracleInput into Shapefile


How to read geo-spatial data in oracle component and what data type needs to be given for such data ?



Board footer

Talend Contributor Agreement - Talend Website Privacy Policy