can't retrieve and display the geometry field of the Oracle database

[Anonymous]

Hello everyone, I am trying to retrieve and display the geometry field of the Oracle database, but I still have this error message, can you help me please

Exception in thread "main" java.lang.NoClassDefFoundError: oracle/xdb/XMLType
at oracle.jdbc.driver.NamedTypeAccessor.getString(NamedTypeAccessor.java:348)
at oracle.jdbc.driver.GeneratedStatement.getString(GeneratedStatement.java:287)
at oracle.jdbc.driver.GeneratedScrollableResultSet.getString(GeneratedScrollableResultSet.java:374)
at routines.system.JDBCUtil.getString(JDBCUtil.java:21)
at projet_c4.test_geometry_0_1.test_geometry.tDBInput_1Process(test_geometry.java:819)
at projet_c4.test_geometry_0_1.test_geometry.runJobInTOS(test_geometry.java:1450)
at projet_c4.test_geometry_0_1.test_geometry.main(test_geometry.java:1299)
Caused by: java.lang.ClassNotFoundException: oracle.xdb.XMLType
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 7 more

[Anonymous]

Hi,

    The error says that all the Jars needed for the tOracleInput has not been installed in your Studio. Could you please verify whether the Jars specified are present in Module section of the Studio?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hello,

thank you for your return, actually I checked and the necessary modules are installed, would you have another track please

Thanks for taking time to respond to me