I'am wondering if i need a SQLServerDataStore to connect to MS SQLServer
with Spatial Data or if it is also possible to use the JDBCDatastore to
connect to SQLServer and to get i.e. a Map which is stored on SQL Server.
If so, that would mean i can connect to every Database with JDBC to get
Spatial data. Is that possible ?
Thank you for reply
A Problem was a Risk
View this message in context: http://n2.nabble.com/MS-SQL-Server---JDBC-tp3141709p3141709.html
Sent from the geotools-gt2-users mailing list archive at Nabble.com.
I might not understand your question correctly, but yes, for SQL Server
you need a special kind of datastore, one specific to SQL Server. There
is no generic JDBC datastore which can connect to an arbitrary spatial
database since the spatial functions differ quite a bit across databases.
The JDBC datastore classes have recently been rearchitected as
"jdbc-ng", which uses a dialect system (similar in nature to hibernate)
to isolate those parts which are specific to a particular database.
The part specific to sql server is available here:
Hope that helps.
> I'am wondering if i need a SQLServerDataStore to connect to MS SQLServer
> with Spatial Data or if it is also possible to use the JDBCDatastore to
> connect to SQLServer and to get i.e. a Map which is stored on SQL Server.
> If so, that would mean i can connect to every Database with JDBC to get
> Spatial data. Is that possible ?
> Thank you for reply
> Thank you!
> Alex (cp9)
> A Problem was a Risk
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
Get latest updates about Open Source Projects, Conferences and News.