INSERT SDE and JDBC Transaction

Anonymous User — Tue, 06 Jan 2015 16:45:14 GMT

Actually I develop à batch program in Java which insert Geometry in an Oracle Database.

The request to instert in Oracle I use is :

INSERT INTO TABLE(OBJECTID,GEOMETRY) VALUES(GDB_UTIL.next_rowid(<USER>, '<TABLE>' ),SDE.ST_GEOMETRY('POLYGON((10 10, 20 10, 20 20, 10 20, 10 10),(13 13, 17 13, 17 17, 13 17, 13 13))', 2154));

When I execute this request directly in Oracle (sqlplus) or in an unit test with a simple JDBC Connection it works.

When I execute this request in my batch which use a JDBC Transaction I have the Error :

Caused by: java.sql.SQLException: ORA-03001: Unimplemented feature

ORA-06512: a "SDE.ST_GEOMETRY_SHAPELIB_PKG", ligne 12

ORA-06512: a "SDE.ST_GEOMETRY", ligne 55

Does someone has already had this problem ?

Have you a solution to insert ST_GEOMETRY in a transactionnal context in Java ?

For information we use ArcGIS Server 10.2.2, Oracle 11.2.0.3 and Java 1.6

Thanks for your help

Re: INSERT SDE and JDBC Transaction

ManishGohil — Mon, 16 Aug 2021 09:01:38 GMT

Facing same problem but not able to find solution

topic Re: INSERT SDE and JDBC Transaction in Developers Questions

INSERT SDE and JDBC Transaction

Re: INSERT SDE and JDBC Transaction