I’m curious if there is any talk of making a Geoserver connector to SQL Server 2008? If not, what would the process be to develop one?
Thanks,
Roger André
GIS Developer/Analyst
Enterprise Management Solutions
CH2M HILL
1100 112th Avenue NE
Suite 400
Bellevue, WA 98004
Direct 425.233.3042
roger.andre@anonymised.com
Developing People through Challenging Projects
I think there's been a few rumblings of people wanting it, but no one's stepped up. The process isn't super difficult, we've tried to make it easy to develop new formats for GeoServer - you code completely in GeoTools, implementing the DataStore interface. See http://docs.codehaus.org/display/GEOTDOC/DataStore+Developers+Guide for a tutorial. Though it is a bit crufty - Justin's been working on a simplified set of helper classes, which should hopefully be a lot easier to implement. He can probably help get you up to speed on those, I think the one downside is they're only on trunk, and may not so easily backport.
We would be really excited for someone to develop a datastore, and I don't think it should be all that tough since SQL Server implements simple features for sql, and there are a number of other databases that use the same stuff. We could definitely help out with advice and reviews, since it would be a really nice win for the community. Doing a read only one should be quite easy - it gets tricker when you get in to optimizing and doing transactions.
best regards,
Chris
Roger.Andre@anonymised.com wrote:
I'm curious if there is any talk of making a Geoserver connector to SQL Server 2008? If not, what would the process be to develop one?
Thanks,
Roger
--
Roger André
GIS Developer/Analyst
Enterprise Management Solutions
CH2M HILL
1100 112th Avenue NE
Suite 400
Bellevue, WA 98004
Direct 425.233.3042
roger.andre@anonymised.com <mailto:roger.andre@anonymised.com>
Developing People through Challenging Projects
!DSPAM:4005,478f8e99266575409313003!------------------------------------------------------------------------
-------------------------------------------------------------------------
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/!DSPAM:4005,478f8e99266575409313003!
------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users!DSPAM:4005,478f8e99266575409313003!
Hi Roger,
Recently I have working on some experimental jdbc bases datastore stuff
to make it much less work to implement datastores based on relational
databases. I would be excited to try and put it up against SQL Server
and see what happens.
The problem is it is available on latest/development branches of
GeoServer and Geotools. It would be a substantial amount of work to
backport it to GeoServer 1.6.x... I am not sure how much of a show
stopper that would be for you.
One of the really big things that would help is getting a test server.
If we had a server to test against I would be willing to put in some of
my volunteer time to get a datastore up and running.
Some food for thought for you.
-Justin
Chris Holmes wrote:
I think there's been a few rumblings of people wanting it, but no one's
stepped up. The process isn't super difficult, we've tried to make it
easy to develop new formats for GeoServer - you code completely in
GeoTools, implementing the DataStore interface. See
http://docs.codehaus.org/display/GEOTDOC/DataStore+Developers+Guide for
a tutorial. Though it is a bit crufty - Justin's been working on a
simplified set of helper classes, which should hopefully be a lot easier
to implement. He can probably help get you up to speed on those, I
think the one downside is they're only on trunk, and may not so easily
backport.We would be really excited for someone to develop a datastore, and I
don't think it should be all that tough since SQL Server implements
simple features for sql, and there are a number of other databases that
use the same stuff. We could definitely help out with advice and
reviews, since it would be a really nice win for the community. Doing a
read only one should be quite easy - it gets tricker when you get in to
optimizing and doing transactions.best regards,
Chris
Roger.Andre@anonymised.com wrote:
I'm curious if there is any talk of making a Geoserver connector to
SQL Server 2008? If not, what would the process be to develop one?Thanks,
Roger
--
Roger André
GIS Developer/Analyst
Enterprise Management SolutionsCH2M HILL
1100 112th Avenue NE
Suite 400
Bellevue, WA 98004
Direct 425.233.3042
roger.andre@anonymised.com <mailto:roger.andre@anonymised.com>Developing People through Challenging Projects
------------------------------------------------------------------------
-------------------------------------------------------------------------
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/!DSPAM:4005,478f8e99266575409313003!
------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users!DSPAM:4005,478f8e99266575409313003!
!DSPAM:4007,478f96c4281035219720167!
-------------------------------------------------------------------------
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/!DSPAM:4007,478f96c4281035219720167!
------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users!DSPAM:4007,478f96c4281035219720167!
--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org