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 https://community.talend.com/. We look forward to hearing from you there!



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

Johannes Kutterer
Guest

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(db2db_spatial.java:901)
    at etl_test.db2db_spatial_0_1.db2db_spatial.runJobInTOS(db2db_spatial.java:1296)
    at etl_test.db2db_spatial_0_1.db2db_spatial.main(db2db_spatial.java:1161)

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

Ananth_Rallapalli
Member
3 posts

Ananth_Rallapalli said:

Re: Write tOracleInput into Shapefile

Hi,

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

Thanks,
Ananth

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy