org.gvsig.sqlite.dal

Class SQLiteHelper

java.lang.Object

org.gvsig.tools.dispose.impl.AbstractDisposable

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

org.gvsig.sqlite.dal.SQLiteHelper

All Implemented Interfaces:

java.lang.AutoCloseable, ResourceConsumer, JDBCHelper, Disposable

public class SQLiteHelper
extends JDBCHelperBase

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SQLiteHelper.ConnectionProviderImpl

Field Summary

Fields

Modifier and Type	Field and Description
protected static Logger	LOGGER

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

operationsFactory, providerFeatureType, srssolver, transactionsHelper

Constructor Summary

Constructors

Constructor and Description
SQLiteHelper(JDBCConnectionParameters connectionParameters)
SQLiteHelper(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.
Geometry	forceGeometryType(GeometryType geomtype, Geometry geom)
JDBCConnection	getConnection()
SQLiteConnectionParameters	getConnectionParameters()
ConnectionProvider	getConnectionProvider()
java.lang.String	getConnectionProviderKey(JDBCConnectionParameters connectionParameters)
java.lang.String	getConnectionURL()
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)
SRSSolver	getSRSSolver()
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, getConnectionProviderStatus, getConnectionWritable, getGeometryFromColumn, getGeometryManager, getProviderFeatureType, getResource, getResulSetControler, getSourceId, 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

LOGGER

protected static final Logger LOGGER

Constructor Detail

SQLiteHelper

public SQLiteHelper(JDBCConnectionParameters connectionParameters,
                    ConnectionProvider connectionProvider)

Constructor for use only for testing purposes.

Parameters:

connectionParameters -

connectionProvider -

SQLiteHelper

public SQLiteHelper(JDBCConnectionParameters connectionParameters)

Method Detail

getConnection

public JDBCConnection getConnection()
                             throws AccessResourceException

Specified by:

getConnection in interface JDBCHelper

Overrides:

getConnection in class JDBCHelperBase

Throws:

AccessResourceException

getConnectionProvider

public ConnectionProvider getConnectionProvider()

Overrides:

getConnectionProvider in class JDBCHelperBase

getConnectionParameters

public SQLiteConnectionParameters 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

forceGeometryType

public Geometry forceGeometryType(GeometryType geomtype,
                                  Geometry geom)
                           throws CreateGeometryException

Throws:

CreateGeometryException

getSRSSolver

public SRSSolver getSRSSolver()

Specified by:

getSRSSolver in interface JDBCHelper

Overrides:

getSRSSolver in class JDBCHelperBase

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

createServerExplorer

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

Specified by:

createServerExplorer in interface JDBCHelper

Overrides:

createServerExplorer in class JDBCHelperBase

Throws:

InitializeException

getConnectionProviderKey

public java.lang.String getConnectionProviderKey(JDBCConnectionParameters connectionParameters)

Overrides:

getConnectionProviderKey in class JDBCHelperBase