org.gvsig.fmap.dal.store.jdbc2

Interface JDBCHelper

All Superinterfaces:

java.lang.AutoCloseable

All Known Implementing Classes:

H2SpatialHelper, JDBCHelperBase, MDBHelper, PostgreSQLHelper, SQLiteHelper

public interface JDBCHelper
extends java.lang.AutoCloseable

Method Summary

Modifier and Type	Method and Description
boolean	allowAutomaticValues() Indica si la BBDD soporta valores automaticos, tipo serial.
boolean	allowNestedOperations()
boolean	canWriteGeometry(int geometryType, int geometrySubtype) Indica si podemos escribir el tipo de geometria indicado.
FeatureProvider	createFeature(FeatureType featureType)
JDBCNewStoreParameters	createNewStoreParameters()
JDBCStoreParameters	createOpenStoreParameters()
JDBCStoreParameters	createOpenStoreParameters(JDBCServerExplorerParameters serverParameters)
JDBCStoreProvider	createProvider(JDBCStoreParameters parameters, DataStoreProviderServices providerServices)
JDBCServerExplorer	createServerExplorer(JDBCServerExplorerParameters parameters, DataServerExplorerProviderServices providerServices)
JDBCServerExplorerParameters	createServerExplorerParameters()
JDBCSQLBuilderBase	createSQLBuilder() Devuelve un SQLBuilder adaptado al proveedor.
void	dispose()
void	expandCalculedColumns(JDBCSQLBuilderBase sqlbuilder)
void	fetchFeature(FeatureProvider feature, ResulSetControler.ResultSetEntry rs)
void	fetchFeature(FeatureProvider feature, java.sql.ResultSet rs, FeatureAttributeDescriptor[] columns, java.lang.String[] extraValueNames)
JDBCConnection	getConnection()
JDBCConnectionParameters	getConnectionParameters()
java.lang.String	getConnectionProviderStatus()
java.lang.String	getConnectionURL()
JDBCConnection	getConnectionWritable()
Geometry	getGeometryFromColumn(ResulSetControler.ResultSetEntry rs, int index)
Geometry	getGeometryFromColumn(java.sql.ResultSet rs, int index)
GeometryManager	getGeometryManager()
GeometryExpressionBuilderHelper.GeometrySupportType	getGeometrySupportType() Indica como deben ser guardadas las geometrias en la BBDD.
OperationsFactory	getOperations()
FeatureType	getProviderFeatureType()
java.lang.String	getProviderName() Return the name of the driver.
java.lang.String	getQuoteForIdentifiers() Devuelve las comillas que han de usaese para los identificadores.
java.lang.String	getQuoteForStrings() Devuelve las comillas que han de usaese en las constantes de cadena.
ResourceProvider	getResource()
ResulSetControler	getResulSetControler()
java.lang.String	getSourceId()
java.lang.String	getSourceId(JDBCStoreParameters parameters)
SRSSolver	getSRSSolver()
DataTransactionServices	getTransaction()
boolean	hasSpatialFunctions() Indica si la BBDD tiene soporte espacial.
boolean	isThreadSafe()
void	processSpecialFunctions(SQLBuilder sqlbuilder, FeatureType type, java.util.List<java.lang.String> extra_column_names, FeatureQuery query)
void	setProviderFeatureType(FeatureType providerFeatureType)
void	setTransaction(DataTransactionServices transaction)
boolean	supportExpression(FeatureType type, java.lang.String sql)
boolean	supportFilter(FeatureType type, Evaluator evaluator)
boolean	supportOffsetInSelect() Indica si la BBDD soporta el uso de OFFSET en la sentencia select.
boolean	supportOrder(FeatureType type, FeatureQueryOrder order)
boolean	useSubquery() Indica si se especifico un subquery al abrir el proveedor.

Methods inherited from interface java.lang.AutoCloseable

close

Method Detail

getProviderName

java.lang.String getProviderName()

Return the name of the driver. By default rerturn "JDBC".

Returns:

getGeometrySupportType

GeometryExpressionBuilderHelper.GeometrySupportType getGeometrySupportType()

Indica como deben ser guardadas las geometrias en la BBDD. Pueden guardarse en WKT, WKB o EWKB.

Returns:

createSQLBuilder

JDBCSQLBuilderBase createSQLBuilder()

Devuelve un SQLBuilder adaptado al proveedor. Por ejemplo, uno especifico para PostgreSQL, MySQL, Oracle, MSSQLServer...

Returns:

getQuoteForIdentifiers

java.lang.String getQuoteForIdentifiers()

