Use name to class mappings before int to class mappings when creating a feature 
type
------------------------------------------------------------------------------------

                 Key: GEOT-3270
                 URL: http://jira.codehaus.org/browse/GEOT-3270
             Project: GeoTools
          Issue Type: Improvement
          Components: data jdbc, data jdbc-ng
    Affects Versions: 2.7-M3
            Reporter: Justin Deoliveira
            Assignee: Justin Deoliveira


I have seen a few users complain recently that sql server (and mysql) are not 
mapping geometry types properly to Geometry in feature types. Looking into the 
issue I have narrowed it down to jdbc driver version. For sql server in early 
versions of the driver the geometry type mapped to LONGVARBINARY. For which 
there is no default mapping in SQLDialect. So the type mapping process falls 
through to checking for a mapping for the "geometry" name and finds one.

However in recent versions of the driver the geometry type gets mapped to 
VARBINARY, for which there is a default integer type mapping, so the process 
never gets to the "geometry" name mapping.

So i am wondering if it makes sense to allow the name mappings to execute 
first. And then fall back to the default integer mappings. It would allow 
dialects to protect themselves for this type of change in a jdbc driver.

However it would be a change in behaviour which i am weary of. I plan to run 
some tests across as different databases but i am curious to know if you guys 
can think of any issues with this change.

-- 
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

        

------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel

Reply via email to