Package com.vividsolutions.jump.datastore.h2

Class H2DSConnection

java.lang.Object

com.vividsolutions.jump.datastore.spatialdatabases.SpatialDatabasesDSConnection

com.vividsolutions.jump.datastore.h2.H2DSConnection

All Implemented Interfaces:

DataStoreConnection

public class H2DSConnection
extends SpatialDatabasesDSConnection

Connection to a H2GIS database.

Field Summary

Fields inherited from class com.vividsolutions.jump.datastore.spatialdatabases.SpatialDatabasesDSConnection

connection, dbMetadata

Constructor Summary

Constructors

Constructor	Description
H2DSConnection(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
H2ValueConverterFactory	getValueConverterFactory()

Methods inherited from class com.vividsolutions.jump.datastore.spatialdatabases.SpatialDatabasesDSConnection

close, execute, getCompatibleSchemaSubset, getJdbcConnection, getMetadata, isClosed

Methods inherited from class java.lang.Object

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

Constructor Detail

H2DSConnection

public H2DSConnection(Connection con)

Method Detail

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 Exception occurs while accessing database

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 Exception occurs while accessing database

Exception - if no geometric column is found in the query

getValueConverterFactory

public H2ValueConverterFactory getValueConverterFactory()

Overrides:

getValueConverterFactory in class SpatialDatabasesDSConnection