INSERT SDE and JDBC Transaction

4543
1
01-06-2015 08:45 AM
by Anonymous User
Not applicable

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

1 Reply
ManishGohil
New Contributor III

Facing same problem but not able to find solution

0 Kudos