Write tOracleInput into Shapefile

_AnonymousUser — Sat, 16 Nov 2024 11:37:01 GMT

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?

Re: Write tOracleInput into Shapefile

Anonymous — Mon, 08 Feb 2016 15:37:02 GMT

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

Re: Write tOracleInput into Shapefile

vrobine — Fri, 07 Aug 2020 08:45:35 GMT

Hello,

Do you have any answers since 4 years or do you find a solution?

Thanks in advance,

Vincent

topic Write tOracleInput into Shapefile in Talend Studio

Write tOracleInput into Shapefile

Re: Write tOracleInput into Shapefile

Re: Write tOracleInput into Shapefile