On Thu, Jul 7, 2011 at 2:40 PM, Mustafa646 <[email protected]> wrote:
> I have inserted a shapefile into SQL server table and publish it into
> Geoserver. When i make some changes in that table in sql Server (I have
> added 2 new columns in the table), then changes are not reflected to
> Geoserver and therefore i could not see changes to my web page.
>
> Then i go to Geoserver, click on that layer and at the end of that layer, i
> click on "Reload feature type". I load my web page again and i notice that
> changes were reflected on my web page (new columns were visible).
>
> I want to know, is there any way that the changes in table should
> automatically be reflected. I do not want to go to Geoserver and click on
> "Reload feature type" evry time whenever some changes occur in SQL server
> table.
>
> Any good suggestion ?
>
The store itself caches the table structure for performance reasons.
You can automate reloading using rest-config if you want.
Alternatively, I guess with some coding it's possible to modify the store
so that a "development mode" flag is present that makes it
not to cache the sql metadata.
It would become quite a bit slower but may be handy if you change
the table structure often.
Cheers
Andrea
--
-------------------------------------------------------
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf
-------------------------------------------------------
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
