com.luciad.format.mssql

Database ConnectorsClass TLcdMSSQLModelDescriptor

java.lang.Object

com.luciad.model.TLcdModelDescriptor

com.luciad.model.TLcdFeaturedModelDescriptor

com.luciad.format.database.TLcdDatabaseModelDescriptor

com.luciad.format.mssql.TLcdMSSQLModelDescriptor

All Implemented Interfaces:

ILcdAnnotatedElement, ILcdDatabaseModelDescriptor, com.luciad.internal.format.database.ILinDatabaseModelDescriptor2, ILcdDataModelDescriptor, ILcdModelDescriptor, ILcdFeaturedDescriptor , ILcdFeaturedDescriptorProvider , Serializable, Cloneable

public class TLcdMSSQLModelDescriptor
extends TLcdDatabaseModelDescriptor
implements ILcdDatabaseModelDescriptor

This ILcdDatabaseModelDescriptor describes a layer from a Microsoft SQL database.

For accessing an existing table with geometry, the following information is required:

• a database driver,
• a database URL,
• connection properties,
• a table name,
• a column name containing the geometries,
• a display names,
• an optional list of feature names,
• an optional selection filter, with additional selection tables.

For creating a new table with geometry, the following additional information is required:

• a Spatial Reference ID,
• an ellipsoid,
• a list of data types corresponding to the optional feature names.

Since:

2012.1

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
static String	GEOGRAPHY_TYPE The geodetic spatial type in MSSQL.
static String	GEOMETRY_TYPE The generic spatial type in MSSQL.
static String	TYPE_NAME The extension of MSSQL properties files.

Fields inherited from class com.luciad.format.database.TLcdDatabaseModelDescriptor

fConnection

Fields inherited from class com.luciad.model.TLcdFeaturedModelDescriptor

fFeatureClasses, fFeatureNames

Constructor Summary

Constructors

Constructor and Description
TLcdMSSQLModelDescriptor() Constructs an uninitialized MSSQL layer descriptor with default properties.
TLcdMSSQLModelDescriptor(String aDriver, String aURL, Properties aConnectionProperties, String aTableName, String aGeometryColumnName) Constructs a new MSSQL table descriptor.
TLcdMSSQLModelDescriptor(String aDriver, String aURL, Properties aConnectionProperties, String aTableName, String aGeometryColumnName, String[] aFeatureNames, int aPrimaryFeatureIndex) Constructs a new MSSQL table descriptor.
TLcdMSSQLModelDescriptor(String aDriver, String aURL, Properties aConnectionProperties, String aTableName, String aGeometryColumnName, String[] aFeatureNames, int aPrimaryFeatureIndex, boolean aPrimaryFeatureAutoGenerated) Constructs a new MSSQL table descriptor.

Method Summary

Methods inherited from class com.luciad.format.database.TLcdDatabaseModelDescriptor

addAnnotation, clone, close, getAnnotation, getAnnotations, getBounds, getColumnNames, getColumnNames, getColumnNamesAndTypes, getColumnNamesAndTypes, getConnection, getConnectionProperties, getDataModel, getDriver, getEllipsoid, getFeatureDisplayName, getFeatureType, getGeometryColumnName, getGeometryQueryColumnName, getGeometryType, getModelElementType, getModelElementTypes, getModelTypes, getPrimaryFeatureIndex, getSelectionFilter, getSelectionTables, getSRID, getTableName, getURL, isAlwaysCloseConnection, isAnnotationPresent, isPrimaryFeatureAutoGenerated, removeAnnotation, setAlwaysCloseConnection, setBounds, setConnectionProperties, setDriver, setEllipsoid, setFeatureClasses, setFeatureDisplayNames, setFeatureNames, setFeatureTypes, setGeometryColumnName, setGeometryQueryColumnName, setGeometryType, setPrimaryFeatureAutoGenerated, setPrimaryFeatureIndex, setSelectionFilter, setSelectionTables, setSRID, setTableName, setTypeName, setURL

Methods inherited from class com.luciad.model.TLcdFeaturedModelDescriptor

getFeatureClass, getFeatureCount, getFeaturedDescriptor, getFeatureIndex, getFeatureName

