GeoTools

Support NVARCHAR datatypes in ArcSDE plugin

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 2.3.2, 2.4-M0
  • Fix Version/s: 2.3.3, 2.4.0
  • Component/s: arcsde plugin
  • Labels:
    None

Description

Rajkumar Singh wrote:
For ArcSDE/ArcGIS 9.2, there is an issue with GeoServer (tested with 1.4.1) and the way ArcCatalog 9.2 creates feature classes. ArcCatalog 9.2 creates text fields as NVARCHAR data type and it seems GeoServer does't like this. Trying to setup a new FeatureType results in a java.lang.NullPointerException error message.
The work around is to add
UNICODE_STRING "FALSE"
to the dbtune.sde file and then import the contents of this file into the DBTUNE table using the sdedbtune command. This forces ArcSDE 9.2 to create text field as VARCHAR data type.
Is it possible to have future versions of GeoServer support the NVARCHAR data type?

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Gabriel Roldan added a comment -
Saul wrote:

Gabriel,
 
We support this on gt-trunk (or, as soon as I check it in we do) as well as other N*** types.
 
I'll back-port to 2.3.x too, can you assign that bug to me?
------

sure thing! :)
Show
Gabriel Roldan added a comment - Saul wrote: Gabriel,   We support this on gt-trunk (or, as soon as I check it in we do) as well as other N*** types.   I'll back-port to 2.3.x too, can you assign that bug to me? ------ sure thing! :)
Hide
Permalink
Gabriel Roldan added a comment -
Saul, I guess we're gold wrt this. Can you confirm and close the issue?
Show
Gabriel Roldan added a comment - Saul, I guess we're gold wrt this. Can you confirm and close the issue?
Hide
Permalink
Gabriel Roldan added a comment -
Or rather I'll just close it since I've reported and you resolved? Feel free to reopen if needed.
Show
Gabriel Roldan added a comment - Or rather I'll just close it since I've reported and you resolved? Feel free to reopen if needed.

People

  • Assignee:
    Saul Farber
    Reporter:
    Gabriel Roldan
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: