Re: [Geotools-gt2-users] MS SQL Server / JDBC

[Justin D. <jde...@op...>]

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.org
Enterprise support for open source geospatial.