Package org.gvsig.fmap.dal.store.h2

Class H2SpatialSQLBuilder

java.lang.Object
org.gvsig.fmap.dal.feature.spi.SQLBuilderBase
org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase
org.gvsig.fmap.dal.store.h2.H2SpatialSQLBuilder
All Implemented Interfaces:
org.gvsig.expressionevaluator.ExpressionBuilder.Visitable, org.gvsig.fmap.dal.SQLBuilder
public class H2SpatialSQLBuilder extends org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

  • Nested Class Summary

    Nested Classes
    Modifier and Type
    Class
    Description
    protected class 
    H2SpatialSQLBuilder.H2SpatialAlterTableBuilderBase
     
    class 
    H2SpatialSQLBuilder.H2SpatialCreateIndexBuilder
     
    protected class 
    H2SpatialSQLBuilder.H2SpatialCreateTableBuilder
     
    class 
    H2SpatialSQLBuilder.H2SpatialSelectBuilderBase
     
    class 
    H2SpatialSQLBuilder.H2SpatialTableNameBuilderBase
     

    Nested classes/interfaces inherited from class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.AbstractStatement, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.AbstractStatementPart, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.AlterTableBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.ColumnBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.ColumnDescriptorBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.CountBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.CreateIndexBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.CreateTableBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.DeleteBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.DropIndexBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.DropTableBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.FromBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.GrantBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.GrantRoleBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.InsertBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.InsertColumnBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.JoinBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.MergeBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.OrderByBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.SelectBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.SelectColumnBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.TableNameBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.UpdateBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.UpdateColumnBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.UpdateTableStatisticsBuilderBase

    Nested classes/interfaces inherited from interface org.gvsig.fmap.dal.SQLBuilder

    org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder, org.gvsig.fmap.dal.SQLBuilder.Column, org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor, org.gvsig.fmap.dal.SQLBuilder.CountBuilder, org.gvsig.fmap.dal.SQLBuilder.CreateIndexBuilder, org.gvsig.fmap.dal.SQLBuilder.CreateTableBuilder, org.gvsig.fmap.dal.SQLBuilder.DeleteBuilder, org.gvsig.fmap.dal.SQLBuilder.DropIndexBuilder, org.gvsig.fmap.dal.SQLBuilder.DropTableBuilder, org.gvsig.fmap.dal.SQLBuilder.FromBuilder, org.gvsig.fmap.dal.SQLBuilder.GrantBuilder, org.gvsig.fmap.dal.SQLBuilder.GrantRoleBuilder, org.gvsig.fmap.dal.SQLBuilder.InsertBuilder, org.gvsig.fmap.dal.SQLBuilder.InsertColumnBuilder, org.gvsig.fmap.dal.SQLBuilder.JoinBuilder, org.gvsig.fmap.dal.SQLBuilder.MergeBuilder, org.gvsig.fmap.dal.SQLBuilder.OrderByBuilder, org.gvsig.fmap.dal.SQLBuilder.Privilege, org.gvsig.fmap.dal.SQLBuilder.SelectBuilder, org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder, org.gvsig.fmap.dal.SQLBuilder.Statement, org.gvsig.fmap.dal.SQLBuilder.StatementPart, org.gvsig.fmap.dal.SQLBuilder.TableNameBuilder, org.gvsig.fmap.dal.SQLBuilder.UpdateBuilder, org.gvsig.fmap.dal.SQLBuilder.UpdateColumnBuilder, org.gvsig.fmap.dal.SQLBuilder.UpdateTableStatisticsBuilder

  • Field Summary

    Fields
    Modifier and Type
    Field
    Description
    protected org.gvsig.expressionevaluator.Formatter
    formatter
     

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

    helper

    Fields inherited from class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    aggregateFunctionNames, allowAutomaticValues, alter_table, constant_false, constant_true, create_index, create_table, defaultSchema, delete, drop_index, drop_table, expressionBuilder, geometrySupportType, grant, hasSpatialFunctions, insert, LOGGER, merge, select, STMT_DELETE_FROM_table, STMT_DELETE_FROM_table_WHERE_expresion, STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_schema_table, STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_table, STMT_DROP_TABLE_table, STMT_GRANT_privileges_ON_table_TO_role, STMT_INSERT_INTO_table_columns_VALUES_values, STMT_MERGE_INTO_table_KEY_column_columns_VALUES_values, STMT_UPDATE_table_SET_columnsAndValues, STMT_UPDATE_table_SET_columnsAndValues_WHERE_expresion, STMT_UPDATE_TABLE_STATISTICS_table, supportSchemas, table_name, type_boolean, type_byte, type_bytearray, type_char, type_date, type_decimal_p, type_decimal_ps, type_double, type_FILE, type_float, type_FOLDER, type_geometry, type_int, type_long, type_string, type_string_0, type_string_p, type_time, type_timestamp, type_URI, type_URL, type_version, update, update_table_statistics

    Fields inherited from interface org.gvsig.fmap.dal.SQLBuilder

    DEFAULT_RECOMENDED_SQL_LENGTH, FEATURE_ATTRIBUTE_DESCRIPTOR, PROP_ADD_TABLE_NAME_TO_COLUMNS, PROP_FEATURE_TYPE, PROP_JDBCHELPER, PROP_QUERY, PROP_SQLBUILDER, PROP_SYMBOLTABLE, PROP_TABLE, PROP_TABLENAME

  • Constructor Summary

    Constructors
    Constructor
    Description
    H2SpatialSQLBuilder(H2SpatialHelper helper)
     

  • Method Summary

    Modifier and Type
    Method
    Description
    protected org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder
    createAlterTableBuilder()
     
    org.gvsig.fmap.dal.SQLBuilder.CreateIndexBuilder
    createCreateIndexBuilder()
     
    protected org.gvsig.fmap.dal.SQLBuilder.CreateTableBuilder
    createCreateTableBuilder()
     
    org.gvsig.fmap.dal.SQLBuilder.SelectBuilder
    createSelectBuilder()
     
    org.gvsig.fmap.dal.SQLBuilder.TableNameBuilder
    createTableNameBuilder()
     
    org.gvsig.expressionevaluator.Formatter
    formatter()
     
    H2SpatialHelper
    getHelper()
     
    int
    getMaxRecomendedSQLLength()
     
    org.gvsig.tools.dispose.Disposable
    setParameters(PreparedStatement st, org.gvsig.fmap.dal.feature.spi.FeatureProvider feature)
     
    org.gvsig.tools.dispose.Disposable
    setStatementParameters(PreparedStatement st, List values, List<Integer> types, org.gvsig.expressionevaluator.GeometryExpressionBuilderHelper.GeometrySupportType geometrySupportType)
     
    Object
    sqlgeometrydimension(int type, int subtype)
     
    Object
    sqlgeometrynumdimension(int type, int subtype)
     
    Object
    sqlgeometrytype(int geomtype, int geomsubtype)
     
    String
    sqltype(int type, int size, int precision, int scale, int geomtype, int geomSubtype)
     

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

    debug_setStatementParameters, forceGeometryType, getGeometryManager, getNativeBytes, getParameters, getParameters, setParameters, setParameters, setStatementParameters, setStatementValue, srs_id

    Methods inherited from class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    accept, alter_table, as_clob, as_identifier, as_string, as_string, as_string, as_string, as_string, column, column, column, column_from, column_from, count, create_index, create_table, createDeleteBuilder, createDropIndexBuilder, createDropTableBuilder, createExpressionBuilder, createFromBuilder, createGrantBuilder, createGrantRoleBuilder, createInsertBuilder, createInsertColumnBuilder, createJoin, createMergeBuilder, createOrderByBuilder, createSelectColumnBuilder, createUpdateBuilder, createUpdateColumnBuilder, createUpdateTableStatisticsBuilder, default_schema, delete, drop_index, drop_table, expression, geometry_support_type, getConstrainName, grant, has_spatial_functions, insert, isAggregateFunction, merge, parameters, parameters_names, quote_for_identifiers, quote_for_strings, select, setProperties, setProperties, support_schemas, table_name, toString, toString, update, update_table_statistics, variables, variables_names

    Methods inherited from class java.lang.Object

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

  • Field Details

    • formatter

      protected org.gvsig.expressionevaluator.Formatter formatter

  • Constructor Details

  • Method Details

    • formatter

      public org.gvsig.expressionevaluator.Formatter formatter()
      Specified by:
      formatter in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      formatter in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • sqlgeometrydimension

      public Object sqlgeometrydimension(int type, int subtype)
      Specified by:
      sqlgeometrydimension in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      sqlgeometrydimension in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • sqltype

      public String sqltype(int type, int size, int precision, int scale, int geomtype, int geomSubtype)
      Specified by:
      sqltype in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      sqltype in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • sqlgeometrytype

      public Object sqlgeometrytype(int geomtype, int geomsubtype)
      Specified by:
      sqlgeometrytype in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      sqlgeometrytype in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • sqlgeometrynumdimension

      public Object sqlgeometrynumdimension(int type, int subtype)

    • getHelper

      public H2SpatialHelper getHelper()
      Overrides:
      getHelper in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

    • setParameters

      public org.gvsig.tools.dispose.Disposable setParameters(PreparedStatement st, org.gvsig.fmap.dal.feature.spi.FeatureProvider feature)
      Overrides:
      setParameters in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

    • createAlterTableBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder createAlterTableBuilder()
      Overrides:
      createAlterTableBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • createTableNameBuilder

      public org.gvsig.fmap.dal.SQLBuilder.TableNameBuilder createTableNameBuilder()
      Specified by:
      createTableNameBuilder in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      createTableNameBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • createCreateTableBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.CreateTableBuilder createCreateTableBuilder()
      Overrides:
      createCreateTableBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • createSelectBuilder

      public org.gvsig.fmap.dal.SQLBuilder.SelectBuilder createSelectBuilder()
      Specified by:
      createSelectBuilder in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      createSelectBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • createCreateIndexBuilder

      public org.gvsig.fmap.dal.SQLBuilder.CreateIndexBuilder createCreateIndexBuilder()
      Overrides:
      createCreateIndexBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • setStatementParameters

      public org.gvsig.tools.dispose.Disposable setStatementParameters(PreparedStatement st, List values, List<Integer> types, org.gvsig.expressionevaluator.GeometryExpressionBuilderHelper.GeometrySupportType geometrySupportType) throws SQLException
      Overrides:
      setStatementParameters in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase
      Throws:
      SQLException

    • getMaxRecomendedSQLLength

      public int getMaxRecomendedSQLLength()
      Specified by:
      getMaxRecomendedSQLLength in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      getMaxRecomendedSQLLength in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase