SQL Server Plugin

Supports direct access to an SQL Server database.

References:

• http://www.microsoft.com/sqlserver/

• http://jtds.sourceforge.net/

Maven

<dependency>
   <groupId>org.geotools.jdbc</groupId>
   <artifactId>gt-jdbc-sqlserver</artifactId>
   <version>${geotools.version}</version>
 </dependency>

Note that the groupId is org.geotools.jdbc for this and other JDBC plugin modules.

Connection Parameters

Parameter	Description
dbtype	Must be the string sqlserver if using the Microsoft Driver, otherwise use jtds-sqlserver
host	Machine name or IP address to connect to
port	Port number to connect to
instance	Instance of Database to use (instead of port when multiple DB services are running)
schema	The database schema to access
database	The database to connect to
user	User name
passwd	Password

Access

Example use:

java.util.Map params = new java.util.HashMap();
params.put( "dbtype", "sqlserver");
params.put( "host", "localhost");
params.put( "port", 4866);
params.put( "user", "geotools");
params.put( "passwd", "geotools");

DataStore dataStore=DataStoreFinder.getDataStore(params);

Setup

Since GeoTools version 14 this module is compiled using the JTDS driver. The driver is still available, but in the meantime Microsoft released an open source version, while JTDS went unsupported. We recomment using the Microsoft JDBC driver, while the JTDS based data store factory is left for backwards compatibility. In either case, you don’t have to do anything, both drivers are automatically downloaded by Maven (you might want to exclude one to reduce size).