Hi Alex,
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.
http://svn.osgeo.org/geotools/branches/2.5.x/modules/unsupported/jdbc-ng/The part specific to sql server is available here:
http://svn.osgeo.org/geotools/branches/2.5.x/modules/unsupported/jdbc-ng/jdbc-sqlserver/Hope that helps.
-Justin
abruch wrote:
> Hi,
>
> 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
>
> Alex
>
> -----
> Thank you!
>
> Alex (cp9)
> --------------------
> A Problem was a Risk
--
Justin Deoliveira
OpenGeo -
http://opengeo.orgEnterprise support for open source geospatial.
------------------------------------------------------------------------------
_______________________________________________
Geotools-gt2-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
