AnsweredAssumed Answered

INSERT SDE and JDBC Transaction

Question asked by sybarbier on Jan 6, 2015

Hi

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

Outcomes