[Geotools-devel] [jira] Created: (GEOT-463) Update and delete does not work correctly with database

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

Update and delete does not work correctly with database oracle 10g
------------------------------------------------------------------

         Key: GEOT-463
         URL: http://jira.codehaus.org/browse/GEOT-463
     Project: GeoTools
        Type: Bug
  Components: oraclespatial =20
    Versions: 2.0.RC1   =20
 Environment: I used window 2K,java j2sdk1.4.2_05, Tomcat5.0 Pentum IV
    Reporter: LeTrung
 Assigned to: Sean Geoghegan=20
     Fix For: 2.1.RC1

When I post Update transaction to Geoserver to update one or more featureMe=
mber.=20
the systax of transaction Update is:

<wfs:Transaction service=3D"WFS" version=3D"1.0.0"
  xmlns:swm=3D"http://www.spring.com.vn/webmap"
  xmlns:ogc=3D"http://www.opengis.net/ogc"
  xmlns:wfs=3D"http://www.opengis.net/wfs"> =20
  <wfs:Update typeName=3D"swm:HANOI_VILLAGE">
    <wfs:Property>
      <wfs:Name>NAME</wfs:Name>
      <wfs:Value>Trunglc</wfs:Value>
    </wfs:Property>
    <ogc:Filter>
=09<ogc:PropertyIsEqualTo>
      =09    <ogc:PropertyName>MI_PRINX</ogc:PropertyName>
      =09    <ogc:Literal>61011</ogc:Literal>
=09</ogc:PropertyIsEqualTo>    =20
    </ogc:Filter>
  </wfs:Update>
</wfs:Transaction>

this featureMember had exit in database. But the result from geoserver retu=
rn is:

<ServiceExceptionReport version=3D"1.2.0" xsi:schemaLocation=3D"http://www.=
opengis.net/ogc http://trung:81/geoserver/data/capabilities//wfs/1.0.0/OGC-=
exception.xsd">
<ServiceException>
      java.io.IOException: Feature writer already closed  =20
</ServiceException>
</ServiceExceptionReport>

When I see log file of Tomcat. I saw that the querySQL to update database i=
t lost  clause where:

=20
2130781 [FINER] org.geotools.filter.SQLEncoder - exporting SQL ComparisonFi=
lter
 2130796 [FINER] org.geotools.filter.SQLEncoder - Filter type id is 14
 2130796 [FINER] org.geotools.filter.SQLEncoder - Filter type text is =3D
 2130796 [FINER] org.geotools.filter.SQLEncoder - exporting ExpressionAttri=
bute
 2130796 [FINER] org.geotools.filter.SQLEncoder - exporting LiteralExpressi=
on
 2130796 [FINE] org.geotools.data.jdbc.JDBCDataStore - sql is SELECT ID, TY=
PE, NAME, MI_PRINX, GEOLOC FROM HANOI_VILLAGE WHERE "MI_PRINX" =3D 61011
 2130796 [FINE] org.geotools.data.jdbc.JDBCDataStore - About to execure que=
ry: SELECT ID, TYPE, NAME, MI_PRINX, GEOLOC FROM HANOI_VILLAGE WHERE "MI_PR=
INX" =3D 61011
 2130796 [FINE] org.geotools.data.oracle.attributeio.SDOAttributeIO - About=
 to create Geometry convertor for HANOI_VILLAGE.GEOLOC
 2130796 [FINER] org.geotools.data.jdbc.JDBCFeatureWriter - Calling next on=
 writer
 2130796 [FINE] org.geotools.data.jdbc.JDBCFeatureWriter - write called, li=
ve is Feature[ id=3DHANOI_VILLAGE.710087:1028da03274:-7ffd , ID=3D61011 , T=
YPE=3DVillage , NAME=3DNO NAME , MI_PRINX=3D61011 , GEOLOC=3DPOLYGON ((5802=
54.02368315 2332062.97534671, 580289.04378387 2332037.02062971, 580318.8442=
6516 2332017.02469983, 580333.93416022 2332012.00572143, 580336.91091001 23=
31998.07855626, 580326.10060814 2331978.99244118, 580313.97921702 2331972.0=
7384944, 580310.07068683 2331964.08547545, 580298.85633859 2331963.03568913=
, 580266.83772518 2331969.07445996, 580258.92171466 2331974.01345464, 58022=
4.84164018 2331996.97878012, 580206.80797871 2332010.06611623, 580254.02368=
315 2332062.97534671)) ] and cur is Feature[ id=3DHANOI_VILLAGE.710087:1028=
da03274:-7ffd , ID=3D61011 , TYPE=3DVillage , NAME=3DTrunglc , MI_PRINX=3D6=
1011 , GEOLOC=3DPOLYGON ((580254.02368315 2332062.97534671, 580289.04378387=
 2332037.02062971, 580318.84426516 2332017.02469983, 580333.93416022 233201=
2.00572143, 580336.91091001 2331998.07855626, 580326.10060814 2331978.99244=
118, 580313.97921702 2331972.07384944, 580310.07068683 2331964.08547545, 58=
0298.85633859 2331963.03568913, 580266.83772518 2331969.07445996, 580258.92=
171466 2331974.01345464, 580224.84164018 2331996.97878012, 580206.80797871 =
2332010.06611623, 580254.02368315 2332062.97534671)) ]
 2130796 [FINE] org.geotools.data.jdbc.JDBCTextFeatureWriter - updating pos=
