TGIS_LayerSqlDb2Jdbc class

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

Layer that can read IBM DB2 Spatial Extender layer via Jdbc.

// Java
public class TGIS_LayerSqlDb2Jdbc extends TGIS_LayerSqlDb2Abstract {
};

// Oxygene
type
  TGIS_LayerSqlDb2Jdbc = public class( TGIS_LayerSqlDb2Abstract )
  end;

→ TGIS_BaseObjectDisposable → TGIS_LayerAbstract → TGIS_Layer → TGIS_LayerVector → TGIS_LayerVectorSqlAbstract → TGIS_LayerSqlDb2Abstract

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=DB2SpatialExtender
Layer=NAME|NAME;SCHEMA|NAME;SCHEMA;CATALOG
Features=TABLE/VIEW NAME; if provided will replace standard features table
Dialect=DB2
ReadOnly=True|False
JDBC=JDBC connection string in driver specific format
Driver=JDBC driver class name
...
Parameters key=value
...

For example:

[TatukGIS Layer]
Storage=DB2SpatialExtender
Layer=Rivers
Dialect=DB2
JDBC=jdbc:db2://<HOST>:<PORT>/<DB>
Driver=COM.ibm.db2.jdbc.app.DB2Driver

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.

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.