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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to