Devuelve las comillas que han de usaese para los identificadores.

Returns:

getQuoteForStrings

java.lang.String getQuoteForStrings()

Devuelve las comillas que han de usaese en las constantes de cadena.

Returns:

getProviderFeatureType

FeatureType getProviderFeatureType()

setProviderFeatureType

void setProviderFeatureType(FeatureType providerFeatureType)

Parameters:

providerFeatureType - the providerFeatureType to set

allowAutomaticValues

boolean allowAutomaticValues()

Indica si la BBDD soporta valores automaticos, tipo serial.

Returns:

supportOffsetInSelect

boolean supportOffsetInSelect()

Indica si la BBDD soporta el uso de OFFSET en la sentencia select.

Returns:

useSubquery

boolean useSubquery()

Indica si se especifico un subquery al abrir el proveedor.

Returns:

hasSpatialFunctions

boolean hasSpatialFunctions()

Indica si la BBDD tiene soporte espacial.

Returns:

supportFilter

boolean supportFilter(FeatureType type,
                      Evaluator evaluator)

supportExpression

boolean supportExpression(FeatureType type,
                          java.lang.String sql)

supportOrder

boolean supportOrder(FeatureType type,
                     FeatureQueryOrder order)

allowNestedOperations

boolean allowNestedOperations()

canWriteGeometry

boolean canWriteGeometry(int geometryType,
                         int geometrySubtype)

Indica si podemos escribir el tipo de geometria indicado.

Parameters:

geometryType -

geometrySubtype -

Returns:

getConnection

JDBCConnection getConnection()
                      throws AccessResourceException

Throws:

AccessResourceException

getConnectionWritable

JDBCConnection getConnectionWritable()
                              throws AccessResourceException

Throws:

AccessResourceException

getConnectionURL

java.lang.String getConnectionURL()

getConnectionParameters

JDBCConnectionParameters getConnectionParameters()

getGeometryManager

GeometryManager getGeometryManager()

getResulSetControler

ResulSetControler getResulSetControler()

getSourceId

java.lang.String getSourceId()

getResource

ResourceProvider getResource()

dispose

void dispose()

fetchFeature

void fetchFeature(FeatureProvider feature,
                  java.sql.ResultSet rs,
                  FeatureAttributeDescriptor[] columns,
                  java.lang.String[] extraValueNames)
           throws DataException

Throws:

DataException

fetchFeature

void fetchFeature(FeatureProvider feature,
                  ResulSetControler.ResultSetEntry rs)
           throws DataException

Throws:

DataException

getGeometryFromColumn

Geometry getGeometryFromColumn(java.sql.ResultSet rs,
                               int index)
                        throws DataException

Throws:

DataException

getGeometryFromColumn

Geometry getGeometryFromColumn(ResulSetControler.ResultSetEntry rs,
                               int index)
                        throws DataException

Throws:

DataException

getOperations

OperationsFactory getOperations()

createFeature

FeatureProvider createFeature(FeatureType featureType)
                       throws DataException

Throws:

DataException

createProvider

JDBCStoreProvider createProvider(JDBCStoreParameters parameters,
                                 DataStoreProviderServices providerServices)
                          throws InitializeException

Throws:

InitializeException

createServerExplorer

JDBCServerExplorer createServerExplorer(JDBCServerExplorerParameters parameters,
                                        DataServerExplorerProviderServices providerServices)
                                 throws InitializeException

Throws:

InitializeException

getSRSSolver

SRSSolver getSRSSolver()

createNewStoreParameters

JDBCNewStoreParameters createNewStoreParameters()

createOpenStoreParameters

JDBCStoreParameters createOpenStoreParameters()

createOpenStoreParameters

JDBCStoreParameters createOpenStoreParameters(JDBCServerExplorerParameters serverParameters)

createServerExplorerParameters

JDBCServerExplorerParameters createServerExplorerParameters()

getSourceId

java.lang.String getSourceId(JDBCStoreParameters parameters)

isThreadSafe

boolean isThreadSafe()

processSpecialFunctions

void processSpecialFunctions(SQLBuilder sqlbuilder,
                             FeatureType type,
                             java.util.List<java.lang.String> extra_column_names,
                             FeatureQuery query)

setTransaction

void setTransaction(DataTransactionServices transaction)

expandCalculedColumns

void expandCalculedColumns(JDBCSQLBuilderBase sqlbuilder)

getConnectionProviderStatus

java.lang.String getConnectionProviderStatus()

getTransaction

DataTransactionServices getTransaction()