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
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?