Message:
A new issue has been created in JIRA.
---------------------------------------------------------------------
View the issue:
http://jira.codehaus.org/browse/GEOS-276
Here is an overview of the issue:
---------------------------------------------------------------------
Key: GEOS-276
Summary: ArcSDE Delete not working
Type: Bug
Status: Open
Priority: Major
Original Estimate: Unknown
Time Spent: Unknown
Remaining: Unknown
Project: GeoServer
Components:
ArcSDE
Assignee: Chris Holmes
Reporter: Nishma Shukla
Created: Wed, 26 Jan 2005 6:43 PM
Updated: Wed, 26 Jan 2005 6:43 PM
Environment: ArcSDE 8.3
Description:
I am getting an exception when performing a delete on ARCSde Datastore. I am posting the following request
<wfs:Transaction service="WFS" version="1.0.0" xmlns:cdf="http://www.opengis.net/cite/data" xmlns:ogc="http://www.opengis.net/ogc" xmlns:wfs="http://www.opengis.net/wfs" xmlns:land="http://www.oriongis.com/land">
<wfs:Delete typeName="land:SCHEMA1.TABLE1">
<ogc:Filter>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>land.TABLE1ID</ogc:PropertyName>
<ogc:Literal>5000006</ogc:Literal>
</ogc:PropertyIsEqualTo>
</ogc:Filter>
</wfs:Delete>
</wfs:Transaction>
I tried to debug ArcSDEFeatureWriter.java where the error is occurring in remove()method. It is trying to give the where clause as 'FID=SCHEMA.TABLE1.43520' to seDelete.fromTable Operation. I tried using java SDE API for delete using the same where clause and I am getting the same exception message there. However, ESRI MapObjects deleted successfully with the where clause as 'FID=43520'.
I am getting the following exception:
Delete Feature Request
feature type:land:SCHEMA1.TABLE1
filter:[ TABLE1ID = 5000006 ]
release:true
cause: DATABASE LEVEL ERROR OCCURRED.
106453 [FINE] org.geotools.data.arcsde.ArcSDEConnectionPool - trying to release
a seconnection: com.esri.sde.sdk.client.SeConnection@anonymised.com
106453 [FINER] org.geotools.data.arcsde.ArcSDEConnectionPool - used is: [com.es
ri.sde.sdk.client.SeConnection@anonymised.com]
available is [com.esri.sde.sdk.client.SeConnection@anonymised.com]
106500 [FINE] org.geotools.data.arcsde.ArcSDEConnectionPool - com.esri.sde.sdk.
client.SeConnection@anonymised.com, after release used is:
available is [com.esri.sde.sdk.client.SeConnection@anonymised.com, com.esri.sde.sdk.clie
nt.SeConnection@anonymised.com]
106500 [WARNING] org.vfny.geoserver.ServiceException - encountered error: DATAB
ASE LEVEL ERROR OCCURRED.
StackTrace: org.vfny.geoserver.responses.wfs.WfsTransactionException: DATABASE L
EVEL ERROR OCCURRED.
at org.vfny.geoserver.responses.wfs.TransactionResponse.execute(Transact
ionResponse.java:385)
at org.vfny.geoserver.responses.wfs.TransactionResponse.execute(Transact
ionResponse.java:104)
at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService
.java:362)
at org.vfny.geoserver.servlets.AbstractService.doPost(AbstractService.ja
va:300)
at org.vfny.geoserver.servlets.wfs.WfsDispatcher.doResponse(WfsDispatche
r.java:245)
at org.vfny.geoserver.servlets.wfs.WfsDispatcher.doPost(WfsDispatcher.ja
va:134)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:358
)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicati
onHandler.java:294)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:5
67)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1807)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplication
Context.java:525)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1757)
at org.mortbay.http.HttpServer.service(HttpServer.java:879)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:790)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:961)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:807)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:
197)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:276)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:511)
---------------------------------------------------------------------
JIRA INFORMATION:
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