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, org.gvsig.fmap.dal.resource.spi.ResourceConsumer, org.gvsig.fmap.dal.store.jdbc2.JDBCHelper, org.gvsig.tools.dispose.Disposable

public class SQLiteHelper
extends org.gvsig.fmap.dal.store.jdbc2.spi.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 org.slf4j.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(org.gvsig.fmap.dal.store.jdbc.JDBCConnectionParameters connectionParameters)
SQLiteHelper(org.gvsig.fmap.dal.store.jdbc.JDBCConnectionParameters connectionParameters, org.gvsig.fmap.dal.store.jdbc2.spi.ConnectionProvider connectionProvider) Constructor for use only for testing purposes.

Method Summary

Modifier and Type	Method and Description
boolean	allowAutomaticValues()
boolean	canWriteGeometry(int geometryType, int geometrySubtype)
org.gvsig.fmap.dal.store.jdbc.JDBCNewStoreParameters	createNewStoreParameters()
org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters	createOpenStoreParameters()
org.gvsig.fmap.dal.store.jdbc2.JDBCServerExplorer	createServerExplorer(org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorerParameters parameters, org.gvsig.fmap.dal.spi.DataServerExplorerProviderServices providerServices)
org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorerParameters	createServerExplorerParameters()
org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase	createSQLBuilder()
org.gvsig.fmap.geom.Geometry	forceGeometryType(org.gvsig.fmap.geom.type.GeometryType geomtype, org.gvsig.fmap.geom.Geometry geom)
org.gvsig.fmap.dal.store.jdbc2.JDBCConnection	getConnection()
SQLiteConnectionParameters	getConnectionParameters()
org.gvsig.fmap.dal.store.jdbc2.spi.ConnectionProvider	getConnectionProvider()
java.lang.String	getConnectionProviderKey(org.gvsig.fmap.dal.store.jdbc.JDBCConnectionParameters connectionParameters)
java.lang.String	getConnectionURL()
org.gvsig.fmap.geom.Geometry	getGeometryFromColumn(java.sql.ResultSet rs, int index)
org.gvsig.expressionevaluator.GeometryExpressionBuilderHelper.GeometrySupportType	getGeometrySupportType()
org.gvsig.fmap.dal.store.jdbc2.OperationsFactory	getOperations()
java.lang.String	getProviderName()
java.lang.String	getQuoteForIdentifiers()
java.lang.String	getQuoteForStrings()
protected java.lang.String	getResourceType()
java.lang.String	getSourceId(org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters parameters)
org.gvsig.fmap.dal.store.jdbc2.spi.SRSSolver	getSRSSolver()
boolean	hasSpatialFunctions()
boolean	supportOffsetInSelect()

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 org.slf4j.Logger LOGGER

Constructor Detail

SQLiteHelper

public SQLiteHelper(org.gvsig.fmap.dal.store.jdbc.JDBCConnectionParameters connectionParameters)

SQLiteHelper

public SQLiteHelper(org.gvsig.fmap.dal.store.jdbc.JDBCConnectionParameters connectionParameters,
                    org.gvsig.fmap.dal.store.jdbc2.spi.ConnectionProvider connectionProvider)

Constructor for use only for testing purposes.

Parameters:

connectionParameters -

connectionProvider -

Method Detail

allowAutomaticValues

public boolean allowAutomaticValues()

Specified by:

allowAutomaticValues in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

allowAutomaticValues in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

canWriteGeometry

public boolean canWriteGeometry(int geometryType,
                                int geometrySubtype)

Specified by:

canWriteGeometry in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

canWriteGeometry in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

createNewStoreParameters

public org.gvsig.fmap.dal.store.jdbc.JDBCNewStoreParameters createNewStoreParameters()

Specified by:

createNewStoreParameters in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

createNewStoreParameters in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

createOpenStoreParameters

public org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters createOpenStoreParameters()