tgis feature Feature[ id=3DHANOI_VILLAGE.710087:1028da03274:-7ffd , ID=3D61=
011 , TYPE=3DVillage , NAME=3DTrunglc , MI_PRINX=3D61011 , GEOLOC=3DPOLYGON=
 ((580254.02368315 2332062.97534671, 580289.04378387 2332037.02062971, 5803=
18.84426516 2332017.02469983, 580333.93416022 2332012.00572143, 580336.9109=
1001 2331998.07855626, 580326.10060814 2331978.99244118, 580313.97921702 23=
31972.07384944, 580310.07068683 2331964.08547545, 580298.85633859 2331963.0=
3568913, 580266.83772518 2331969.07445996, 580258.92171466 2331974.01345464=
, 580224.84164018 2331996.97878012, 580206.80797871 2332010.06611623, 58025=
4.02368315 2332062.97534671)) ]
 2130796 [INFO] org.geotools.data.jdbc.JDBCTextFeatureWriter - modifying at=
t# 2 to Trunglc
 2130812 [INFO] org.geotools.data.jdbc.JDBCTextFeatureWriter - UPDATE HANOI=
_VILLAGE SET NAME =3D 'Trunglc' WHERE
UPDATE HANOI_VILLAGE SET NAME =3D 'Trunglc' WHERE=20
 2130812 [SEVERE] org.geotools.data.jdbc.JDBCTextFeatureWriter - SQL Except=
ion writing geometry column
 2130812 [WARNING] org.vfny.geoserver.servlets.AbstractService - service ex=
ception while executing request: Lock Id: null
releaseAction: ALL
handle: null
TypeName: swm:HANOI_VILLAGE
handle: null swm:HANOI_VILLAGE 1
ReleaseAll: true
filter: [ MI_PRINX =3D 61011 ]
Property - Name: NAME, Value: Trunglc

cause: java.io.IOException: Feature writer already closed
 2130812 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager=
 - Connection closed - adding to available connections.
 2130812 [WARNING] org.vfny.geoserver.ServiceException - encountered error:=
 java.io.IOException: Feature writer already closed
StackTrace: java.io.IOException: Feature writer already closed
=09at org.geotools.data.jdbc.JDBCFeatureWriter.close(JDBCFeatureWriter.java=
:344)
=09at org.geotools.data.InProcessLockingManager$1.close(InProcessLockingMan=
ager.java:341)
=09at org.geotools.data.jdbc.JDBCFeatureStore.modifyFeatures(JDBCFeatureSto=
re.java:262)
=09at org.geotools.data.jdbc.JDBCFeatureStore.modifyFeatures(JDBCFeatureSto=
re.java:240)
=09at org.geotools.data.jdbc.JDBCFeatureStore.modifyFeatures(JDBCFeatureSto=
re.java:180)
=09at org.vfny.geoserver.global.GeoServerFeatureStore.modifyFeatures(GeoSer=
verFeatureStore.java:122)
=09at org.vfny.geoserver.responses.wfs.TransactionResponse.execute(Transact=
ionResponse.java:475)
=09at org.vfny.geoserver.responses.wfs.TransactionResponse.execute(Transact=
ionResponse.java:104)
=09at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService=
.java:362)
=09at org.vfny.geoserver.servlets.AbstractService.doPost(AbstractService.ja=
va:300)
=09at org.vfny.geoserver.servlets.wfs.WfsDispatcher.doResponse(WfsDispatche=
r.java:231)
=09at org.vfny.geoserver.servlets.wfs.WfsDispatcher.doPost(WfsDispatcher.ja=
va:110)
=09at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
=09at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
=09at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl=
icationFilterChain.java:237)
=09at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF=
ilterChain.java:157)
=09at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV=
alve.java:214)
=09at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv=
eContext.java:104)
=09at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav=
a:520)
=09at org.apache.catalina.core.StandardContextValve.invokeInternal(Standard=
ContextValve.java:198)
=09at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV=
alve.java:152)
=09at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv=
eContext.java:104)
=09at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav=
a:520)
=09at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j=
ava:137)
=09at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv=
eContext.java:104)
=09at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j=
ava:117)
=09at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv=
eContext.java:102)
=09at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav=
a:520)
=09at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal=
ve.java:109)
=09at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv=
eContext.java:104)
=09at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav=
a:520)
=09at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
=09at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:16=
0)
=09at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java=
:793)
=09at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce=
ssConnection(Http11Protocol.java:702)
=09at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java=
:571)
=09at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP=
ool.java:644)
=09at java.lang.Thread.run(Thread.java:534)

Could you help me? I need updateTransaction to update data to MapSVG.
Thanks so muchs!

--=20
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.codehaus.org/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira

[Geotools-devel] [jira] Created: (GEOT-463) Update and delete does not work correctly with database

Toolkit for working with and mapping geospatial data

[Geotools-devel] [jira] Created: (GEOT-463) Update and delete does not work correctly with database oracle 10g