2008-06-03 13:38:58,378 DEBUG [geoserver.requests] - First 4 bytes of XML doc are : 3C ('<') 77 ('w') 66 ('f') 73 ('s')
2008-06-03 13:38:58,378 DEBUG [geoserver.requests] - Charset detection phase 1. Inferred encoding: UTF-8
2008-06-03 13:38:58,378 DEBUG [geoserver.requests] - Invalid(?) XML declaration: <wfs:T.
2008-06-03 13:38:58,378 DEBUG [geoserver.requests] - Charset detection phase 2. Charset in XML declaration is `null`.
2008-06-03 13:38:58,379 DEBUG [geoserver.requests] - Trying to create reader basing on existing charset information: `UTF-8`.
2008-06-03 13:38:58,379 DEBUG [geoserver.ows] - Raw XML request starts with: <wfs:Transaction xmlns:wfs="http://www.opengis.net/wfs" xmlns:WHO="http://www.who.int/" version="1.0.0" service="WFS"><wfs:Update typeName="WHO:leishecomp"><wfs:Property><wfs:Name>the_geom</wfs:Name><wfs:Value><gml:Point xmlns:gml="http://www.opengis.net/gml" srsName="EPSG:4326"><gml:coordinates decimal="." cs="," ts=" ">-2.8070856647555713,37.758264405819084</gml:coordinates></gml:Point></wfs:Value></wfs:Property><wfs:Property><wfs:Name>article_ti</wfs:Name><wfs:Value>Epidemiología de las Leishmaniosis cutanea en la provincia de Granada</wfs:Value></wfs:Property><wfs:Property><wfs:Name>subtopic_i</wfs:Name><wfs:Value>5</wfs:Value></wfs:Property><wfs:Property><wfs:Name>isvalidated</wfs:Name><wfs:Value>false</wfs:Value></wfs:Property><ogc:Filter xmlns:ogc="http://www.opengis.net/ogc"><ogc:FeatureId fid="leishecomp.402"/></ogc:Filter></wfs:Update></wfs:Transaction>
2008-06-03 13:38:58,380 DEBUG [data.postgis] - get Feature source called on mm_unosat_flood_extent
2008-06-03 13:38:58,380 DEBUG [data.postgis] - returning pg feature locking
2008-06-03 13:38:58,380 DEBUG [data.postgis] - get Feature source called on admin2_world
2008-06-03 13:38:58,380 DEBUG [data.postgis] - returning pg feature locking
2008-06-03 13:38:58,418 DEBUG [data.postgis] - get Feature source called on Bridges_all_point
2008-06-03 13:38:58,418 DEBUG [data.postgis] - returning pg feature locking
2008-06-03 13:38:58,419 DEBUG [data.postgis] - get Feature source called on v_unit_h
2008-06-03 13:38:58,419 DEBUG [data.postgis] - returning pg feature locking
2008-06-03 13:38:58,419 DEBUG [data.postgis] - get Feature source called on leishecomp
2008-06-03 13:38:58,419 DEBUG [data.postgis] - returning pg feature locking
2008-06-03 13:38:58,419 DEBUG [data.postgis] - get Feature source called on mm_nga_placenames
2008-06-03 13:38:58,419 DEBUG [data.postgis] - returning pg feature locking
2008-06-03 13:38:58,425 DEBUG [data.postgis] - get Feature source called on Roads_polyline
2008-06-03 13:38:58,425 DEBUG [data.postgis] - returning pg feature locking
2008-06-03 13:38:58,425 DEBUG [data.postgis] - get Feature source called on mmr_rdsl2_1m_vmap1_polyline
2008-06-03 13:38:58,425 DEBUG [data.postgis] - returning pg feature locking
2008-06-03 13:38:58,425 DEBUG [data.postgis] - get Feature source called on mm_who_populatedplaces
2008-06-03 13:38:58,425 DEBUG [data.postgis] - returning pg feature locking
2008-06-03 13:38:58,425 DEBUG [data.postgis] - get Feature source called on mmr_polbnda_adm3_mimu_polygon
2008-06-03 13:38:58,425 DEBUG [data.postgis] - returning pg feature locking
2008-06-03 13:38:58,426 DEBUG [data.postgis] - get Feature source called on mm_ppoint
2008-06-03 13:38:58,426 DEBUG [data.postgis] - returning pg feature locking
2008-06-03 13:38:58,426 DEBUG [data.postgis] - get Feature source called on mmr_rdsl_1m_vmap1_polyline
2008-06-03 13:38:58,426 DEBUG [data.postgis] - returning pg feature locking
2008-06-03 13:38:58,426 DEBUG [data.postgis] - get Feature source called on mm_admin1
2008-06-03 13:38:58,426 DEBUG [data.postgis] - returning pg feature locking
2008-06-03 13:38:58,426 DEBUG [data.postgis] - get Feature source called on mm_admin0
2008-06-03 13:38:58,426 DEBUG [data.postgis] - returning pg feature locking
2008-06-03 13:38:58,426 DEBUG [data.postgis] - get Feature source called on admin1_world
2008-06-03 13:38:58,426 DEBUG [data.postgis] - returning pg feature locking
2008-06-03 13:38:58,426 DEBUG [data.postgis] - get Feature source called on mmr_damaged_bridges
2008-06-03 13:38:58,426 DEBUG [data.postgis] - returning pg feature locking
2008-06-03 13:38:58,426 DEBUG [data.postgis] - get Feature source called on mm_admin2
2008-06-03 13:38:58,426 DEBUG [data.postgis] - returning pg feature locking
2008-06-03 13:38:58,427 DEBUG [data.postgis] - get Feature source called on admin_world
2008-06-03 13:38:58,427 DEBUG [data.postgis] - returning pg feature locking
2008-06-03 13:38:58,427 TRACE [geotools.xml] - startElement(http://www.opengis.net/wfs,Transaction,wfs:Transaction
2008-06-03 13:38:58,427 DEBUG [geotools.xml] - parsing schema http://www.opengis.net/wfs
2008-06-03 13:38:58,502 DEBUG [geotools.xml] - schema specified by parser configuration not found, supplementing...
2008-06-03 13:38:58,502 DEBUG [geotools.xml] - returning cached schema for http://www.opengis.net/wfs
2008-06-03 13:38:58,503 TRACE [geotools.xml] - startElement(http://www.opengis.net/wfs,Update,wfs:Update
2008-06-03 13:38:58,503 TRACE [geotools.xml] - startElement(http://www.opengis.net/wfs,Property,wfs:Property
2008-06-03 13:38:58,503 TRACE [geotools.xml] - startElement(http://www.opengis.net/wfs,Name,wfs:Name
2008-06-03 13:38:58,503 TRACE [geotools.xml] - startElement(http://www.opengis.net/wfs,Value,wfs:Value
2008-06-03 13:38:58,504 TRACE [geotools.xml] - startElement(http://www.opengis.net/gml,Point,gml:Point
2008-06-03 13:38:58,504 TRACE [geotools.xml] - startElement(http://www.opengis.net/gml,coordinates,gml:coordinates
2008-06-03 13:38:58,505 TRACE [geotools.xml] - startElement(http://www.opengis.net/wfs,Property,wfs:Property
2008-06-03 13:38:58,505 TRACE [geotools.xml] - startElement(http://www.opengis.net/wfs,Name,wfs:Name
2008-06-03 13:38:58,505 TRACE [geotools.xml] - startElement(http://www.opengis.net/wfs,Value,wfs:Value
2008-06-03 13:38:58,505 TRACE [geotools.xml] - startElement(http://www.opengis.net/wfs,Property,wfs:Property
2008-06-03 13:38:58,505 TRACE [geotools.xml] - startElement(http://www.opengis.net/wfs,Name,wfs:Name
2008-06-03 13:38:58,505 TRACE [geotools.xml] - startElement(http://www.opengis.net/wfs,Value,wfs:Value
2008-06-03 13:38:58,505 TRACE [geotools.xml] - startElement(http://www.opengis.net/wfs,Property,wfs:Property
2008-06-03 13:38:58,506 TRACE [geotools.xml] - startElement(http://www.opengis.net/wfs,Name,wfs:Name
2008-06-03 13:38:58,506 TRACE [geotools.xml] - startElement(http://www.opengis.net/wfs,Value,wfs:Value
2008-06-03 13:38:58,506 TRACE [geotools.xml] - startElement(http://www.opengis.net/ogc,Filter,ogc:Filter
2008-06-03 13:38:58,506 TRACE [geotools.xml] - startElement(http://www.opengis.net/ogc,FeatureId,ogc:FeatureId
2008-06-03 13:38:58,507 DEBUG [geoserver.wfs] - Locating FeatureSource uri:'http://www.who.int/' name:'leishecomp'
2008-06-03 13:38:58,508 DEBUG [data.postgis] - get Feature source called on leishecomp
2008-06-03 13:38:58,508 DEBUG [data.postgis] - returning pg feature locking
2008-06-03 13:38:58,508 DEBUG [geoserver.wfs] - located FeatureType w/ typeRef 'WHOGeodata:leishecomp' and elementName '{http://www.who.int/}leishecomp'
2008-06-03 13:38:58,508 DEBUG [data.postgis] - get Feature source called on leishecomp
2008-06-03 13:38:58,508 DEBUG [data.postgis] - returning pg feature locking
2008-06-03 13:38:58,508 DEBUG [geoserver.wfs] - Transaction Update:net.opengis.wfs.impl.UpdateElementTypeImpl@1f36445 (filter: [ leishecomp.402 ], handle: null, inputFormat: <unset>, srsName: null, typeName: {http://www.who.int/}leishecomp)
2008-06-03 13:38:58,508 DEBUG [geoserver.wfs] - Preprocess to remember modification as a set of fids
2008-06-03 13:38:58,508 TRACE [geotools.core] - condition: Filter.INCLUDE
2008-06-03 13:38:58,508 DEBUG [data.jdbc] - calling sql builder with filter [ leishecomp.402 ]
2008-06-03 13:38:58,509 TRACE [geotools.core] - ENTRY 22
2008-06-03 13:38:58,509 DEBUG [geotools.filter] - Exporting FID=[leishecomp.402]
2008-06-03 13:38:58,509 DEBUG [data.jdbc] - sql is SELECT "gid", "article_ti", "article_ur", "subtopic_i", encode(asBinary(force_2d("the_geom"),'XDR'),'base64'), "isvalidated" FROM "public"."leishecomp" WHERE ("gid" = '402')
2008-06-03 13:38:58,509 DEBUG [data.jdbc] - SELECT "gid", "article_ti", "article_ur", "subtopic_i", encode(asBinary(force_2d("the_geom"),'XDR'),'base64'), "isvalidated" FROM "public"."leishecomp" WHERE ("gid" = '402')
2008-06-03 13:38:58,509 DEBUG [data.jdbc] - About to execute query: SELECT "gid", "article_ti", "article_ur", "subtopic_i", encode(asBinary(force_2d("the_geom"),'XDR'),'base64'), "isvalidated" FROM "public"."leishecomp" WHERE ("gid" = '402')
2008-06-03 13:38:58,510 DEBUG [data.postgis] - asserting filter [ leishecomp.402 ]
2008-06-03 13:38:58,510 DEBUG [data.jdbc] - calling sql builder with filter [ leishecomp.402 ]
2008-06-03 13:38:58,510 TRACE [geotools.core] - ENTRY 22
2008-06-03 13:38:58,510 DEBUG [geotools.filter] - Exporting FID=[leishecomp.402]
2008-06-03 13:38:58,510 DEBUG [data.jdbc] - sql is SELECT "gid", "article_ti", "article_ur", "subtopic_i", encode(asBinary(force_2d("the_geom"),'XDR'),'base64'), "isvalidated" FROM "public"."leishecomp" WHERE ("gid" = '402')
2008-06-03 13:38:58,510 DEBUG [data.jdbc] - SELECT "gid", "article_ti", "article_ur", "subtopic_i", encode(asBinary(force_2d("the_geom"),'XDR'),'base64'), "isvalidated" FROM "public"."leishecomp" WHERE ("gid" = '402')
2008-06-03 13:38:58,510 DEBUG [data.jdbc] - About to execute query: SELECT "gid", "article_ti", "article_ur", "subtopic_i", encode(asBinary(force_2d("the_geom"),'XDR'),'base64'), "isvalidated" FROM "public"."leishecomp" WHERE ("gid" = '402')
2008-06-03 13:38:58,511 TRACE [geotools.core] - ENTRY 22
2008-06-03 13:38:58,511 DEBUG [geotools.filter] - Exporting FID=[leishecomp.402]
2008-06-03 13:38:58,511 DEBUG [data.postgis] - encoded modify is UPDATE "public"."leishecomp" SET "the_geom" = GeometryFromText( ?, 4326), "article_ti" = ?, "subtopic_i" = ?, "isvalidated" = ? WHERE ("gid" = '402');
2008-06-03 13:38:58,511 TRACE [geotools.core] - condition: [ leishecomp.402 ]
2008-06-03 13:38:58,511 TRACE [geotools.core] - condition: 22
2008-06-03 13:38:58,511 TRACE [geotools.core] - ENTRY 22
2008-06-03 13:38:58,512 DEBUG [geotools.filter] - Exporting FID=[leishecomp.402]
2008-06-03 13:38:58,512 DEBUG [data.postgis] - SQL: SELECT AsText(force_2d(Envelope(Extent("the_geom"))))  FROM "public"."leishecomp" WHERE ("gid" = '402')
2008-06-03 13:38:58,513 DEBUG [data.postgis] - returning bounds Env[-2.80708575248718 : -2.8070855140686, 37.7582626342773 : 37.7582664489746]
2008-06-03 13:38:58,514 WARN [data.postgis] - Some sort of database connection error: ERROR: column "subtopic_i" is of type bigint but expression is of type character varying
2008-06-03 13:38:58,514 ERROR [geoserver.wfs] - Transaction failed
org.geoserver.wfs.WFSTransactionException: org.geotools.data.DataSourceException: Some sort of database connection error: ERROR: column "subtopic_i" is of type bigint but expression is of type character varying
	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.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:292)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
	at org.geoserver.wfs.WFSLogger.invoke(WFSLogger.java:44)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
	at $Proxy0.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.security.OperationSecurityInterceptor.invoke(OperationSecurityInterceptor.java:41)
	at org.geoserver.ows.Dispatcher.execute(Dispatcher.java:509)
	at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:188)
	at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)
	at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java: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(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.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(FilterSecurityInterceptor.java:107)
	at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.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(AnonymousProcessingFilter.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(HttpSessionContextIntegrationFilter.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(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	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:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
	at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:852)
	at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:584)
	at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508)
	at java.lang.Thread.run(Thread.java:619)
Caused by: org.geotools.data.DataSourceException: Some sort of database connection error: ERROR: column "subtopic_i" is of type bigint but expression is of type character varying
	at org.geotools.data.postgis.PostgisFeatureStore.modifyFeatures(PostgisFeatureStore.java:497)
	at org.vfny.geoserver.global.GeoServerFeatureStore.modifyFeatures(GeoServerFeatureStore.java:108)
	at org.geoserver.wfs.UpdateElementHandler.execute(UpdateElementHandler.java:227)
	... 66 more
Caused by: org.postgresql.util.PSQLException: ERROR: column "subtopic_i" is of type bigint but expression is of type character varying
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
	at org.geotools.data.postgis.PostgisFeatureStore.modifyFeatures(PostgisFeatureStore.java:478)
	... 68 more
2008-06-03 13:38:58,515 INFO [geoserver.wfs] - 
Request: transaction
	handle = null
	service = WFS
	version = 1.0.0
	baseUrl = http://localhost:8081/geoserver/
	lockId = null
	group = [net.opengis.wfs:update=net.opengis.wfs.impl.UpdateElementTypeImpl@1f36445 (filter: [ leishecomp.402 ], handle: null, inputFormat: <unset>, srsName: null, typeName: {http://www.who.int/}leishecomp)]
	insert = []
	update = [net.opengis.wfs.impl.UpdateElementTypeImpl@1f36445 (filter: [ leishecomp.402 ], handle: null, inputFormat: <unset>, srsName: null, typeName: {http://www.who.int/}leishecomp)]
	delete = []
	native = []
	releaseAction = ALL