Can you post in the results of a describe feature type? And of a wfs get
feature from that table?
Could you try to re-insert one of the results you get from a get feature
request back in? To see if it's a mapinfo problem or a problem with all
transactions.
On Thu, Jan 20, 2011 at 4:15 AM, InterRob <[email protected]> wrote:
> Dear list, dear Chris,
>
> Sorry for posting so limited information, as I merely described the usage
> scenario...
>
> Below I pasted the verbose log, starting off with the actual WFS-T-request
> posted by MapInfo (inserting a single feature; column names: "geom",
> "sitename"). Just before the massive stack trace a SELECT-query is posted:
>
> SELECT "idx",encode(asBinary(force_
> 2d("geom"),'XDR'),'base64') as "geom","sitename" FROM "public"."zones"
> WHERE 0 = 1
>
> Something wrong there?
>
> Full log:
>
> 20 Jan 11:08:30 DEBUG [geoserver.ows] - Raw XML request starts with: <?xml
> version="1.0" ?>
> <wfs:Transaction
> version="1.0.0"
> service="WFS"
> xmlns:wfs="http://www.opengis.net/wfs";
> xmlns:MNS="http://dummy.mns.ns.glob";
> xmlns:gml="http://www.opengis.net/gml";
> xmlns:ogc="http://www.opengis.net/ogc";
> xmlns="http://www.opengis.net/wfs";
> xsi:schemaLocation="http://www.opengis.net/wfs ../wfs/1.0.0/WFS-basic.xsd"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
> <wfs:Insert xmlns:wfs="http://www.opengis.net/wfs";><MNS:zones xmlns:MNS="
> http://dummy.mns.ns.glob";><MNS:geom><gml:MultiPolygon xmlns:gml="
> http://www.opengis.net/gml";
> srsName="EPSG:28992"><gml:polygonMember><gml:Polygon><gml:outerBoundaryIs><gml:LinearRing><gml:coordinates>290198.40000000002,434467.90000000002
> 251016,417508.40000000002 279087,382419.79999999999
> 312421.29999999999,405227.40000000002
> 290198.40000000002,434467.90000000002</gml:coordinates></gml:LinearRing></gml:outerBoundaryIs></gml:Polygon></gml:polygonMember></gml:MultiPolygon></MNS:geom><sitename>HAA</sitename></MNS:zones></wfs:Insert></wfs:Transaction>
>
> 20 Jan 11:08:30 INFO [geoserver.wfs] -
> Request: getServiceInfo
> 20 Jan 11:08:30 DEBUG [geotools.xml] - schemaLocation found:
> http://www.opengis.net/wfs ../wfs/1.0.0/WFS-basic.xsd
> 20 Jan 11:08:30 DEBUG [geotools.xml] - Found override for
> http://www.opengis.net/wfs: ../wfs/1.0.0/WFS-basic.xsd ==>
> jar:file:/usr/local/geoserver-2.0.2/webapps/geoserver/WEB-INF/lib/wfs-2.0.2.jar!/org/geoserver/wfs/xml/v1_0_0/WFS-basic.xsd
> 20 Jan 11:08:30 DEBUG [geotools.xml] - Could not find declaration for: {
> http://www.opengis.net/wfs}sitename<http://www.opengis.net/wfs%7Dsitename>.
> Checking if containing type declares a single particle.
> 20 Jan 11:08:30 DEBUG [geotools.xml] - Could not find declaration for: {
> http://www.opengis.net/wfs}sitename<http://www.opengis.net/wfs%7Dsitename>.
> Performing lookup by ignoring namespace
> 20 Jan 11:08:30 DEBUG [geoserver.wfs] - Locating FeatureSource uri:'
> http://dummy.mns.ns.glob' name:'zones'
> 20 Jan 11:08:30 DEBUG [geoserver.wfs] - located FeatureType w/ typeRef
> 'APPEL:zones' and elementName '{http://dummy.mns.ns.glob}zones'
> 20 Jan 11:08:30 DEBUG [geoserver.wfs] - Transasction
> Insert:net.opengis.wfs.impl.InsertElementTypeImpl@174f6ce (feature:
> [SimpleFeatureImpl:zones=[SimpleFeatureImpl.Attribute: geom<geom
> id=fid--38cac012_12da2e59234_-8000>=, SimpleFeatureImpl.Attribute:
> sitename<sitename id=fid--38cac012_12da2e59234_-8000>=HAA]], handle: null,
> idgen: <unset>, inputFormat: <unset>, srsName: null)
> 20 Jan 11:08:30 DEBUG [geoserver.wfs] - Use featureValidation to check
> contents of insert
> 20 Jan 11:08:30 DEBUG [geotools.jdbc] - CREATE CONNECTION
> 20 Jan 11:08:30 TRACE [geotools.core] - ENTRY -12,345
> 20 Jan 11:08:30 DEBUG [geotools.jdbc] - SELECT
> "idx",encode(asBinary(force_2d("geom"),'XDR'),'base64') as "geom","sitename"
> FROM "public"."zones" WHERE 0 = 1
> 20 Jan 11:08:30 INFO [gwc.GWCCleanser] - Deleting GWC cache for MNS:zones
> 20 Jan 11:08:30 DEBUG [geotools.jdbc] - Setting geom to
> 20 Jan 11:08:30 DEBUG [geotools.jdbc] - Setting 0 to
> 20 Jan 11:08:30 DEBUG [geotools.jdbc] - Setting sitename to HAA
> 20 Jan 11:08:30 DEBUG [geotools.jdbc] - Setting 1 to HAA
> 20 Jan 11:08:30 ERROR [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(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> 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 $Proxy17.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:597)
> 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:727)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
> at
> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
> at
> org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
> at
> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
> 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.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
> at
> org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
> at
> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
> at
> org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
> at
> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
> at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:47)
> at
> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
> at
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
> at
> org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
> at
> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
> at
> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)
> at
> org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
> at
> org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206)
> at
> org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
> at
> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
> at org.mortbay.jetty.Server.handle(Server.java:324)
> at
> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
> at
> org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:842)
> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648)
> at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
> at
> org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
> at
> org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)
>
> Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to
> com.vividsolutions.jts.geom.Geometry
> at
> org.geotools.jdbc.JDBCDataStore.insertSQL(JDBCDataStore.java:3245)
> at org.geotools.jdbc.JDBCDataStore.insert(JDBCDataStore.java:1249)
> 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.vfny.geoserver.global.GeoServerFeatureStore.addFeatures(GeoServerFeatureStore.java:81)
> at
> org.geoserver.wfs.InsertElementHandler.execute(InsertElementHandler.java:173)
> ... 69 more
>
> Request: transaction
> handle = null
> service = WFS
> version = 1.0.0
> baseUrl = http://mnsgeo:8080/geoserver/
> providedVersion = null
> lockId = null
> group =
> [wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl@174f6ce (feature:
> [SimpleFeatureImpl:zones=[SimpleFeatureImpl.Attribute: geom<geom
> id=fid--38cac012_12da2e59234_-8000>=, SimpleFeatureImpl.Attribute:
> sitename<sitename id=fid--38cac012_12da2e59234_-8000>=HAA]], handle: null,
> idgen: <unset>, inputFormat: <unset>, srsName: null)]
> insert = [net.opengis.wfs.impl.InsertElementTypeImpl@174f6ce(feature:
> [SimpleFeatureImpl:zones=[SimpleFeatureImpl.Attribute: geom<geom
> id=fid--38cac012_12da2e59234_-8000>=, SimpleFeatureImpl.Attribute:
> sitename<sitename id=fid--38cac012_12da2e59234_-8000>=HAA]], handle: null,
> idgen: <unset>, inputFormat: <unset>, srsName: null)]
> update = []
> delete = []
> native = []
> releaseAction = ALL
>
> Any ideas?
>
> Regards,
> Rob.
>
>
> 2011/1/20 Chris Holmes <[email protected]>
>
>> You're going to need to provide some more info to give anyone the chance
>> to help solve the problem.
>>
>> Can you get what the actual transaction request that MapInfo is sending?
>>
>> Posting the logs with the logging level turned up also may help.
>>
>> Chris
>>
>> On Wed, Jan 19, 2011 at 11:20 AM, InterRob <[email protected]> wrote:
>>
>>> Dear list,
>>>
>>> I have a PostGIS table with just 8 geometries (polygons), each row having
>>> only one data attribute (character(8) ).
>>> Using MapInfo 10.5 as a client, I downloaded these through WFS. Then, I
>>> added one feature by drawing a polygon and assigning some text to the new
>>> records' single attribute.
>>>
>>> To commit the editing to DBMS, I instructed MapInfo to save the table:
>>> MapInfo then generates a transaction request. However, GeoServer fails to
>>> process the transaction, logging a org.geoserver.wfs.WFSTransactionException
>>> ("Error performing insert").
>>>
>>> It is stated that the exception was caused by:
>>> java.lang.ClassCastException: java.lang.String cannot be cast to
>>> com.vividsolutions.jts.geom.Geometry
>>>
>>> I'm running GeoServer 2.0.2.
>>>
>>> What is possibly causing this? Any help or hints are very much
>>> appreciated!
>>>
>>> Regards,
>>>
>>> Rob.
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Protect Your Site and Customers from Malware Attacks
>>> Learn about various malware tactics and how to avoid them. Understand
>>> malware threats, the impact they can have on your business, and how you
>>> can protect your company and customers by using code signing.
>>> http://p.sf.net/sfu/oracle-sfdevnl
>>> _______________________________________________
>>> Geoserver-users mailing list
>>> [email protected]
>>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>>
>>>
>>
>
------------------------------------------------------------------------------
Protect Your Site and Customers from Malware Attacks
Learn about various malware tactics and how to avoid them. Understand
malware threats, the impact they can have on your business, and how you
can protect your company and customers by using code signing.
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
