Hi.. folks.. Can you help me with this, I used trigger in view to set some data by default, but:
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(JDBCInsertFe > atureWriter.java:125) > at org.geotools.jdbc.JDBCInsertFeatureWriter.write(JDBCInsertFe > atureWriter.java:97) > at org.geotools.data.InProcessLockingManager$1.write( > InProcessLockingManager.java:337) > at org.geotools.data.store.ContentFeatureStore.addFeature(Conte > ntFeatureStore.java:308) > at org.geotools.data.store.ContentFeatureStore.addFeatures(Cont > entFeatureStore.java:259) > at org.vfny.geoserver.global.GeoServerFeatureStore.addFeatures( > GeoServerFeatureStore.java:80) > at org.geoserver.wfs.InsertElementHandler.execute(InsertElement > Handler.java:189) > ... 108 more > Caused by: java.sql.BatchUpdateException: ORA-22816: unsupported feature > with RETURNING clause > > at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(Orac > lePreparedStatement.java:10296) > at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(Oracl > eStatementWrapper.java:216) > at org.apache.commons.dbcp.DelegatingStatement.executeBatch(Del > egatingStatement.java:297) > at org.apache.commons.dbcp.DelegatingStatement.executeBatch(Del > egatingStatement.java:297) > at org.apache.commons.dbcp.DelegatingStatement.executeBatch(Del > egatingStatement.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 > Cristian O.
------------------------------------------------------------------------------
_______________________________________________ GeoTools-GT2-Users mailing list GeoTools-GT2-Users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users