One Star

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?

1 REPLY

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