This page [1] should help you to find the reason of the error. The usage of RETURNING is quite new in GeoTools and has been introduced for performance reasons.
[1] http://psoug.org/oraerror/ORA-22816.htm On Mon, Sep 12, 2016 at 8:40 PM, Cristian Olguín Avila < cristianolg...@gmail.com> wrote: > In Geoserver 2.8 we didn't have problem with View editable with trigger in > Oracle, but we upgrade to 2.9 and we receive this error when we > edit through WFST: > > Caused by: java.io.IOException: Error inserting features > at org.geotools.jdbc.JDBCDataStore.insert(JDBCDataStore.java:1697) > at org.geotools.jdbc.JDBCInsertFeatureWriter.flush( > JDBCInsertFeatureWriter.java:125) > at org.geotools.jdbc.JDBCInsertFeatureWriter.write( > JDBCInsertFeatureWriter.java:97) > at org.geotools.data.InProcessLockingManager$1. > write(InProcessLockingManager.java:337) > at org.geotools.data.store.ContentFeatureStore.addFeature( > ContentFeatureStore.java:308) > at org.geotools.data.store.ContentFeatureStore.addFeatures( > ContentFeatureStore.java:259) > at org.vfny.geoserver.global.GeoServerFeatureStore.addFeatures( > GeoServerFeatureStore.java:80) > at org.geoserver.wfs.InsertElementHandler.execute( > InsertElementHandler.java:189) > ... 108 more > Caused by: java.sql.BatchUpdateException: ORA-22816: unsupported feature > with RETURNING clause > > at oracle.jdbc.driver.OraclePreparedStatement.executeBatch( > OraclePreparedStatement.java:10296) > at oracle.jdbc.driver.OracleStatementWrapper.executeBatch( > OracleStatementWrapper.java:216) > at org.apache.commons.dbcp.DelegatingStatement.executeBatch( > DelegatingStatement.java:297) > at org.apache.commons.dbcp.DelegatingStatement.executeBatch( > DelegatingStatement.java:297) > at org.apache.commons.dbcp.DelegatingStatement.executeBatch( > DelegatingStatement.java:297) > at org.geotools.jdbc.JDBCDataStore.insertPS(JDBCDataStore.java:1762) > at org.geotools.jdbc.JDBCDataStore.insert(JDBCDataStore.java:1683) > ... 115 more > > any help?? > > thanks > > ------------------------------------------------------------ > ------------------ > What NetFlow Analyzer can do for you? Monitors network bandwidth and > traffic > patterns at an interface-level. Reveals which users, apps, and protocols > are > consuming the most bandwidth. Provides multi-vendor support for NetFlow, > J-Flow, sFlow and other flows. Make informed decisions using capacity > planning reports. http://sdm.link/zohodev2dev > _______________________________________________ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > >
------------------------------------------------------------------------------
_______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users