Package 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:
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
    Description
    static class 
    SQLiteHelper.ConnectionProviderImpl
     

  • Field Summary

    Fields
    Modifier and Type
    Field
    Description
    protected static final org.slf4j.Logger
    LOGGER
     

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

    operationsFactory, providerFeatureType, srssolver, transactionsHelper

  • Constructor Summary

    Constructors
    Constructor
    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
    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()
     
    String
    getConnectionProviderKey(org.gvsig.fmap.dal.store.jdbc.JDBCConnectionParameters connectionParameters)
     
    String
    getConnectionURL()
     
    org.gvsig.fmap.geom.Geometry
    getGeometryFromColumn(ResultSet rs, int index)
     
    org.gvsig.expressionevaluator.GeometryExpressionBuilderHelper.GeometrySupportType
    getGeometrySupportType()
     
    org.gvsig.fmap.dal.store.jdbc2.OperationsFactory
    getOperations()
     
    String
    getProviderName()
     
    String
    getQuoteForIdentifiers()
     
    String
    getQuoteForStrings()
     
    protected String
    getResourceType()
     
    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 Details

    • LOGGER

      protected static final org.slf4j.Logger LOGGER

  • Constructor Details

    • 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 -

    • SQLiteHelper

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

  • Method Details

    • 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

    • getConnectionProvider

      public org.gvsig.fmap.dal.store.jdbc2.spi.ConnectionProvider getConnectionProvider()
      Overrides:
      getConnectionProvider in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

    • 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

    • getConnectionURL

      public 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

    • getResourceType

      protected String getResourceType()
      Overrides:
      getResourceType in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase

    • getProviderName

      public 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

    • 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

    • 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

    • 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

    • 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

    • 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

    • getQuoteForIdentifiers

      public 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

    • 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

    • 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

    • getQuoteForStrings

      public 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

    • getSourceId

      public 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

    • 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

    • 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

    • 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

    • 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

    • getGeometryFromColumn

      public org.gvsig.fmap.geom.Geometry getGeometryFromColumn(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

    • 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

    • getConnectionProviderKey

      public String getConnectionProviderKey(org.gvsig.fmap.dal.store.jdbc.JDBCConnectionParameters connectionParameters)
      Overrides:
      getConnectionProviderKey in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase