Class PostGISDataStoreDataSource

java.lang.Object

com.vividsolutions.jump.io.datasource.DataSource

com.vividsolutions.jump.workbench.ui.plugin.datastore.DataStoreQueryDataSource

com.vividsolutions.jump.workbench.ui.plugin.datastore.DataStoreDataSource

org.openjump.core.ui.plugin.datastore.WritableDataStoreDataSource

org.openjump.core.ui.plugin.datastore.postgis2.PostGISDataStoreDataSource

All Implemented Interfaces:

WorkbenchContextReference

public class PostGISDataStoreDataSource
extends WritableDataStoreDataSource

A WritableDataStoreDataSource for PostGIS.

Field Summary

Fields inherited from class WritableDataStoreDataSource

CONVERT_TO_MULTIGEOMETRY_KEY, CREATE_PK, DEFAULT_PK_NAME, evolutions, EXTERNAL_PK_KEY, GEOM_DIM_KEY, LIMITED_TO_VIEW, MANAGE_CONFLICTS, NAN_Z_TO_VALUE_KEY, NARROW_GEOMETRY_TYPE_KEY, NORMALIZED_COLUMN_NAMES, primaryKeyName, schemaName, SRID_KEY, tableName, TX_MANAGER_KEY

Fields inherited from class DataStoreDataSource

CACHING_KEY, context, DATASET_NAME_KEY, GEOMETRY_ATTRIBUTE_NAME_KEY, MAX_FEATURES_KEY, WHERE_CLAUSE_KEY

Fields inherited from class DataStoreQueryDataSource

CONNECTION_DESCRIPTOR_KEY, PATTERN_FENCE, PATTERN_SELECTION, PATTERN_VIEW, PRIMARY_KEY_KEY, SQL_QUERY_KEY

Fields inherited from class DataSource

CHARSET_KEY, COMPRESSED_KEY, COORDINATE_SYSTEM_CODE, COORDINATE_SYSTEM_KEY, COORDINATE_SYSTEM_REGISTRY, FILE_KEY, URI_KEY

Constructor Summary

Constructors

Constructor	Description
PostGISDataStoreDataSource()
PostGISDataStoreDataSource(ConnectionDescriptor connectionDescriptor, String datasetName, String geometryAttributeName, String identifierAttributeName, String txManagerClass, WorkbenchContext context)
PostGISDataStoreDataSource(WorkbenchContext context)

Method Summary

Modifier and Type	Method	Description
protected void	addDBPrimaryKey(SpatialDatabasesDSConnection conn, String primaryKey)	Add an automatically named primary key constraint to the table.
protected void	createAndPopulateTable(SpatialDatabasesDSConnection conn, FeatureCollection fc, int srid, String geometryType, boolean multi, int dim, boolean normalizedColumnNames)	Create and populate a table with features from a dataset.
protected FeatureCollection	createFeatureCollection()
protected void	deleteTableQuery(SpatialDatabasesDSConnection conn)	Execute a query on this connection to DROP this table as well as its reference in the PostGIS's geometry_columns table (PostGIS invalid input: '<' 2).
void	finalizeUpdate(SpatialDatabasesDSConnection conn)	Deprecated.
protected int	getTableSRID(Connection conn, String column)

Methods inherited from class WritableDataStoreDataSource

addCreation, addModification, addSuppression, getConnection, getGeometryDimension, getGeometryType, getIndexedEvolutions, getUncommittedEvolutions, getViewEnvelope, insertStatement, isWritable, removeEvolution, setAttributeValues, setCoordDimension, setLimitedToView, setManageConflicts, setMultiGeometry, setSRID, setTableAlreadyCreated

Methods inherited from class DataStoreDataSource

getWorkbenchContext, setMaxFeature, setWhereClause, setWorkbenchContext

Methods inherited from class DataStoreQueryDataSource

expandQuery

Methods inherited from class DataSource

getProperties, installCoordinateSystem, isDisabled, isReadable, setDisabled, setProperties

Methods inherited from class Object

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

Constructor Details

PostGISDataStoreDataSource

public PostGISDataStoreDataSource()

PostGISDataStoreDataSource

public PostGISDataStoreDataSource(WorkbenchContext context)

PostGISDataStoreDataSource

public PostGISDataStoreDataSource(ConnectionDescriptor connectionDescriptor,
 String datasetName,
 String geometryAttributeName,
 String identifierAttributeName,
 String txManagerClass,
 WorkbenchContext context)

Method Details

finalizeUpdate

@Deprecated
public void finalizeUpdate(SpatialDatabasesDSConnection conn)
                    throws Exception

Deprecated.

After a new postgis table has been create, it is useful to execute a VACUUM ANALYZE in order to update indexes and get a precise estimated_extent.

Specified by:

finalizeUpdate in class WritableDataStoreDataSource

Parameters:

conn - the Connection to use to finalize the update

Throws:

Exception - if an Exception occurs during update finalization

createFeatureCollection

protected FeatureCollection createFeatureCollection()
                                             throws Exception

Overrides:

createFeatureCollection in class DataStoreDataSource

Throws:

Exception

deleteTableQuery

protected void deleteTableQuery(SpatialDatabasesDSConnection conn)
                         throws SQLException

Execute a query on this connection to DROP this table as well as its reference in the PostGIS's geometry_columns table (PostGIS invalid input: '<' 2).

Specified by:

deleteTableQuery in class WritableDataStoreDataSource

Parameters:

conn - connection to use to delete the table

Throws:

SQLException - if the server returns an exception while deleting

createAndPopulateTable

protected void createAndPopulateTable(SpatialDatabasesDSConnection conn,
 FeatureCollection fc,
 int srid,
 String geometryType,
 boolean multi,
 int dim,
 boolean normalizedColumnNames)
                               throws SQLException

Create and populate a table with features from a dataset.

Specified by:

createAndPopulateTable in class WritableDataStoreDataSource

Parameters:

conn - connection to the database

fc - featureCollection to upload to the database

srid - srid of the geometry

geometryType - geometry type

multi - true to force geometry to be a MultiGeometry

dim - geometry dimension

normalizedColumnNames - whether columns names have to be normalized or not

Throws:

SQLException - if an exception occured during the query processing

addDBPrimaryKey

protected void addDBPrimaryKey(SpatialDatabasesDSConnection conn,
 String primaryKey)
                        throws SQLException

Description copied from class: WritableDataStoreDataSource

Add an automatically named primary key constraint to the table.

Specified by:

addDBPrimaryKey in class WritableDataStoreDataSource

Parameters:

conn - the Connection to use to add the Primary Key

primaryKey - the column name for th primary key

Throws:

SQLException - if an exception occurs during primary key addition

getTableSRID

protected int getTableSRID(Connection conn,
 String column)
                    throws SQLException

Specified by:

getTableSRID in class WritableDataStoreDataSource

Throws:

SQLException