Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
/// writing a geometry back to database
PreparedStatement ps = connection.prepareStatement(
"UPDATE states set geometry=? where name='Florida'");
//convert JGeometry instance to DB STRUCT using the SDO pickler
STRUCT obj = JGeometry.store(connection, j_geom);
ps.setObject(1, obj);
ps.execute();
Hello,
Do you find any solution to fill the Oracle SDO_GEOMETRY type with the tOracleOutput.
I still trying to get the SDO_GEOMETRY type on my list ou data type.
I have add the object type SDO_GEOMETRY to the mapping_oracle.xml file, on the project stting mapping directory and the configuration mapping directory, but no result, nothing appears.
I'm assuming the SDI component works with Oracle, but I can only find old post and no example on how to implement with Oracle.
Is it possible to get the SDO_GEOMTRY type on the list of DB TYPE?
has anyone implemented it successfully?
Thanks a lot for your help,
Vincent
Hi Vincent,
I've just seen today your message... It is possible to add the SDO_GEOMETRY type to work with ORACLE using the mapping.xml file of Talend. May be you already have discovered, long time ago that you post the message...