Jukka,
I didn't solve the problem but I avoided it. I moved to the database where the
other app was, and I got it working now, more or less. So far I only inserted
or deleted features, but now I'm on the task of modifying features (geometries
and/or attributes) and I'm getting an error like this:
java.sql.SQLException: Invalid column index
The full traceback:
26 Aug 13:16:55 DEBUG [org.geotools.data.oracle.sdo] - Using layer SRID: 82337
26 Aug 13:16:55 DEBUG [org.geotools.jdbc] - Setting parameter 1 as
MDSYS.SDO_GEOMETRY(2003,82337,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(541986.577653215,4748475.62328657,541849.58709717,4748685.17749023,541849.57830811,4748685.49389648,541836.59710693,4748684.92150879,541820.00970459,4748684.18768311,541761.45288086,4748681.80249023,541750.04528809,4748681.33288574,541721.67987061,4748680.28570557,541688.58569336,4748679.06091309,541693.09887695,4748650.43707275,541695.59527588,4748629.32189941,541695.92712402,4748626.53149414,541697.32348633,4748617.47351074,541699.51092529,4748603.3192749,541704.25091553,4748572.3045044,541705.22930908,4748563.34631348,541705.54089356,4748560.49047852,541705.75668311,4748550.86691705,541705.75781247,4748550.68075524,541703.98541388,4748539.32302307,541703.43591309,4748537.3928833,541701.53930664,4748530.70727539,541699.8571167,4748524.7769165,541698.25268555,4748512.79650879,541697.89910889,4748497.7612915,541696.97192383,4748484.72387695,541694.42907715,4748449.16888428,541694.40350342,4748448.86151123,541693.12231445,4748441.14630127,541692.86791992,4748426.6795044,541692.91992188,4748423.73828125,541692.98248291,4748420.20147705,541693.14227295,4748410.7822876,541692.31347656,4748396.19091797,541690.56567383,4748373.97967529,541690.22270481,4748369.58407418,541732.28668213,4748364.98028564,541743.4519043,4748363.75427246,541750.97448731,4748362.65490723,541779.27709961,4748358.50787354,541808.21350098,4748352.54949951,541822.44128418,4748351.98431396,541827.50109863,4748351.7824707,541845.62988281,4748358.08288574,541863.04825749,4748365.23535807,541986.577653215,4748475.62328657))
26 Aug 13:16:55 DEBUG [org.geotools.jdbc] - 1 = POLYGON ((541986.577653215
4748475.62328657, 541849.58709717 4748685.17749023, 541849.57830811
4748685.49389648, 541836.59710693 4748684.92150879, 541820.00970459
4748684.18768311, 541761.45288086 4748681.80249023, 541750.04528809
4748681.33288574, 541721.67987061 4748680.28570557, 541688.58569336
4748679.06091309, 541693.09887695 4748650.43707275, 541695.59527588
4748629.32189941, 541695.92712402 4748626.53149414, 541697.32348633
4748617.47351074, 541699.51092529 4748603.3192749, 541704.25091553
4748572.3045044, 541705.22930908 4748563.34631348, 541705.54089356
4748560.49047852, 541705.75668311 4748550.86691705, 541705.75781247
4748550.68075524, 541703.98541388 4748539.32302307, 541703.43591309
4748537.3928833, 541701.53930664 4748530.70727539, 541699.8571167
4748524.7769165, 541698.25268555 4748512.79650879, 541697.89910889
4748497.7612915, 541696.97192383 4748484.72387695, 541694.42907715
4748449.16888428, 541694.40350342 4748448.86151123, 541693.12231445
4748441.14630127, 541692.86791992 4748426.6795044, 541692.91992188
4748423.73828125, 541692.98248291 4748420.20147705, 541693.14227295
4748410.7822876, 541692.31347656 4748396.19091797, 541690.56567383
4748373.97967529, 541690.22270481 4748369.58407418, 541732.28668213
4748364.98028564, 541743.4519043 4748363.75427246, 541750.97448731
4748362.65490723, 541779.27709961 4748358.50787354, 541808.21350098
4748352.54949951, 541822.44128418 4748351.98431396, 541827.50109863
4748351.7824707, 541845.62988281 4748358.08288574, 541863.04825749
4748365.23535807, 541986.577653215 4748475.62328657))
26 Aug 13:16:55 DEBUG [org.geotools.jdbc] - 3 = 010130050002
26 Aug 13:16:55 DEBUG [org.geotools.jdbc] - 4 = 17
26 Aug 13:16:55 DEBUG [org.geotools.jdbc] - 5 = 1
26 Aug 13:16:55 DEBUG [org.geotools.jdbc] - 6 = UG_17
26 Aug 13:16:55 DEBUG [org.geotools.jdbc] - 7 = 1
26 Aug 13:16:55 DEBUG [org.geotools.jdbc] - 8 = 13
26 Aug 13:16:55 DEBUG [org.geotools.jdbc] - 9 = 0
26 Aug 13:16:55 DEBUG [org.geotools.jdbc] - 10 = 0
26 Aug 13:16:55 DEBUG [org.geotools.jdbc] - 11 = 3
26 Aug 13:16:55 DEBUG [org.geotools.jdbc] - 12 = 504
26 Aug 13:16:55 DEBUG [org.geotools.jdbc] - 13 = 1
26 Aug 13:16:55 ERROR [org.geoserver.wfs] - Transaction failed
org.geoserver.wfs.WFSTransactionException: update error
at
org.geoserver.wfs.UpdateElementHandler.execute(UpdateElementHandler.java:246)
at org.geoserver.wfs.Transaction.execute(Transaction.java:334)
at org.geoserver.wfs.Transaction.transaction(Transaction.java:109)
at
org.geoserver.wfs.DefaultWebFeatureService.transaction(DefaultWebFeatureService.java:163)
at sun.reflect.GeneratedMethodAccessor264.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.geoserver.ows.util.EMFLogger.invoke(EMFLogger.java:51)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy19.transaction(Unknown Source)
at sun.reflect.GeneratedMethodAccessor263.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.geoserver.ows.Dispatcher.execute(Dispatcher.java:599)
at
org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:230)
at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:47)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.RuntimeException: java.sql.SQLException: Invalid column
index
at org.geotools.jdbc.JDBCDataStore.update(JDBCDataStore.java:1309)
at
org.geotools.jdbc.JDBCFeatureStore.modifyFeatures(JDBCFeatureStore.java:354)
at
org.geoserver.feature.retype.RetypingFeatureStore.modifyFeatures(RetypingFeatureStore.java:76)
at
org.vfny.geoserver.global.GeoServerFeatureStore.modifyFeatures(GeoServerFeatureStore.java:113)
at
org.geoserver.wfs.UpdateElementHandler.execute(UpdateElementHandler.java:238)
... 68 more
Caused by: java.sql.SQLException: Invalid column index
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at
oracle.jdbc.driver.OraclePreparedStatement.setBigDecimalInternal(OraclePreparedStatement.java:5227)
at
oracle.jdbc.driver.OraclePreparedStatement.setBigDecimal(OraclePreparedStatement.java:5219)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.setBigDecimal(DelegatingPreparedStatement.java:129)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.setBigDecimal(DelegatingPreparedStatement.java:129)
at
org.geotools.jdbc.PreparedStatementSQLDialect.setValue(PreparedStatementSQLDialect.java:135)
at
org.geotools.jdbc.JDBCDataStore.setPreparedFilterValues(JDBCDataStore.java:2836)
at org.geotools.jdbc.JDBCDataStore.updateSQLPS(JDBCDataStore.java:3621)
at org.geotools.jdbc.JDBCDataStore.update(JDBCDataStore.java:1300)
Insert and Delete work fine.
Anyone has any idea what can be happening??
TIA.
Regards,
Un saludo,
··················································································
David Alda Fernández de Lezea
Lurralde eta Biodibertsitate Saila / Dpto. de Territorio y Biodiversidad
IKT
Granja Modelo s/n · 01192 · Arkaute (Araba)
··················································································
Tlfnos.: 945-00-32-95 Fax: 945-00.32.90
··················································································
email: [email protected] web: www.ikt.es
··················································································
-----Mensaje original-----
De: Rahkonen Jukka [mailto:[email protected]]
Enviado el: jueves, 25 de agosto de 2011 10:47
Para: David Alda Fernandez de Lezea; [email protected]
Asunto: Re: Error performing insert over wfs-t
Hi,
If fid is like this
<wfs:Insert>
<feature:UnidadesGestion xmlns:feature="http://192.168.3.15/ikt";
fid="RecintosSigpac.fid--21720f22_131f62e83e7_5838">
then everything does not go like you hope And log file telling that Geoserver
is trying to feed max_value+1 as a new fid makes me think that Geoserver does
not find the sequence to use. I am remembering that is should be named as
TABLE_SEQUENCE do that Geoserver finds it automatically, but it can be
controlled by creating a special GEOSERVER_METADATA table into Oracle. Use of
metadata table is documented.
Check first from the GetFeature results that the primary key is really used as
fid.
-Jukka Rahkonen-
____________________________________
____
Lähettäjä: David Alda Fernandez de Lezea [[email protected]]
Lähetetty: 25. elokuuta 2011 10:50
Vastaanottaja: Rahkonen Jukka; [email protected]
Aihe: RE: Error performing insert over wfs-t
Jukka,
> Do you have an integer field as a primary key in the table?
Yes I do. I also have a sequence in order to take new values.
> In production environment you will need to use also a trigger and possibly
> some other things to guarantee that concurrent users doing updates are
> getting unique fid for their inserts.
There's no need to accomplish this at the moment because the application I'm
developing does not allow concurrent editing users.
I also get an error while performing an update, even though if I only modify
some alphanumeric data, not the geometry data.
I have the feeling that it has got something to do with my table definition.
I'm gonna keep searching.
Thanks,
Regards,
Un saludo,
··················································································
David Alda Fernández de Lezea
Lurralde eta Biodibertsitate Saila / Dpto. de Territorio y Biodiversidad
IKT
Granja Modelo s/n · 01192 · Arkaute (Araba)
··················································································
Tlfnos.: 945-00-32-95 Fax: 945-00.32.90
··················································································
email: [email protected] web: www.ikt.es
··················································································
-----Mensaje original-----
De: Rahkonen Jukka [mailto:[email protected]]
Enviado el: miércoles, 24 de agosto de 2011 16:13
Para: David Alda Fernandez de Lezea; [email protected]
Asunto: Re: Error performing insert over wfs-t
Hi,
I am not sure what is going wrong but otherwise I have a feeling that your fid
is not optimal. Do you have an integer field as a primary key in the table?
The righ way to handle fids is a bit complicated and you will need at least a
sequence to take new values from. In production environment you will need to
use also a trigger and possibly some other things to guarantee that concurrent
users doing updates are getting unique fid for their inserts.
-Jukka Rahkonen-
David Alda Fernandez de Lezea wrote:
> Hi list,
> I'm having some problems performing a wfs-t insert. So far, I've
> working with some other oracle tables and everything has worked fine,
> but now I'm facing a different situation. Everything seems to be OK
> but I've found something strange in the logs. While trying to
> construct the GeoServer request to Oracle, the GeoServer instance
> apparently misses the geometry field
> 2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting GEOMETRY
> to
> 2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting 14 to
While in other requests from another application I developed a while ago,
>2011-08-24 13:36:03,730 DEBUG [org.geotools.jdbc] - Setting PENDIENTE
>to 89
>2011-08-24 13:36:03,730 DEBUG [org.geotools.jdbc] - Setting 16 to 89
>2011-08-24 13:36:03,730 DEBUG [org.geotools.jdbc] - Setting GEOMETRY to
>POLYGON ((...))
>2011-08-24 13:36:03,730 DEBUG [org.geotools.jdbc] - Getting next FID:
>SELECT MAX(GID) + 1 FROM USRCARTO.TB_PRUEBA_WFST
>2011-08-24 13:36:03,730 DEBUG [org.geotools.jdbc] - Inserting new
>feature with ps: INSERT INTO USRCARTO.TB_PRUEBA_WFST (
>PROVINCIA,MUNICIPIO,POLIGONO,PARCELA,RECINTO,DN_SURFACE,DN_PERIMET,ELEG
>IBILID,COEF_REGAD,COEF_PASTO,PARCELA_AG,DN_OID,FECHA,USO_SIGPAC,USO_200
>3,PENDIENTE,GEOMETRY,GID ) VALUES (
>?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
>2011-08-24 13:36:03,730 DEBUG [org.geotools.jdbc] - 1 = 1
GeoServer Log:
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting CODEX to
010130050002
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting 0 to 010130050002
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting UG to 17
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting 1 to 17
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting VERSION to 1
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting 2 to 1
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting TOPONIMO to UG_17
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting 3 to UG_17
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting PROVINCIA to 1
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting 4 to 1
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting MUNICIPIO to 13
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting 5 to 13
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting AGREGADO to 0
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting 6 to 0
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting ZONA to 0
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting 7 to 0
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting POLIGONO to 3
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting 8 to 3
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting PARCELA to 506
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting 9 to 506
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting RECINTO to 1
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting 10 to 1
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting PARCELA_AG to null
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting 11 to null
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting CONUSUCOD to null
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting 12 to null
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting CONMODFEC to null
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting 13 to null
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting GEOMETRY to
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting 14 to
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting GRUPO to null
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Setting 15 to null
2011-08-24 13:56:54,714 DEBUG [org.geotools.jdbc] - Getting next FID: SELECT
MAX(GID) + 1 FROM USRCARTO.GT_ARLOGIS_UG_ED50
2011-08-24 13:56:54,714 ERROR [org.geoserver.wfs] - Transaction failed
org.geoserver.wfs.WFSTransactionException: Error performing insert
at
org.geoserver.wfs.InsertElementHandler.execute(InsertElementHandler.java:204)
at org.geoserver.wfs.Transaction.execute(Transaction.java:334)
at org.geoserver.wfs.Transaction.transaction(Transaction.java:109)
at
org.geoserver.wfs.DefaultWebFeatureService.transaction(DefaultWebFeatureService.java:163)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.geoserver.ows.util.EMFLogger.invoke(EMFLogger.java:51)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy19.transaction(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.geoserver.ows.Dispatcher.execute(Dispatcher.java:599)
at
org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:230)
at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:47)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source) Caused by:
java.lang.ClassCastException: java.lang.String cannot be cast to
com.vividsolutions.jts.geom.Geometry
at org.geotools.jdbc.JDBCDataStore.insertSQLPS(JDBCDataStore.java:3350)
at org.geotools.jdbc.JDBCDataStore.insert(JDBCDataStore.java:1240)
at org.geotools.jdbc.JDBCDataStore.insert(JDBCDataStore.java:1207)
at
org.geotools.jdbc.JDBCInsertFeatureWriter.write(JDBCInsertFeatureWriter.java:73)
at
org.geotools.data.InProcessLockingManager$1.write(InProcessLockingManager.java:335)
at
org.geotools.data.store.ContentFeatureStore.addFeatures(ContentFeatureStore.java:255)
at
org.geoserver.feature.retype.RetypingFeatureStore.addFeatures(RetypingFeatureStore.java:87)
at
org.vfny.geoserver.global.GeoServerFeatureStore.addFeatures(GeoServerFeatureStore.java:81)
at
org.geoserver.wfs.InsertElementHandler.execute(InsertElementHandler.java:173)
Fail Transaction request:
<wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs"; service="WFS"
version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.1.0/wfs.xsd http://192.168.3.15/ikt
http://192.168.3.15/geoserver/wfs?request=DescribeFeatureType&version=1.1.0&typename=IKT:UnidadesGestion";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
<wfs:Insert>
<feature:UnidadesGestion xmlns:feature="http://192.168.3.15/ikt";
fid="RecintosSigpac.fid--21720f22_131f62e83e7_5838">
<feature:GEOMETRY>
<gml:Polygon xmlns:gml="http://www.opengis.net/gml"; srsName="EPSG:23030">
<gml:exterior> <gml:LinearRing> <gml:posList>...</gml:posList>
</gml:LinearRing> </gml:exterior> </gml:Polygon> </feature:GEOMETRY>
<feature:CODEX>010130050002</feature:CODEX>
<feature:UG>17</feature:UG>
<feature:TOPONIMO>UG_17</feature:TOPONIMO>
<feature:VERSION>1</feature:VERSION>
<feature:PROVINCIA>1</feature:PROVINCIA>
<feature:MUNICIPIO>13</feature:MUNICIPIO>
<feature:POLIGONO>3</feature:POLIGONO>
<feature:PARCELA>504</feature:PARCELA>
<feature:RECINTO>1</feature:RECINTO>
<feature:AGREGADO>0</feature:AGREGADO>
<feature:ZONA>0</feature:ZONA>
</feature:UnidadesGestion>
</wfs:Insert>
</wfs:Transaction>
Success Transaction request
<wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs";
service="WFS" version="1.1.0"
xsi:schemaLocation="http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.1.0/wfs.xsd
http://192.168.3.15/ikt
http://192.168.3.15/geoserver/wfs?request=DescribeFeatureType&version=1.1.0&typename=IKT:prueba_wfst";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
<wfs:Insert>
<feature:prueba_wfst xmlns:feature="http://192.168.3.15/ikt";
fid="RecintosSigpac.fid--21720f22_131f62e83e7_5a75">
<feature:GEOMETRY>
<gml:Polygon xmlns:gml="http://www.opengis.net/gml"; srsName="EPSG:23030">
<gml:exterior> <gml:LinearRing> <gml:posList>...</gml:posList>
</gml:LinearRing> </gml:exterior> </gml:Polygon> </feature:GEOMETRY>
<feature:GID>3630175</feature:GID>
<feature:PROVINCIA>1</feature:PROVINCIA>
<feature:MUNICIPIO>59</feature:MUNICIPIO>
<feature:POLIGONO>215</feature:POLIGONO>
<feature:PARCELA>153</feature:PARCELA>
<feature:RECINTO>1</feature:RECINTO>
<feature:ELEGIBILID>0</feature:ELEGIBILID>
<feature:COEF_REGAD>0</feature:COEF_REGAD>
<feature:COEF_PASTO>100</feature:COEF_PASTO>
<feature:USO_SIGPAC>TA</feature:USO_SIGPAC>
<feature:USO_2003>TA</feature:USO_2003>
<feature:DN_OID>966</feature:DN_OID>
<feature:DN_SURFACE>78547.42855</feature:DN_SURFACE>
<feature:DN_PERIMET>2516.2231</feature:DN_PERIMET>
<feature:PENDIENTE>89</feature:PENDIENTE>
<feature:FECHA_INI>2011-06-06</feature:FECHA_INI>
</feature:prueba_wfst>
</wfs:Insert>
</wfs:Transaction>
Do you see any difference between the two transactions??
I think I'm missing something in the table configuration but I'm not sure. Any
ideas??
GeoServer instance 2.0.2
DB: Oracle Spatial
OS: Window Server 2003
Thanks in advance.
Regards,
Un saludo,
··················································································
David Alda Fernández de Lezea
Lurralde eta Biodibertsitate Saila / Dpto. de Territorio y Biodiversidad
IKT
Granja Modelo s/n · 01192 · Arkaute (Araba)
··················································································
Tlfnos.: 945-00-32-95 Fax: 945-00.32.90
··················································································
email: [email protected] web: www.ikt.es
··················································································
------------------------------------------------------------------------------
EMC VNX: the world's simplest storage, starting under $10K The only unified
storage solution that offers unified management Up to 160% more powerful than
alternatives and 25% more efficient.
Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
EMC VNX: the world's simplest storage, starting under $10K
The only unified storage solution that offers unified management
Up to 160% more powerful than alternatives and 25% more efficient.
Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
