topic Re: Oracle SDO_GEOMETRY (Geometry cannot be resolved to a type) in Talend Studio

Oracle SDO_GEOMETRY (Geometry cannot be resolved to a type)

TomTom4 — Sat, 16 Nov 2024 12:50:14 GMT

Hi,
could you please help me with this issue. I'm developing a job using TOS (4.2.2.r63143). I want to read and map oracle sdo_geometry datatype. If I load the schema into tOracleInput component, the datatype SDO_GEOMETRY is highlighted red. If I switch TYPE to Geometry and reset the DB TYPE then MDSYS.SDO_GEOMETRY is selected as DB TYPE . There are no more missing .jar files before executing the job. After execution I get the following error message : Error in the component's properties:Geometry cannot be resolved to a type. Is there any patch which has to be applied?
Thanks,
Tamas

Re: Oracle SDO_GEOMETRY (Geometry cannot be resolved to a type)

TomTom4 — Thu, 30 Jun 2011 13:36:45 GMT

the error message looks like this jet:
Exception in thread "main" java.lang.Error: Unresolved compilation problems:
The method setGeometry(int, Geometry) is undefined for the type PreparedStatement
The method setGeometry(int, Geometry) is undefined for the type PreparedStatement
at cp_srv_2_srv_tld.srv_cp_job_0_1.srv_cp_job.tOracleInput_3Process(srv_cp_job.java:3486)
at cp_srv_2_srv_tld.srv_cp_job_0_1.srv_cp_job.runJobInTOS(srv_cp_job.java:7929)
at cp_srv_2_srv_tld.srv_cp_job_0_1.srv_cp_job.main(srv_cp_job.java:7781)
Job srv_cp_job ended at 14:36 30/06/2011.

Re: Oracle SDO_GEOMETRY (Geometry cannot be resolved to a type)

TomTom4 — Thu, 30 Jun 2011 16:21:38 GMT

could someone please give me support on this? Is there any patch which has to be applied in order to be able to work with sdo_geometry datatype in talend?
thanks.

Re: Oracle SDO_GEOMETRY (Geometry cannot be resolved to a type)

TomTom4 — Tue, 05 Jul 2011 10:19:48 GMT

Hi,
I'm still not able to map Oracle SDO_GEOMETRY Datatype in tOracleOutput. Is there somebody how is able to do this? Does this work? Am I doing something wrong?

Re: Oracle SDO_GEOMETRY (Geometry cannot be resolved to a type)

TomTom4 — Tue, 05 Jul 2011 14:42:47 GMT

OK, it is now working, as the Type should be Object, not Geometry!