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

Class JDBCSQLBuilderBase

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

  • Nested Class Summary

    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 final JDBCHelper
    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
    JDBCSQLBuilderBase(JDBCHelper helper)
     

  • Method Summary

    Modifier and Type
    Method
    Description
    protected void
    debug_setStatementParameters(PreparedStatement st, List values, List<Integer> types, org.gvsig.expressionevaluator.GeometryExpressionBuilderHelper.GeometrySupportType geometrySupportType)
     
    protected org.gvsig.fmap.geom.Geometry
    forceGeometryType(org.gvsig.fmap.geom.type.GeometryType geomtype, org.gvsig.fmap.geom.Geometry geom)
     
    protected org.gvsig.fmap.geom.GeometryManager
    getGeometryManager()
     
    JDBCHelper
    getHelper()
     
    protected byte[]
    getNativeBytes(Connection conn, org.gvsig.fmap.geom.Geometry geometry)
     
    List<Object>
    getParameters(org.gvsig.fmap.dal.feature.spi.FeatureProvider feature)
     
    List<Object>
    getParameters(org.gvsig.fmap.dal.feature.spi.FeatureProvider feature, List<Integer> types)
     
    void
    setParameters(PreparedStatement st)
     
    org.gvsig.tools.dispose.Disposable
    setParameters(PreparedStatement st, org.gvsig.fmap.dal.feature.FeatureReference reference)
     
    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)
     
    org.gvsig.tools.dispose.Disposable
    setStatementParameters(PreparedStatement st, List values, org.gvsig.expressionevaluator.GeometryExpressionBuilderHelper.GeometrySupportType geometrySupportType)
     
    protected void
    setStatementValue(PreparedStatement st, int columnIndex, int type, Object value)
     
    Object
    srs_id(org.gvsig.crs.projection.lib.Projection projection)
     

    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, createAlterTableBuilder, createCreateIndexBuilder, createCreateTableBuilder, createDeleteBuilder, createDropIndexBuilder, createDropTableBuilder, createExpressionBuilder, createFromBuilder, createGrantBuilder, createGrantRoleBuilder, createInsertBuilder, createInsertColumnBuilder, createJoin, createMergeBuilder, createOrderByBuilder, createSelectBuilder, createSelectColumnBuilder, createTableNameBuilder, createUpdateBuilder, createUpdateColumnBuilder, createUpdateTableStatisticsBuilder, default_schema, delete, drop_index, drop_table, expression, formatter, geometry_support_type, getConstrainName, getMaxRecomendedSQLLength, grant, has_spatial_functions, insert, isAggregateFunction, merge, parameters, parameters_names, quote_for_identifiers, quote_for_strings, select, setProperties, setProperties, sqlgeometrydimension, sqlgeometrytype, sqltype, 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

  • Constructor Details

    • JDBCSQLBuilderBase

      public JDBCSQLBuilderBase(JDBCHelper helper)

  • Method Details

    • getHelper

      public JDBCHelper getHelper()

    • getGeometryManager

      protected org.gvsig.fmap.geom.GeometryManager getGeometryManager()

    • srs_id

      public Object srs_id(org.gvsig.crs.projection.lib.Projection projection)
      Specified by:
      srs_id in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      srs_id in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • setParameters

      public void setParameters(PreparedStatement st)

    • getParameters

      public List<Object> getParameters(org.gvsig.fmap.dal.feature.spi.FeatureProvider feature)

    • getParameters

      public List<Object> getParameters(org.gvsig.fmap.dal.feature.spi.FeatureProvider feature, List<Integer> types)

    • setParameters

      public org.gvsig.tools.dispose.Disposable setParameters(PreparedStatement st, org.gvsig.fmap.dal.feature.spi.FeatureProvider feature)

    • forceGeometryType

      protected 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

    • setParameters

      public org.gvsig.tools.dispose.Disposable setParameters(PreparedStatement st, org.gvsig.fmap.dal.feature.FeatureReference reference)

    • setStatementParameters

      public org.gvsig.tools.dispose.Disposable setStatementParameters(PreparedStatement st, List values, org.gvsig.expressionevaluator.GeometryExpressionBuilderHelper.GeometrySupportType geometrySupportType) throws SQLException
      Throws:
      SQLException

    • setStatementParameters

      public org.gvsig.tools.dispose.Disposable setStatementParameters(PreparedStatement st, List values, List<Integer> types, org.gvsig.expressionevaluator.GeometryExpressionBuilderHelper.GeometrySupportType geometrySupportType) throws SQLException
      Throws:
      SQLException

    • getNativeBytes

      protected byte[] getNativeBytes(Connection conn, org.gvsig.fmap.geom.Geometry geometry) throws Exception
      Throws:
      Exception

    • debug_setStatementParameters

      protected void debug_setStatementParameters(PreparedStatement st, List values, List<Integer> types, org.gvsig.expressionevaluator.GeometryExpressionBuilderHelper.GeometrySupportType geometrySupportType) throws SQLException
      Throws:
      SQLException

    • setStatementValue

      protected void setStatementValue(PreparedStatement st, int columnIndex, int type, Object value) throws SQLException
      Throws:
      SQLException