I've been having a bit of problems with WFS and the ArcSDE plugin. Has
anyone gotten a WFS Update request to go through geoserver and update an
arcsde database? It seems like the problem is somehow in the ArcSde
plugin. The feature being updated is an int and the one being filtered is a
smallint in an SQL Server database. Geoserver sets these up as both short
and int respectively using the ArcSDE plugin. Can anyone shed any light on
this? I can go debug and potentially fix it if noone has any ideas.
<wfs:Transaction service="WFS" version="1.0.0"
xmlns:ns="http://myns.com";
xmlns:ogc="http://www.opengis.net/ogc";
xmlns:wfs="http://www.opengis.net/wfs";>
<wfs:Update typeName="ns:rooms">
<wfs:Property>
<wfs:Name>COUNT</wfs:Name>
<wfs:Value>5</wfs:Value>
</wfs:Property>
<ogc:Filter>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>ROOM_ID</ogc:PropertyName>
<ogc:Literal>51</ogc:Literal>
</ogc:PropertyIsEqualTo>
</ogc:Filter>
</wfs:Update>
</wfs:Transaction>
08 Feb 12:52:01 ERROR [geoserver.wfs] - Transaction failed
org.geoserver.wfs.WFSTransactionException:
org.geotools.data.DataSourceException: Incorrect ord
er of invocation of the SeRow.set method.
at org.geoserver.wfs.UpdateElementHandler.execute(
UpdateElementHandler.java:261)
at org.geoserver.wfs.Transaction.execute(Transaction.java:328)
at org.geoserver.wfs.Transaction.transaction(Transaction.java:104)
at org.geoserver.wfs.DefaultWebFeatureService.transaction(
DefaultWebFeatureService.java
:156)
at sun.reflect.GeneratedMethodAccessor307.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25
)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(
AopUtils.jav
a:292)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint
(Reflect
iveMethodInvocation.java:155)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed
(ReflectiveMetho
dInvocation.java:122)
at org.geoserver.wfs.WFSLogger.invoke(WFSLogger.java:44)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed
(ReflectiveMetho
dInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(
JdkDynamicAopProxy.java:
174)
at $Proxy64.transaction(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25
)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.geoserver.security.OperationSecurityInterceptor.invoke
(OperationSecurityIntercep
tor.java:41)
at org.geoserver.ows.Dispatcher.execute(Dispatcher.java:495)
at org.geoserver.ows.Dispatcher.handleRequestInternal(
Dispatcher.java:188)
at
org.springframework.web.servlet.mvc.AbstractController.handleRequest
(AbstractControl
ler.java:139)
at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle
(SimpleCont
rollerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(
DispatcherServlet.java:
684)
at org.springframework.web.servlet.DispatcherServlet.doService(
DispatcherServlet.java:6
25)
at org.springframework.web.servlet.FrameworkServlet.processRequest(
FrameworkServlet.jav
a:392)
at org.springframework.web.servlet.FrameworkServlet.doPost(
FrameworkServlet.java:357)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterCh
ain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java
:206)
at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter
(SetCharacterEncodingF
ilter.java:108)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterCh
ain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java
:206)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy
.java:264)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke
(FilterSecurityInter
ceptor.java:107)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter
(FilterSecurityInt
erceptor.java:72)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy
.java:274)
at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter
(ExceptionTranslationFilter.
java:110)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy
.java:274)
at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter
(AnonymousPr
ocessingFilter.java:125)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy
.java:274)
at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter
(BasicProcessingFilter.
java:178)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy
.java:274)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter
(HttpSessionCo
ntextIntegrationFilter.java:229)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
(FilterChainProxy
.java:274)
at org.acegisecurity.util.FilterChainProxy.doFilter(
FilterChainProxy.java:148)
at org.acegisecurity.util.FilterToBeanProxy.doFilter(
FilterToBeanProxy.java:98)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterCh
ain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java
:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(
StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(
ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(
CoyoteAdapter.java:261)
at org.apache.coyote.http11.Http11Processor.process(
Http11Processor.java:844)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process
(Http11Protoc
ol.java:581)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(
JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.geotools.data.DataSourceException: Incorrect order of
invocation of the SeRow.se
t method.
at org.geotools.arcsde.data.ArcSDEFeatureWriter.write(
ArcSDEFeatureWriter.java:320)
at org.geotools.data.AbstractFeatureStore.modifyFeatures(
AbstractFeatureStore.java:156)
at org.geotools.data.AbstractFeatureStore.modifyFeatures(
AbstractFeatureStore.java:98)
at org.vfny.geoserver.global.GeoServerFeatureStore.modifyFeatures
(GeoServerFeatureStore
.java:124)
at org.geoserver.wfs.UpdateElementHandler.execute(
UpdateElementHandler.java:225)
... 59 more
Caused by: com.esri.sde.sdk.client.SeException: Incorrect order of
invocation of the SeRow.set
method.
at com.esri.sde.sdk.client.k.a(Unknown Source)
at com.esri.sde.sdk.client.k.a(Unknown Source)
at com.esri.sde.sdk.client.SeRow.a(Unknown Source)
at com.esri.sde.sdk.client.SeRow.setShort(Unknown Source)
at org.geotools.arcsde.data.ArcSDEFeatureWriter.setRowValue(
ArcSDEFeatureWriter.java:43
9)
at org.geotools.arcsde.data.ArcSDEFeatureWriter.write(
ArcSDEFeatureWriter.java:307)
... 63 more
08 Feb 12:52:01 INFO [geoserver.wfs] -
Request: transaction
handle = null
service = WFS
version = 1.0.0
baseUrl = http://localhost:8084/geoserver/
lockId = null
group = [
net.opengis.wfs:[EMAIL PROTECTED](fil
ter: [ ROOM_ID = 51 ], handle: null, inputFormat: <unset>, srsName: null,
typeName: {http://myns.com}rooms)]
insert = []
update =
[EMAIL PROTECTED](filter: [ ROOM_ID
= 51 ]
, handle: null, inputFormat: <unset>, srsName: null, typeName: {
http://myns.com}rooms)]
delete = []
native = []
releaseAction = ALL
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Geotools-gt2-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
