Class OracleSQLBuilder

java.lang.Object

com.vividsolutions.jump.datastore.spatialdatabases.SpatialDatabasesSQLBuilder

com.vividsolutions.jump.datastore.oracle.OracleSQLBuilder

public class OracleSQLBuilder
extends SpatialDatabasesSQLBuilder

Creates SQL query strings for a Spatial database. To be overloaded by classes implementing a spatial database support.

Field Summary

Fields inherited from class SpatialDatabasesSQLBuilder

colNames, dbMetadata, defaultSRID

Constructor Summary

Constructors

Constructor	Description
OracleSQLBuilder(SpatialDatabasesDSMetadata dbMetadata, SpatialReferenceSystemID defaultSRID, String[] colNames)

Method Summary

Modifier and Type	Method	Description
protected String	buildBoxFilter(FilterQuery query)
String	getCheckSQL(DataStoreLayer dsLayer)	Returns the query allowing to test a DataStoreLayer: builds a query with where clause and limit 0 to check where clause.
protected String	getColumnListSpecifier(String[] colNames, String geomColName)	Returns the string representing a SQL column definition.
String	getSQL(FilterQuery query)	Builds a valid SQL spatial query with the given spatial filter.

Methods inherited from class SpatialDatabasesSQLBuilder

getDbMetadata, getSRID

Methods inherited from class Object

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

Constructor Details

OracleSQLBuilder

public OracleSQLBuilder(SpatialDatabasesDSMetadata dbMetadata,
 SpatialReferenceSystemID defaultSRID,
 String[] colNames)

Method Details

getSQL

public String getSQL(FilterQuery query)

Builds a valid SQL spatial query with the given spatial filter.

Overrides:

getSQL in class SpatialDatabasesSQLBuilder

Parameters:

query - a FilterQuery containing a spatial filter

Returns:

a SQL query containing column names and a spatial filter in its where clause

getCheckSQL

public String getCheckSQL(DataStoreLayer dsLayer)

Returns the query allowing to test a DataStoreLayer: builds a query with where clause and limit 0 to check where clause.

Overrides:

getCheckSQL in class SpatialDatabasesSQLBuilder

Parameters:

dsLayer - the @link DataStoreLayer to test

Returns:

a SQL query forced to limit 0 to test the layer source

getColumnListSpecifier

protected String getColumnListSpecifier(String[] colNames,
 String geomColName)

Returns the string representing a SQL column definition. Implementors should take care of column names (case, quotes)

Overrides:

getColumnListSpecifier in class SpatialDatabasesSQLBuilder

Parameters:

colNames - column names

geomColName - name of the geometry column

Returns:

column list formatted to be included in a SQL query

buildBoxFilter

protected String buildBoxFilter(FilterQuery query)

Overrides:

buildBoxFilter in class SpatialDatabasesSQLBuilder