On Thu, Jan 17, 2013 at 8:58 AM, Sergeant_york <electronicpa...@gmail.com>wrote:
> 1- For empty tables, specific to MSSql server empty tables will give
> exception like "SRID must be between 0 to 99999" which will break
> GeoServer.
> This is serious problem since table can be empty sometimes (because of
> pulling some active records to passive state).
>
SQL Server does not have a notion of "consistent srid" per table, which is
a bit ridiculous.
To avoid this issue GeoServer can use a "geometry_columns" table where you
manually
register the basic information about your table, including the srid and
geometry type,
so that these information may be known also over an empty table (when there
is at
least one record and no geometry_columns table GeoServer gets the first
record
with a non null geometry and assumes all others are similar, which is kinda
lame but
it's as much as we can do with what SQL Server offers).
Unfortunately the above feature (the geometry metadata table) is only part
of "trunk",
what will become 2.3.0 in a couple of months
Cheers
Andrea
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
much more. Get web development skills now with LearnDevNow -
350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122812
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
