org.gvsig.fmap.dal.store.mdb

Class MDBHelper

java.lang.Object

org.gvsig.tools.dispose.impl.AbstractDisposable

org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

org.gvsig.fmap.dal.store.mdb.MDBHelper

All Implemented Interfaces:

java.lang.AutoCloseable, ResourceConsumer, JDBCHelper, Disposable

public class MDBHelper
extends JDBCHelperBase

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	MDBHelper.ConnectionProviderImpl

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	MDB_JDBC_DRIVER

Fields inherited from class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

operationsFactory, providerFeatureType, srssolver, transactionsHelper

Constructor Summary

Constructors

Constructor and Description
MDBHelper(JDBCConnectionParameters connectionParameters)
MDBHelper(JDBCConnectionParameters connectionParameters, ConnectionProvider connectionProvider) Constructor for use only for testing purposes.

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.
JDBCNewStoreParameters	createNewStoreParameters()
JDBCStoreParameters	createOpenStoreParameters()
JDBCServerExplorer	createServerExplorer(JDBCServerExplorerParameters parameters, DataServerExplorerProviderServices providerServices)
JDBCServerExplorerParameters	createServerExplorerParameters()
JDBCSQLBuilderBase	createSQLBuilder() Devuelve un SQLBuilder adaptado al proveedor.
JDBCConnection	getConnection()
MDBConnectionParameters	getConnectionParameters()
java.lang.String	getConnectionURL()
static java.lang.String	getConnectionURL(MDBConnectionParameters params)
Geometry	getGeometryFromColumn(java.sql.ResultSet rs, int index)
GeometryExpressionBuilderHelper.GeometrySupportType	getGeometrySupportType() Indica como deben ser guardadas las geometrias en la BBDD.
OperationsFactory	getOperations()
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.
protected java.lang.String	getResourceType()
java.lang.String	getSourceId(JDBCStoreParameters parameters)
boolean	hasSpatialFunctions() Indica si la BBDD tiene soporte espacial.
boolean	supportOffsetInSelect() Indica si la BBDD soporta el uso de OFFSET en la sentencia select.

Methods inherited from class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

addTableToColumnReferences, addTableToColumnReferencesInSingleSelect, allowNestedOperations, close, closeResourceRequested, createFeature, createOpenStoreParameters, createProvider, doDispose, expandCalculedColumns, fetchFeature, fetchFeature, getConnectionProvider, getConnectionProviderKey, getConnectionProviderStatus, getConnectionWritable, getGeometryFromColumn, getGeometryManager, getProviderFeatureType, getResource, getResulSetControler, getSourceId, getSRSSolver, getTableAndFeatureType, getTransaction, initialize, initializeResource, isClosed, isThreadSafe, processSpecialFunctions, replaceExistsFunction, replaceForeingValueFunction, resourceChanged, setProviderFeatureType, setTransaction, supportCaller, supportExpression, supportFilter, supportOrder, toString, useSubquery

Methods inherited from class org.gvsig.tools.dispose.impl.AbstractDisposable

dispose, dispose

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

dispose

Field Detail

MDB_JDBC_DRIVER

public static final java.lang.String MDB_JDBC_DRIVER

See Also:

Constant Field Values

Constructor Detail

MDBHelper

public MDBHelper(JDBCConnectionParameters connectionParameters,
                 ConnectionProvider connectionProvider)

Constructor for use only for testing purposes.

Parameters:

connectionParameters -

connectionProvider -

MDBHelper

public MDBHelper(JDBCConnectionParameters connectionParameters)

Method Detail

getConnectionURL

public static java.lang.String getConnectionURL(MDBConnectionParameters params)

getConnection

public JDBCConnection getConnection()
                             throws AccessResourceException

Specified by:

getConnection in interface JDBCHelper

Overrides:

getConnection in class JDBCHelperBase

Throws:

AccessResourceException

getConnectionParameters

public MDBConnectionParameters getConnectionParameters()

Specified by:

getConnectionParameters in interface JDBCHelper

Overrides:

getConnectionParameters in class JDBCHelperBase

getConnectionURL

public java.lang.String getConnectionURL()

Specified by:

getConnectionURL in interface JDBCHelper

Overrides:

getConnectionURL in class JDBCHelperBase

getResourceType

protected java.lang.String getResourceType()

