org.deegree.feature.persistence.simplesql
Class SimpleSQLFeatureStore

java.lang.Object
  org.deegree.feature.persistence.simplesql.SimpleSQLFeatureStore

All Implemented Interfaces:

Resource, FeatureStore

public class SimpleSQLFeatureStore
extends Object
implements FeatureStore

FeatureStore implementation that is backed by an SQL database and configured by providing an SQL statement / an SQL connection.

Version:

$Revision: 32025 $, $Date: 2011-09-27 12:24:23 +0200 (Tue, 27 Sep 2011) $

Author:

Andreas Schmitz, last edited by: $Author: mschneider $

See Also:

FeatureStore

Constructor Summary

SimpleSQLFeatureStore(String connId, String crs, String sql, String ftLocalName, String ftNamespace, String ftPrefix, String bbox, List<Pair<Integer,String>> lods)

Method Summary

FeatureStoreTransaction	acquireTransaction() Acquires transactional access to the feature store.
Envelope	calcEnvelope(QName ftName) Recalculates the envelope for all stored features of the given type.
void	destroy() Usually called by the ResourceManager upon workspace shutdown.
Envelope	getEnvelope(QName ftName) Returns the envelope for all stored features of the given type.
GenericFeatureType	getFeatureType()
LockManager	getLockManager() Returns the associated LockManager.
GMLObject	getObjectById(String id) Retrieves the stored object with a certain id.
AppSchema	getSchema() Returns the application schema that this FeatureStore serves.
ICRS	getStorageCRS() Returns the CRS of the geometry column.
void	init(DeegreeWorkspace workspace) Usually called by the ResourceManager upon workspace startup.
boolean	isAvailable() Returns whether the store is currently able to perform operations.
FeatureInputStream	query(Query query) Performs the given query and returns the matching features as a FeatureInputStream.
FeatureInputStream	query(Query[] queries) Performs the given queries and returns the matching features as a FeatureInputStream.
int	queryHits(Query query) Returns the number of features that are matched by the given query.
int[]	queryHits(Query[] queries) Returns the number of features that are matched by the given queries.

Methods inherited from class java.lang.Object

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

Constructor Detail

SimpleSQLFeatureStore

public SimpleSQLFeatureStore(String connId,
                             String crs,
                             String sql,
                             String ftLocalName,
                             String ftNamespace,
                             String ftPrefix,
                             String bbox,
                             List<Pair<Integer,String>> lods)

Parameters:

connId -

crs -

sql -

ftLocalName -

ftNamespace -

ftPrefix -

bbox -

lods -

Method Detail

acquireTransaction

public FeatureStoreTransaction acquireTransaction()
                                           throws FeatureStoreException

Description copied from interface: FeatureStore

Acquires transactional access to the feature store.

Specified by:

acquireTransaction in interface FeatureStore

Returns:

transaction object that allows to perform transactions operations on the datastore, never null

Throws:

FeatureStoreException - if the transactional access could not be acquired or is not implemented for this FeatureStore

destroy

public void destroy()

Description copied from interface: Resource

Usually called by the ResourceManager upon workspace shutdown.

Specified by:

destroy in interface Resource

getEnvelope

public Envelope getEnvelope(QName ftName)
                     throws FeatureStoreException

Description copied from interface: FeatureStore

Returns the envelope for all stored features of the given type.

NOTE: This method may return incorrect (cached) results. Use FeatureStore.calcEnvelope(QName) to force the recalculation of the Envelope.

Specified by:

getEnvelope in interface FeatureStore

Parameters:

ftName - name of the feature type, must not be null and must be served by this store

Returns:

the envelope (using the storage CRS), or null if the feature type does not have an envelope (no geometry properties or no instances)

Throws:

FeatureStoreException

calcEnvelope

public Envelope calcEnvelope(QName ftName)

Description copied from interface: FeatureStore

Recalculates the envelope for all stored features of the given type.

NOTE: This method may potentially be expensive. Depending on the implementation, it may involve fetching all features of the specified type.

Specified by:

calcEnvelope in interface FeatureStore

Parameters:

ftName - name of the feature type, must not be null and must be served by this store

Returns:

the envelope (using the storage CRS), or null if the feature type does not have an envelope (no geometry properties or no instances)

getLockManager

public LockManager getLockManager()
                           throws FeatureStoreException

Description copied from interface: FeatureStore

Returns the associated LockManager.

Specified by:

getLockManager in interface FeatureStore

Returns:

the associated LockManager instance, or null if the FeatureStore does not implement locking

Throws:

FeatureStoreException - if the lock manager could not be acquired

getObjectById

public GMLObject getObjectById(String id)
                        throws FeatureStoreException

Description copied from interface: FeatureStore

Retrieves the stored object with a certain id.

Specified by:

getObjectById in interface FeatureStore

Parameters:

id - identifier of the object to be retrieved

Returns:

the stored object (currently either a Feature or a Geometry) or null if no object with the given id is known

Throws:

FeatureStoreException - if the query could not be performed

getSchema

public AppSchema getSchema()

Description copied from interface: FeatureStore

Returns the application schema that this FeatureStore serves.

Specified by:

getSchema in interface FeatureStore

Returns:

the served application schema, never null

getFeatureType

public GenericFeatureType getFeatureType()

Returns:

the feature type (it can have only one)

init

public void init(DeegreeWorkspace workspace)
          throws ResourceInitException

Description copied from interface: Resource

Usually called by the ResourceManager upon workspace startup.

Specified by:

init in interface Resource

Parameters:

workspace - the workspace the resource belongs to, may be null

Throws:

ResourceInitException

isAvailable

public boolean isAvailable()

Description copied from interface: FeatureStore

Returns whether the store is currently able to perform operations.

Specified by:

isAvailable in interface FeatureStore

Returns:

true, if the store is functional, false otherwise

query

public FeatureInputStream query(Query query)
                         throws FeatureStoreException,
                                FilterEvaluationException

Description copied from interface: FeatureStore

Performs the given query and returns the matching features as a FeatureInputStream.

Specified by:

query in interface FeatureStore

Parameters:

query - query to be performed, must not be null

Returns:

matching features, never null

Throws:

FeatureStoreException - if the query could not be performed

FilterEvaluationException - if the filter contained in the query could not be evaluated

query

public FeatureInputStream query(Query[] queries)
                         throws FeatureStoreException,
                                FilterEvaluationException

Description copied from interface: FeatureStore

Performs the given queries and returns the matching features as a FeatureInputStream.

Specified by:

query in interface FeatureStore

Parameters:

queries - queries to be performed, must not be null and contain at least one entry

Returns:

matching features, never null

Throws:

FeatureStoreException - if the query could not be performed

FilterEvaluationException - if the filter contained in the query could not be evaluated

queryHits

public int queryHits(Query query)
              throws FeatureStoreException,
                     FilterEvaluationException

Description copied from interface: FeatureStore

Returns the number of features that are matched by the given query.

Specified by:

queryHits in interface FeatureStore

Parameters:

query - query to be performed, must not be null

Returns:

number of matching featuress

Throws:

FeatureStoreException - if the query could not be performed

FilterEvaluationException - if the filter contained in the query could not be evaluated

queryHits

public int[] queryHits(Query[] queries)
                throws FeatureStoreException,
                       FilterEvaluationException

Description copied from interface: FeatureStore

Returns the number of features that are matched by the given queries.

Specified by:

queryHits in interface FeatureStore

Parameters:

queries - queries to be performed, must not be null and contain at least one entry

Returns:

number of matching features, one entry per query

Throws:

FeatureStoreException - if the query could not be performed

FilterEvaluationException - if the filter contained in the query could not be evaluated

getStorageCRS

public ICRS getStorageCRS()

Returns the CRS of the geometry column.

Returns:

the CRS of the geometry column, never null