org.deegree.feature.persistence.simplesql
Class SimpleSQLFeatureStore

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

All Implemented Interfaces:

FeatureStore

public class SimpleSQLFeatureStore
extends java.lang.Object
implements FeatureStore

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

Version:

$Revision: 29485 $, $Date: 2011-01-27 19:06:35 +0100 (Do, 27. Jan 2011) $

Author:

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

See Also:

FeatureStore

Constructor Summary

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

Method Summary

FeatureStoreTransaction	acquireTransaction() Acquires transactional access to the feature store.
void	destroy() Called by the container to indicate that this FeatureStore instance is being taken out of service.
Envelope	getEnvelope(javax.xml.namespace.QName ftName) Returns the envelope for all stored features of the given type.
GenericFeatureType	getFeatureType()
LockManager	getLockManager() Returns the associated LockManager.
GMLObject	getObjectById(java.lang.String id) Retrieves the stored object with a certain id.
ApplicationSchema	getSchema() Returns the application schema that this FeatureStore serves.
CRS	getStorageCRS() Returns the CRS of the geometry column.
void	init() Called by the container to indicate that this FeatureStore instance is being placed into service.
boolean	isAvailable() Returns whether the store is currently able to perform operations.
FeatureResultSet	query(Query query) Performs the given query and returns the matching features as a FeatureResultSet.
FeatureResultSet	query(Query[] queries) Performs the given queries and returns the matching features as a FeatureResultSet.
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(java.lang.String connId,
                             java.lang.String crs,
                             java.lang.String sql,
                             java.lang.String ftLocalName,
                             java.lang.String ftNamespace,
                             java.lang.String ftPrefix,
                             java.lang.String bbox,
                             java.util.List<Pair<java.lang.Integer,java.lang.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: FeatureStore

Called by the container to indicate that this FeatureStore instance is being taken out of service.

Specified by:

destroy in interface FeatureStore

getEnvelope

public Envelope getEnvelope(javax.xml.namespace.QName ftName)

Description copied from interface: FeatureStore

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

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)

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, never null

Throws:

FeatureStoreException - if the FeatureStore does not implement locking

getObjectById

public GMLObject getObjectById(java.lang.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 ApplicationSchema 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()
          throws FeatureStoreException

Description copied from interface: FeatureStore

Called by the container to indicate that this FeatureStore instance is being placed into service.

Specified by:

init in interface FeatureStore

Throws:

FeatureStoreException - if the initialization fails

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 FeatureResultSet query(Query query)
                       throws FeatureStoreException,
                              FilterEvaluationException

Description copied from interface: FeatureStore

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

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 FeatureResultSet query(Query[] queries)
                       throws FeatureStoreException,
                              FilterEvaluationException

Description copied from interface: FeatureStore

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

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

Throws:

FeatureStoreException - if the query could not be performed

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

getStorageCRS

public CRS getStorageCRS()

Returns the CRS of the geometry column.

Returns:

the CRS of the geometry column, never null