Overrides:

getResourceType in class JDBCHelperBase

getProviderName

public java.lang.String getProviderName()

Description copied from interface: JDBCHelper

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

Specified by:

getProviderName in interface JDBCHelper

Overrides:

getProviderName in class JDBCHelperBase

Returns:

createSQLBuilder

public JDBCSQLBuilderBase createSQLBuilder()

Description copied from interface: JDBCHelper

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

Specified by:

createSQLBuilder in interface JDBCHelper

Overrides:

createSQLBuilder in class JDBCHelperBase

Returns:

getOperations

public OperationsFactory getOperations()

Specified by:

getOperations in interface JDBCHelper

Overrides:

getOperations in class JDBCHelperBase

getGeometrySupportType

public GeometryExpressionBuilderHelper.GeometrySupportType getGeometrySupportType()

Description copied from interface: JDBCHelper

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

Specified by:

getGeometrySupportType in interface JDBCHelper

Overrides:

getGeometrySupportType in class JDBCHelperBase

Returns:

hasSpatialFunctions

public boolean hasSpatialFunctions()

Description copied from interface: JDBCHelper

Indica si la BBDD tiene soporte espacial.

Specified by:

hasSpatialFunctions in interface JDBCHelper

Overrides:

hasSpatialFunctions in class JDBCHelperBase

Returns:

canWriteGeometry

public boolean canWriteGeometry(int geometryType,
                                int geometrySubtype)

Description copied from interface: JDBCHelper

Indica si podemos escribir el tipo de geometria indicado.

Specified by:

canWriteGeometry in interface JDBCHelper

Overrides:

canWriteGeometry in class JDBCHelperBase

Returns:

getQuoteForIdentifiers

public java.lang.String getQuoteForIdentifiers()

Description copied from interface: JDBCHelper

Devuelve las comillas que han de usaese para los identificadores.

Specified by:

getQuoteForIdentifiers in interface JDBCHelper

Overrides:

getQuoteForIdentifiers in class JDBCHelperBase

Returns:

allowAutomaticValues

public boolean allowAutomaticValues()

Description copied from interface: JDBCHelper

Indica si la BBDD soporta valores automaticos, tipo serial.

Specified by:

allowAutomaticValues in interface JDBCHelper

Overrides:

allowAutomaticValues in class JDBCHelperBase

Returns:

supportOffsetInSelect

public boolean supportOffsetInSelect()

Description copied from interface: JDBCHelper

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

Specified by:

supportOffsetInSelect in interface JDBCHelper

Overrides:

supportOffsetInSelect in class JDBCHelperBase

Returns:

getQuoteForStrings

public java.lang.String getQuoteForStrings()

Description copied from interface: JDBCHelper

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

Specified by:

getQuoteForStrings in interface JDBCHelper

Overrides:

getQuoteForStrings in class JDBCHelperBase

Returns:

getSourceId

public java.lang.String getSourceId(JDBCStoreParameters parameters)

Specified by:

getSourceId in interface JDBCHelper

Overrides:

getSourceId in class JDBCHelperBase

createNewStoreParameters

public JDBCNewStoreParameters createNewStoreParameters()

Specified by:

createNewStoreParameters in interface JDBCHelper

Overrides:

createNewStoreParameters in class JDBCHelperBase

createOpenStoreParameters

public JDBCStoreParameters createOpenStoreParameters()

Specified by:

createOpenStoreParameters in interface JDBCHelper

Overrides:

createOpenStoreParameters in class JDBCHelperBase

createServerExplorerParameters

public JDBCServerExplorerParameters createServerExplorerParameters()

Specified by:

createServerExplorerParameters in interface JDBCHelper

Overrides:

createServerExplorerParameters in class JDBCHelperBase

createServerExplorer

public JDBCServerExplorer createServerExplorer(JDBCServerExplorerParameters parameters,
                                               DataServerExplorerProviderServices providerServices)
                                        throws InitializeException

Specified by:

createServerExplorer in interface JDBCHelper

Overrides:

createServerExplorer in class JDBCHelperBase

Throws:

InitializeException

getGeometryFromColumn

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

Specified by:

getGeometryFromColumn in interface JDBCHelper

Overrides:

getGeometryFromColumn in class JDBCHelperBase

Throws:

DataException