Specified by:

createOpenStoreParameters in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

createOpenStoreParameters in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

createServerExplorer

public 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

Specified by:

createServerExplorer in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

createServerExplorer in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

Throws:

org.gvsig.fmap.dal.exception.InitializeException

createServerExplorerParameters

public org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorerParameters createServerExplorerParameters()

Specified by:

createServerExplorerParameters in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

createServerExplorerParameters in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

createSQLBuilder

public org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase createSQLBuilder()

Specified by:

createSQLBuilder in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

createSQLBuilder in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

forceGeometryType

public org.gvsig.fmap.geom.Geometry forceGeometryType(org.gvsig.fmap.geom.type.GeometryType geomtype,
                                                      org.gvsig.fmap.geom.Geometry geom)
                                               throws org.gvsig.fmap.geom.exception.CreateGeometryException

Throws:

org.gvsig.fmap.geom.exception.CreateGeometryException

getConnection

public org.gvsig.fmap.dal.store.jdbc2.JDBCConnection getConnection()
                                                            throws org.gvsig.fmap.dal.resource.exception.AccessResourceException

Specified by:

getConnection in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

getConnection in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

Throws:

org.gvsig.fmap.dal.resource.exception.AccessResourceException

getConnectionParameters

public SQLiteConnectionParameters getConnectionParameters()

Specified by:

getConnectionParameters in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

getConnectionParameters in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

getConnectionProvider

public org.gvsig.fmap.dal.store.jdbc2.spi.ConnectionProvider getConnectionProvider()

Overrides:

getConnectionProvider in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

getConnectionProviderKey

public java.lang.String getConnectionProviderKey(org.gvsig.fmap.dal.store.jdbc.JDBCConnectionParameters connectionParameters)

Overrides:

getConnectionProviderKey in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

getConnectionURL

public java.lang.String getConnectionURL()

Specified by:

getConnectionURL in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

getConnectionURL in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

getGeometryFromColumn

public org.gvsig.fmap.geom.Geometry getGeometryFromColumn(java.sql.ResultSet rs,
                                                          int index)
                                                   throws org.gvsig.fmap.dal.exception.DataException

Specified by:

getGeometryFromColumn in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

getGeometryFromColumn in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

Throws:

org.gvsig.fmap.dal.exception.DataException

getGeometrySupportType

public org.gvsig.expressionevaluator.GeometryExpressionBuilderHelper.GeometrySupportType getGeometrySupportType()

Specified by:

getGeometrySupportType in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

getGeometrySupportType in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

getOperations

public org.gvsig.fmap.dal.store.jdbc2.OperationsFactory getOperations()

Specified by:

getOperations in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

getOperations in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

getProviderName

public java.lang.String getProviderName()

Specified by:

getProviderName in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

getProviderName in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

getQuoteForIdentifiers

public java.lang.String getQuoteForIdentifiers()

Specified by:

getQuoteForIdentifiers in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

getQuoteForIdentifiers in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

getQuoteForStrings

public java.lang.String getQuoteForStrings()

Specified by:

getQuoteForStrings in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

getQuoteForStrings in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

getResourceType

protected java.lang.String getResourceType()

Overrides:

getResourceType in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

getSourceId

public java.lang.String getSourceId(org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters parameters)

Specified by:

getSourceId in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

getSourceId in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

getSRSSolver

public org.gvsig.fmap.dal.store.jdbc2.spi.SRSSolver getSRSSolver()

Specified by:

getSRSSolver in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

getSRSSolver in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

hasSpatialFunctions

public boolean hasSpatialFunctions()

Specified by:

hasSpatialFunctions in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

hasSpatialFunctions in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

supportOffsetInSelect

public boolean supportOffsetInSelect()

Specified by:

supportOffsetInSelect in interface org.gvsig.fmap.dal.store.jdbc2.JDBCHelper

Overrides:

supportOffsetInSelect in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase