[Geotools-devel] [jira] Created: (GEOT-1790) Update of ArcSDE layers does not work

[Andreas O. (JIRA) <ji...@co...>]

Update of ArcSDE layers does not work
-------------------------------------

                 Key: GEOT-1790
                 URL: http://jira.codehaus.org/browse/GEOT-1790
             Project: GeoTools
          Issue Type: Bug
          Components: data arcsde
    Affects Versions: 2.4.2
         Environment: WIndows 2003 Server SP1  Java 1.6 ArcSDE 9.2 SP5  SQLServer2005 GeoServer 1.6.3
            Reporter: Andreas Oxenstierna
            Assignee: Gabriel Roldán
            Priority: Critical


Attempts to update ArcSDE layers throws ArcSDE error -111 "THIS CONNECTION IS BEING USED AT THE MOMENT BY ANOTHER THREAD." Same error for add (insert), update and delete features. Tested both with versioned and non-versioned ArcSDE layers. For versioned layers, the ArcSDE editing state is left in locked and open status (ArcSDE STATE table not correctly updated), which prevents all ArcSDE updates (from ESRI clients)  until the editing state is changed to closed by manual update of RDBMS table.

Initial part of GeoServer log:
 ArcSDE Error Number        : -111
 Error Description          : THIS CONNECTION IS BEING USED AT THE    MOMENT BY
ANOTHER THREAD.
 Extended Error Description :

com.esri.sde.sdk.client.SeException:
        at com.esri.sde.sdk.client.SeConnection.a(Unknown Source)
        at com.esri.sde.sdk.client.SeConnection.k(Unknown Source)
        at com.esri.sde.sdk.client.SeConnection.u(Unknown Source)
        at com.esri.sde.sdk.client.SeConnection.t(Unknown Source)
        at com.esri.sde.sdk.client.SeLayer.getShapeAttributeName(Unknown Source)

        at org.geotools.arcsde.data.ArcSdeFeatureWriter.getInsertableColumnNames
(ArcSdeFeatureWriter.java:756)
        at org.geotools.arcsde.data.ArcSdeFeatureWriter.insertSeRow(ArcSdeFeatur
eWriter.java:477)
and so on ...


-- 
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
-
For more information on JIRA, see: http://www.atlassian.com/software/jira