[Geoserver-devel] [jira] Created: (GEOS-276) ArcSDE Delete not working

[<ji...@co...>]

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@1bbdd48
 106453 [FINER] org.geotools.data.arcsde.ArcSDEConnectionPool - used is: [com.es
ri.sde.sdk.client.SeConnection@1bbdd48]
available is [com.esri.sde.sdk.client.SeConnection@dc1f04]
 106500 [FINE] org.geotools.data.arcsde.ArcSDEConnectionPool - com.esri.sde.sdk.
client.SeConnection@1bbdd48freed, after release used is: []
available is [com.esri.sde.sdk.client.SeConnection@dc1f04, com.esri.sde.sdk.clie
nt.SeConnection@1bbdd48]
 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