Hey gabriel, jody (and others interested in the arcsde datastore!) I've been working through a local fire here on my end with a partially successful upgrade from sde 9.1 to sde 9.2, and I've run into a few weirdnesses with the latest geoserver 1.6.x (geotools 2.4.x) releases.
1) It seems that SDE-managed rowid column support is missing on the insert code-path again. In 'getInsertableColumnNames()' there's no skipping of the SeRegistration().getRowIdColumnName() so the code happily tries to insert into OBJECTID type columns. This is bad, as it means that anyone using geoserver to edit live ArcSDE instances to which they connect with ArcMAP (most everyone, really) won't be able to do any WFS-T insert-ing on those tables. I put together a quickie patch, but I haven't committed yet as jgarnett advised me that you were doing a back-port of the trunk SDE work to 1.6.x gabriel...is that right? If so, I'd love to help knock it around a bit when you're done. 2) I ran into the connection pool issue that we chatted about today gabriel (see http://jira.codehaus.org/browse/GEOS-1963). I also patched around this by simply commenting out the 'connectionPool.close()' call in ArcSDEDataStore.dispose() Not so much a fix as a hack, but again, I didn't commit...it just gets me up and running locally (sort-of). 3) It seems that ArcSDE 9.2 is very aggressive about using NSTRING where it used to use STRING. I've never seen NSTRING working before, and it appears that you can't 'row.setString()' on a STRING, but instead you have to 'row.setNString()' on an NSTRING. I haven't fixed it yet, but I'll try to look at it later this week. If anyone else has the time to go and do the 3-line fix for that (split the if statement at ArcSDEFeatureWriter.java 642 and call setNString in the right cases) that would be awesome. Otherwise I'll get to it on Friday when I'm back in the office. I'm also going to get a chance to see the new SDE command-queueing stuff in action when I port the GCE stuff to use it on trunk starting on Friday (hopefully). You'll hear more from me on that front soon. thanks all, --saul ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Geotools-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-devel
