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

Class JDBCHelperBase

java.lang.Object

org.gvsig.tools.dispose.impl.AbstractDisposable

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

All Implemented Interfaces:

AutoCloseable, ResourceConsumer, JDBCHelper, Disposable

Direct Known Subclasses:

H2SpatialHelper, PostgreSQLHelper

public class JDBCHelperBase
extends AbstractDisposable
implements ResourceConsumer, JDBCHelper

Field Summary

Fields

Modifier and Type	Field and Description
protected OperationsFactory	operationsFactory
protected JDBCSRSs	srss

Constructor Summary

Constructors

Constructor and Description
JDBCHelperBase(JDBCConnectionParameters connectionParameters)

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	close()
void	closeConnection(Connection connection)
boolean	closeResourceRequested(ResourceProvider resource)
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.
protected void	doDispose() Internal implementation for the AbstractDisposable.dispose() method, to be implemented by child classes.
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)
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.
JDBCResource	getResource()
protected String	getResourceType()
ResulSetControler	getResulSetControler()
String	getSourceId()
String	getSourceId(JDBCStoreParameters parameters)
int	getSRSCode(IProjection crs)
boolean	hasSpatialFunctions() Indica si la BBDD tiene soporte espacial.
protected void	initialize(ResourceConsumer helperClient, JDBCConnectionParameters connectionParameters, JDBCStoreProvider store)
protected void	initializeResource(JDBCConnectionParameters params)
void	resourceChanged(ResourceProvider resource)
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 class org.gvsig.tools.dispose.impl.AbstractDisposable

dispose, dispose

Methods inherited from class java.lang.Object

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

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

dispose

Field Detail

operationsFactory

protected OperationsFactory operationsFactory

srss

protected JDBCSRSs srss

Constructor Detail

JDBCHelperBase

public JDBCHelperBase(JDBCConnectionParameters connectionParameters)

Method Detail

initialize

protected void initialize(ResourceConsumer helperClient,
                          JDBCConnectionParameters connectionParameters,
                          JDBCStoreProvider store)

getResourceType

protected String getResourceType()

getProviderName

public String getProviderName()

Description copied from interface: JDBCHelper

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

Specified by:

getProviderName in interface JDBCHelper

Returns:

getGeometrySupportType

public ExpressionBuilder.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

Returns:

hasSpatialFunctions

public boolean hasSpatialFunctions()

Description copied from interface: JDBCHelper

Indica si la BBDD tiene soporte espacial.

Specified by:

hasSpatialFunctions in interface JDBCHelper

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

Returns:

createSQLBuilder

public JDBCSQLBuilderBase createSQLBuilder()

Description copied from interface: JDBCHelper

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

Specified by:

createSQLBuilder in interface JDBCHelper

Returns:

getQuoteForIdentifiers

public String getQuoteForIdentifiers()

Description copied from interface: JDBCHelper

Devueble las comillas que han de usaese para los identificadores.

Specified by:

getQuoteForIdentifiers in interface JDBCHelper

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

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

Returns:

getQuoteForStrings

public String getQuoteForStrings()

Description copied from interface: JDBCHelper

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

Specified by:

getQuoteForStrings in interface JDBCHelper

Returns:

getOperations

public OperationsFactory getOperations()

Specified by:

getOperations in interface JDBCHelper

initializeResource

protected void initializeResource(JDBCConnectionParameters params)

getSourceId

public String getSourceId()

Specified by:

getSourceId in interface JDBCHelper

getResource

public JDBCResource getResource()

Specified by:

getResource in interface JDBCHelper

getConnection

public Connection getConnection()
                         throws AccessResourceException

Specified by:

getConnection in interface JDBCHelper

Throws:

AccessResourceException

getConnectionWritable

public Connection getConnectionWritable()
                                 throws AccessResourceException

Specified by:

getConnectionWritable in interface JDBCHelper

Throws:

AccessResourceException

getConnectionURL

public String getConnectionURL()

Specified by:

getConnectionURL in interface JDBCHelper

getConnectionParameters

public JDBCConnectionParameters getConnectionParameters()

Specified by:

getConnectionParameters in interface JDBCHelper

closeConnection

public void closeConnection(Connection connection)

Specified by:

closeConnection in interface JDBCHelper

doDispose

protected void doDispose()
                  throws BaseException

Description copied from class: AbstractDisposable

Internal implementation for the AbstractDisposable.dispose() method, to be implemented by child classes.

Specified by:

doDispose in class AbstractDisposable

Throws:

BaseException

See Also:

AbstractDisposable.dispose()

close

public void close()
           throws Exception

Specified by:

close in interface AutoCloseable

Throws:

Exception

closeResourceRequested

public boolean closeResourceRequested(ResourceProvider resource)

Specified by:

closeResourceRequested in interface ResourceConsumer

resourceChanged

public void resourceChanged(ResourceProvider resource)

Specified by:

resourceChanged in interface ResourceConsumer

getGeometryManager

public GeometryManager getGeometryManager()

Specified by:

getGeometryManager in interface JDBCHelper

getResulSetControler

public ResulSetControler getResulSetControler()

Specified by:

getResulSetControler in interface JDBCHelper

fetchFeature

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

Specified by:

fetchFeature in interface JDBCHelper

Throws:

DataException

fetchFeature

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

Specified by:

fetchFeature in interface JDBCHelper

Throws:

DataException

getGeometryFromColumn

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

Specified by:

getGeometryFromColumn in interface JDBCHelper

Throws:

DataException

getGeometryFromColumn

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

Specified by:

getGeometryFromColumn in interface JDBCHelper

Throws:

DataException

createFeature

public FeatureProvider createFeature(FeatureType featureType)
                              throws DataException

Specified by:

createFeature in interface JDBCHelper

Throws:

DataException

useSubquery

public boolean useSubquery()

Description copied from interface: JDBCHelper

Indica si se especifico un subquery al abrir el proveedor.

Specified by:

useSubquery in interface JDBCHelper

Returns:

getSRSCode

public int getSRSCode(IProjection crs)

Specified by:

getSRSCode in interface JDBCHelper

Returns:

getProjectionFromSRSId

public IProjection getProjectionFromSRSId(int srsid)

Specified by:

getProjectionFromSRSId in interface JDBCHelper

Returns:

getDatabaseCodeFromProyection

public String getDatabaseCodeFromProyection(IProjection proj)

Specified by:

getDatabaseCodeFromProyection in interface JDBCHelper

getProjectionFromDatabaseCode

public IProjection getProjectionFromDatabaseCode(String databaseCode)

Specified by:

getProjectionFromDatabaseCode in interface JDBCHelper

createProvider

public JDBCStoreProvider createProvider(JDBCStoreParameters parameters,
                                        DataStoreProviderServices providerServices)
                                 throws InitializeException

Specified by:

createProvider in interface JDBCHelper

Throws:

InitializeException

createServerExplorer

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

Specified by:

createServerExplorer in interface JDBCHelper

Throws:

InitializeException

createNewStoreParameters

public JDBCNewStoreParameters createNewStoreParameters()

Specified by:

createNewStoreParameters in interface JDBCHelper

createOpenStoreParameters

public JDBCStoreParameters createOpenStoreParameters()

Specified by:

createOpenStoreParameters in interface JDBCHelper

createServerExplorerParameters

public JDBCServerExplorerParameters createServerExplorerParameters()

Specified by:

createServerExplorerParameters in interface JDBCHelper

getSourceId

public String getSourceId(JDBCStoreParameters parameters)

Specified by:

getSourceId in interface JDBCHelper