AnsweredAssumed Answered

INSERT SDE and JDBC Transaction

Question asked by sybarbier on Jan 6, 2015


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", 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 and Java 1.6


Thanks for your help