Class PostgisDSConnection

java.lang.Object

com.vividsolutions.jump.datastore.spatialdatabases.SpatialDatabasesDSConnection

com.vividsolutions.jump.datastore.postgis.PostgisDSConnection

All Implemented Interfaces:

DataStoreConnection

public class PostgisDSConnection
extends SpatialDatabasesDSConnection

Author:

nicolas

Field Summary

Fields inherited from class SpatialDatabasesDSConnection

connection, dbMetadata

Constructor Summary

Constructors

Constructor	Description
PostgisDSConnection(Connection con)

Method Summary

Modifier and Type	Method	Description
FeatureInputStream	executeAdhocQuery(AdhocQuery query)	Executes an adhoc query.
FeatureInputStream	executeFilterQuery(FilterQuery query)	Executes a filter query.
SpatialDatabasesSQLBuilder	getSqlBuilder(SpatialReferenceSystemID srid, String[] colNames)	expose sqlbuilder
PostgisValueConverterFactory	getValueConverterFactory()

Methods inherited from class SpatialDatabasesDSConnection

close, execute, getCompatibleSchemaSubset, getJdbcConnection, getMetadata, isClosed

Methods inherited from class Object

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

Constructor Details

PostgisDSConnection

public PostgisDSConnection(Connection con)

Method Details

getSqlBuilder

public SpatialDatabasesSQLBuilder getSqlBuilder(SpatialReferenceSystemID srid,
 String[] colNames)

Description copied from interface: DataStoreConnection

expose sqlbuilder

Specified by:

getSqlBuilder in interface DataStoreConnection

Overrides:

getSqlBuilder in class SpatialDatabasesDSConnection

Parameters:

srid - the SpatialReferenceSystemID

colNames - array of columns to query

Returns:

the SpatialDatabasesSQLBuilder

executeFilterQuery

public FeatureInputStream executeFilterQuery(FilterQuery query)
                                      throws SQLException

Executes a filter query. The SRID is optional for queries - it will be determined automatically from the table metadata if not supplied. 13 dec 2015: query is now tested before execution, to prevent adding an empty layer built from invalid WHERE clause, for instance.

Overrides:

executeFilterQuery in class SpatialDatabasesDSConnection

Parameters:

query - the query to execute

Returns:

the results of the query

Throws:

SQLException - if an SQLException occurs

executeAdhocQuery

public FeatureInputStream executeAdhocQuery(AdhocQuery query)
                                     throws Exception

Executes an adhoc query. The SRID is optional for queries - it will be determined automatically from the table metadata if not supplied.

Overrides:

executeAdhocQuery in class SpatialDatabasesDSConnection

Parameters:

query - the query to execute

Returns:

the results of the query

Throws:

SQLException - if an SQLException occurs

Exception - if no geometric column is found in the query

getValueConverterFactory

public PostgisValueConverterFactory getValueConverterFactory()

Overrides:

getValueConverterFactory in class SpatialDatabasesDSConnection