org.gvsig.fmap.dal.store.jdbc2

Interface JDBCHelper

All Superinterfaces:

AutoCloseable

All Known Implementing Classes:

H2SpatialHelper, JDBCHelperBase, PostgreSQLHelper

public interface JDBCHelper
extends AutoCloseable

Method Summary

Modifier and Type	Method and Description
boolean	allowAutomaticValues() Indica si la BBDD soporta valores automaticos, tipo serial.
boolean	canWriteGeometry(int geometryType, int geometrySubtype) Indica si podemos escribir el tipo de geometria indicado.
void	closeConnection(Connection connection)
FeatureProvider	createFeature(FeatureType featureType)
JDBCNewStoreParameters	createNewStoreParameters()
JDBCStoreParameters	createOpenStoreParameters()
JDBCStoreProvider	createProvider(JDBCStoreParameters parameters, DataStoreProviderServices providerServices)
JDBCServerExplorer	createServerExplorer(JDBCServerExplorerParameters parameters, DataServerExplorerProviderServices providerServices)
JDBCServerExplorerParameters	createServerExplorerParameters()
JDBCSQLBuilderBase	createSQLBuilder() Devuelbe un SQLBuilder adaptado al proveedor.
void	dispose()
void	fetchFeature(FeatureProvider feature, ResulSetControler.ResultSetEntry rs)
void	fetchFeature(FeatureProvider feature, ResultSet rs, FeatureAttributeDescriptor[] columns)
Connection	getConnection()
JDBCConnectionParameters	getConnectionParameters()
String	getConnectionURL()
Connection	getConnectionWritable()
String	getDatabaseCodeFromProyection(IProjection proj)
Geometry	getGeometryFromColumn(ResulSetControler.ResultSetEntry rs, int index)
Geometry	getGeometryFromColumn(ResultSet rs, int index)
GeometryManager	getGeometryManager()
ExpressionBuilder.GeometrySupportType	getGeometrySupportType() Indica como deben ser guardadas las geometrias en la BBDD.
OperationsFactory	getOperations()
IProjection	getProjectionFromDatabaseCode(String databaseCode)
IProjection	getProjectionFromSRSId(int srsid) Deprecated. use getProjectionFromDatabaseCode
String	getProviderName() Return the name of the driver.
String	getQuoteForIdentifiers() Devueble las comillas que han de usaese para los identificadores.
String	getQuoteForStrings() Devueble las comillas que han de usaese en las constantes de cadena.
ResourceProvider	getResource()
ResulSetControler	getResulSetControler()
String	getSourceId()
String	getSourceId(JDBCStoreParameters parameters)
int	getSRSCode(IProjection crs) Deprecated. use getDatabaseCodeFromProyection
boolean	hasSpatialFunctions() Indica si la BBDD tiene soporte espacial.
boolean	supportOffsetInSelect() Indica si la BBDD soporta el uso de OFFSET en la sentencia select.
boolean	useSubquery() Indica si se especifico un subquery al abrir el proveedor.

Methods inherited from interface java.lang.AutoCloseable

close

Method Detail

getProviderName

String getProviderName()

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

Returns:

getGeometrySupportType

ExpressionBuilder.GeometrySupportType getGeometrySupportType()

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

Returns:

createSQLBuilder

JDBCSQLBuilderBase createSQLBuilder()

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

Returns:

getQuoteForIdentifiers

String getQuoteForIdentifiers()

Devueble las comillas que han de usaese para los identificadores.

Returns:

getQuoteForStrings

String getQuoteForStrings()

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

Returns:

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:

canWriteGeometry

boolean canWriteGeometry(int geometryType,
                         int geometrySubtype)

Indica si podemos escribir el tipo de geometria indicado.

Parameters:

geometryType -

geometrySubtype -

Returns:

getConnection

Connection getConnection()
                  throws AccessResourceException

Throws:

AccessResourceException

getConnectionWritable

Connection getConnectionWritable()
                          throws AccessResourceException

Throws:

AccessResourceException

getConnectionURL

String getConnectionURL()

getConnectionParameters

JDBCConnectionParameters getConnectionParameters()

closeConnection

void closeConnection(Connection connection)

getGeometryManager

GeometryManager getGeometryManager()

getResulSetControler

ResulSetControler getResulSetControler()

getSourceId

String getSourceId()

getResource

ResourceProvider getResource()

dispose

void dispose()

fetchFeature

void fetchFeature(FeatureProvider feature,
                  ResultSet rs,
                  FeatureAttributeDescriptor[] columns)
           throws DataException

Throws:

DataException

fetchFeature

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

Throws:

DataException

getGeometryFromColumn

Geometry getGeometryFromColumn(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

getDatabaseCodeFromProyection

String getDatabaseCodeFromProyection(IProjection proj)

getProjectionFromDatabaseCode

IProjection getProjectionFromDatabaseCode(String databaseCode)

getSRSCode

int getSRSCode(IProjection crs)

Deprecated. use getDatabaseCodeFromProyection

Parameters:

crs -

Returns:

getProjectionFromSRSId

IProjection getProjectionFromSRSId(int srsid)

Deprecated. use getProjectionFromDatabaseCode

Parameters:

srsid -

Returns:

createNewStoreParameters

JDBCNewStoreParameters createNewStoreParameters()

createOpenStoreParameters

JDBCStoreParameters createOpenStoreParameters()

createServerExplorerParameters

JDBCServerExplorerParameters createServerExplorerParameters()

getSourceId

String getSourceId(JDBCStoreParameters parameters)