TGIS_LayerSqlGmMsSpatialJdbc class

DK11 for Java | tatukgis.jdk.TGIS_LayerSqlGmMsSpatialJdbc | Classes | Constructors | Fields | Methods | Properties

Encapsulation of GeoMedia SQL Server Native Spatial layer via Jdbc.

// Java
public class TGIS_LayerSqlGmMsSpatialJdbc extends TGIS_LayerSqlGmMsSpatialAbstract {
};

// Oxygene
type
  TGIS_LayerSqlGmMsSpatialJdbc = public class( TGIS_LayerSqlGmMsSpatialAbstract )
  end;

→ TGIS_BaseObjectDisposable → TGIS_LayerAbstract → TGIS_Layer → TGIS_LayerVector → TGIS_LayerVectorSqlAbstract → TGIS_LayerSqlGmMsSpatialAbstract

This layer can be opened by opening the file name_of_layer.ttkls or embedding all parameters to Path property as CRLF or '\n' delimited string.

Structure of this file must be:

[TatukGIS Layer]
Storage=GeoMediaMsSpatial
Layer=NAME
Dialect=MSSQL
GeometryColumn=geometry column name
GeometryColumnNative=native geometry column name
GeometryType=geometry|geography - geometry type name
SRID=epsg system reference id
GeometryRelationships=Server|Client - default is Client if parameter omitted
JDBC=JDBC connection string in driver specific format
Driver=JDBC driver class name
User_Name=user name
Password=user password
ReadOnly=True|False
...
Parameters key=value
...

For example:

[TatukGIS Layer]
Storage=GeomediaMsSpatial
LAYER=states
DIALECT=MSSQL
GeometryColumn=geom
GeometryType=geometry
GeometryRelationships=Server
SRID=0
JDBC=jdbc:sqlserver://dbmachine64\SQLEXPRESS;databaseName=gm_test
Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
ENGINEOPTIONS=16
User_Name=test
Password=test

This layer can also be opened by providing SQLParameters property.

OnPassword event will be fired upon connecting to a database to resolve <#user#>, <#password#> or any other <#token#> embedded into connection options.

If you want to create MS SQL Server Spatial Warehouse or import to existing Warehouse, you must ensure that the database and all its objects are owned by <b>dbo</b>. All operations that create database objects will have to be done with a user account having administrative privileges on the database (membership in the <b>sysadmin</b> role eg. <b>sa</b> user). MSSQL Server objects have owners and users. All access is controlled by ownership and the use of permissions. There is another necessary to login with <b>sysadmin</b> role during import for allows multiple users (with varying permissions) accessing to your Warehouse.

During the making new MS SQL Server Warehouse in the beginning all metadata tables will be created in database. So, you don't need to create metadata structure and register features in your database with the Geomedia Database Utilities.

Note :

• Try to use uppercase layer name (in a meaning of Layer=xxxx). Layer name could or could not be case insensitive on different database engines.

• If you check DE9-IM coincidence between geometry objects, you should take into consideration setting of GeometryRelationships. You may decrease the amount of returned rows from server.

• To force reading other geometry columns of a layer the GeometryColumn parameter can be added to a ttkls file :

  [TatukGIS Layer]
  ...
  GeometryColumn=Geometry2