Package org.gvsig.fmap.dal.store.jdbc2
Interface JDBCHelper
- All Superinterfaces:
AutoCloseable
- All Known Implementing Classes:
JDBCHelperBase
-
Method Summary
Modifier and TypeMethodDescriptionbooleanIndica si la BBDD soporta valores automaticos, tipo serial.booleanbooleancanWriteGeometry(int geometryType, int geometrySubtype) Indica si podemos escribir el tipo de geometria indicado.org.gvsig.fmap.dal.feature.spi.FeatureProvidercreateFeature(org.gvsig.fmap.dal.feature.FeatureType featureType) org.gvsig.fmap.dal.store.jdbc.JDBCNewStoreParametersorg.gvsig.fmap.dal.store.jdbc.JDBCStoreParametersorg.gvsig.fmap.dal.store.jdbc.JDBCStoreParameterscreateOpenStoreParameters(org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorerParameters serverParameters) createProvider(org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters parameters, org.gvsig.fmap.dal.spi.DataStoreProviderServices providerServices) org.gvsig.fmap.dal.store.jdbc2.JDBCServerExplorercreateServerExplorer(org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorerParameters parameters, org.gvsig.fmap.dal.spi.DataServerExplorerProviderServices providerServices) org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorerParametersDevuelve un SQLBuilder adaptado al proveedor.voiddispose()voidexpandCalculedColumns(JDBCSQLBuilderBase sqlbuilder) voidfetchFeature(org.gvsig.fmap.dal.feature.spi.FeatureProvider feature, ResultSet rs, org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor[] columns, String[] extraValueNames) voidfetchFeature(org.gvsig.fmap.dal.feature.spi.FeatureProvider feature, ResulSetControler.ResultSetEntry rs) org.gvsig.fmap.dal.store.jdbc2.JDBCConnectionorg.gvsig.fmap.dal.store.jdbc.JDBCConnectionParametersorg.gvsig.fmap.dal.store.jdbc2.JDBCConnectionorg.gvsig.fmap.geom.GeometrygetGeometryFromColumn(ResultSet rs, int index) org.gvsig.fmap.geom.GeometrygetGeometryFromColumn(ResulSetControler.ResultSetEntry rs, int index) org.gvsig.fmap.geom.GeometryManagerorg.gvsig.expressionevaluator.GeometryExpressionBuilderHelper.GeometrySupportTypeIndica como deben ser guardadas las geometrias en la BBDD.org.gvsig.fmap.dal.feature.FeatureTypeReturn the name of the driver.Devuelve las comillas que han de usaese para los identificadores.Devuelve las comillas que han de usaese en las constantes de cadena.org.gvsig.fmap.dal.resource.spi.ResourceProvidergetSourceId(org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters parameters) org.gvsig.fmap.dal.spi.DataTransactionServicesbooleanIndica si la BBDD tiene soporte espacial.booleanvoidprocessSpecialFunctions(org.gvsig.fmap.dal.SQLBuilder sqlbuilder, org.gvsig.fmap.dal.feature.FeatureType type, List<String> extra_column_names, org.gvsig.fmap.dal.feature.FeatureQuery query) voidsetProviderFeatureType(org.gvsig.fmap.dal.feature.FeatureType providerFeatureType) voidsetTransaction(org.gvsig.fmap.dal.spi.DataTransactionServices transaction) booleansupportExpression(org.gvsig.fmap.dal.feature.FeatureType type, String sql) booleansupportFilter(org.gvsig.fmap.dal.feature.FeatureType type, org.gvsig.tools.evaluator.Evaluator evaluator) booleanIndica si la BBDD soporta el uso de OFFSET en la sentencia select.booleansupportOrder(org.gvsig.fmap.dal.feature.FeatureType type, org.gvsig.fmap.dal.feature.FeatureQueryOrder order) booleanIndica si se especifico un subquery al abrir el proveedor.Methods inherited from interface java.lang.AutoCloseable
close
-
Method Details
-
getProviderName
String getProviderName()Return the name of the driver. By default rerturn "JDBC".- Returns:
-
getGeometrySupportType
org.gvsig.expressionevaluator.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
String getQuoteForIdentifiers()Devuelve las comillas que han de usaese para los identificadores.- Returns:
-
getQuoteForStrings
String getQuoteForStrings()Devuelve las comillas que han de usaese en las constantes de cadena.- Returns:
-
getProviderFeatureType
org.gvsig.fmap.dal.feature.FeatureType getProviderFeatureType() -
setProviderFeatureType
void setProviderFeatureType(org.gvsig.fmap.dal.feature.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(org.gvsig.fmap.dal.feature.FeatureType type, org.gvsig.tools.evaluator.Evaluator evaluator) -
supportExpression
-
supportOrder
boolean supportOrder(org.gvsig.fmap.dal.feature.FeatureType type, org.gvsig.fmap.dal.feature.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
org.gvsig.fmap.dal.store.jdbc2.JDBCConnection getConnection() throws org.gvsig.fmap.dal.resource.exception.AccessResourceException- Throws:
org.gvsig.fmap.dal.resource.exception.AccessResourceException
-
getConnectionWritable
org.gvsig.fmap.dal.store.jdbc2.JDBCConnection getConnectionWritable() throws org.gvsig.fmap.dal.resource.exception.AccessResourceException- Throws:
org.gvsig.fmap.dal.resource.exception.AccessResourceException
-
getConnectionURL
String getConnectionURL() -
getConnectionParameters
org.gvsig.fmap.dal.store.jdbc.JDBCConnectionParameters getConnectionParameters() -
getGeometryManager
org.gvsig.fmap.geom.GeometryManager getGeometryManager() -
getResulSetControler
ResulSetControler getResulSetControler() -
getSourceId
String getSourceId() -
getResource
org.gvsig.fmap.dal.resource.spi.ResourceProvider getResource() -
dispose
void dispose() -
fetchFeature
void fetchFeature(org.gvsig.fmap.dal.feature.spi.FeatureProvider feature, ResultSet rs, org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor[] columns, String[] extraValueNames) throws org.gvsig.fmap.dal.exception.DataException - Throws:
org.gvsig.fmap.dal.exception.DataException
-
fetchFeature
void fetchFeature(org.gvsig.fmap.dal.feature.spi.FeatureProvider feature, ResulSetControler.ResultSetEntry rs) throws org.gvsig.fmap.dal.exception.DataException - Throws:
org.gvsig.fmap.dal.exception.DataException
-
getGeometryFromColumn
org.gvsig.fmap.geom.Geometry getGeometryFromColumn(ResultSet rs, int index) throws org.gvsig.fmap.dal.exception.DataException - Throws:
org.gvsig.fmap.dal.exception.DataException
-
getGeometryFromColumn
org.gvsig.fmap.geom.Geometry getGeometryFromColumn(ResulSetControler.ResultSetEntry rs, int index) throws org.gvsig.fmap.dal.exception.DataException - Throws:
org.gvsig.fmap.dal.exception.DataException
-
getOperations
OperationsFactory getOperations() -
createFeature
org.gvsig.fmap.dal.feature.spi.FeatureProvider createFeature(org.gvsig.fmap.dal.feature.FeatureType featureType) throws org.gvsig.fmap.dal.exception.DataException - Throws:
org.gvsig.fmap.dal.exception.DataException
-
createProvider
JDBCStoreProvider createProvider(org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters parameters, org.gvsig.fmap.dal.spi.DataStoreProviderServices providerServices) throws org.gvsig.fmap.dal.exception.InitializeException - Throws:
org.gvsig.fmap.dal.exception.InitializeException
-
createServerExplorer
org.gvsig.fmap.dal.store.jdbc2.JDBCServerExplorer createServerExplorer(org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorerParameters parameters, org.gvsig.fmap.dal.spi.DataServerExplorerProviderServices providerServices) throws org.gvsig.fmap.dal.exception.InitializeException - Throws:
org.gvsig.fmap.dal.exception.InitializeException
-
getSRSSolver
SRSSolver getSRSSolver() -
createNewStoreParameters
org.gvsig.fmap.dal.store.jdbc.JDBCNewStoreParameters createNewStoreParameters() -
createOpenStoreParameters
org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters createOpenStoreParameters() -
createOpenStoreParameters
org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters createOpenStoreParameters(org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorerParameters serverParameters) -
createServerExplorerParameters
org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorerParameters createServerExplorerParameters() -
getSourceId
-
isThreadSafe
boolean isThreadSafe() -
processSpecialFunctions
-
setTransaction
void setTransaction(org.gvsig.fmap.dal.spi.DataTransactionServices transaction) -
expandCalculedColumns
-
getConnectionProviderStatus
String getConnectionProviderStatus() -
getTransaction
org.gvsig.fmap.dal.spi.DataTransactionServices getTransaction()
-