Methods inherited from class com.luciad.model.TLcdModelDescriptor

getDisplayName, getSourceName, getTypeName, setDisplayName, setSourceName, sourceNameToDisplayName

Methods inherited from class java.lang.Object

equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.luciad.format.database.ILcdDatabaseModelDescriptor

clone, close, getBounds, getColumnNames, getColumnNamesAndTypes, getEllipsoid, getFeatureName, getFeatureType, getGeometryColumnName, getGeometryType, getPrimaryFeatureIndex, getSelectionFilter, getSelectionTables, getSRID, getTableName, setBounds, setEllipsoid, setFeatureNames, setFeatureTypes, setGeometryColumnName, setGeometryType, setPrimaryFeatureIndex, setSelectionFilter, setSelectionTables, setSRID, setTableName

Methods inherited from interface com.luciad.model.ILcdDataModelDescriptor

getDataModel, getModelElementTypes, getModelTypes

Methods inherited from interface com.luciad.model.ILcdModelDescriptor

getDisplayName, getSourceName, getTypeName

Methods inherited from interface com.luciad.util.ILcdFeaturedDescriptor

getFeatureClass, getFeatureCount, getFeatureIndex, getFeatureUnitOfMeasure

Methods inherited from interface com.luciad.internal.format.database.ILinDatabaseModelDescriptor2

closeConnection

Field Detail

TYPE_NAME

public static final String TYPE_NAME

The extension of MSSQL properties files.

See Also:

Constant Field Values

GEOMETRY_TYPE

public static final String GEOMETRY_TYPE

The generic spatial type in MSSQL.

See Also:

Constant Field Values

GEOGRAPHY_TYPE

public static final String GEOGRAPHY_TYPE

The geodetic spatial type in MSSQL.

See Also:

Constant Field Values

Constructor Detail

TLcdMSSQLModelDescriptor

public TLcdMSSQLModelDescriptor()

Constructs an uninitialized MSSQL layer descriptor with default properties.

TLcdMSSQLModelDescriptor

public TLcdMSSQLModelDescriptor(String aDriver,
                                String aURL,
                                Properties aConnectionProperties,
                                String aTableName,
                                String aGeometryColumnName)

Constructs a new MSSQL table descriptor.

Parameters:

aDriver - the JDBC driver name.

aURL - the JDBC connection URL.

aConnectionProperties - the connection properties, including 'user' and 'password'.

aTableName - the spatial layer name.

aGeometryColumnName - the name of the column containing spatial objects.

TLcdMSSQLModelDescriptor

public TLcdMSSQLModelDescriptor(String aDriver,
                                String aURL,
                                Properties aConnectionProperties,
                                String aTableName,
                                String aGeometryColumnName,
                                String[] aFeatureNames,
                                int aPrimaryFeatureIndex)

Constructs a new MSSQL table descriptor.

Parameters:

aDriver - the JDBC driver name.

aURL - the JDBC connection URL.

aConnectionProperties - the connection properties, including 'user' and 'password'.

aTableName - the spatial layer name.

aGeometryColumnName - the name of the column containing spatial objects.

aFeatureNames - the column names of the features that should be retrieved.

aPrimaryFeatureIndex - the index of the feature that can be used a a primary key on the spatial table.

TLcdMSSQLModelDescriptor

public TLcdMSSQLModelDescriptor(String aDriver,
                                String aURL,
                                Properties aConnectionProperties,
                                String aTableName,
                                String aGeometryColumnName,
                                String[] aFeatureNames,
                                int aPrimaryFeatureIndex,
                                boolean aPrimaryFeatureAutoGenerated)

Constructs a new MSSQL table descriptor.

Parameters:

aDriver - the JDBC driver name.

aURL - the JDBC connection URL.

aConnectionProperties - the connection properties, including 'user' and 'password'.

aTableName - the spatial layer name.

aGeometryColumnName - the name of the column containing spatial objects.

aFeatureNames - the column names of the features that should be retrieved.

aPrimaryFeatureIndex - the index of the feature that can be used a a primary key on the spatial table.

aPrimaryFeatureAutoGenerated - specifies whether the primary key is automatically generated by the database.