Package org.gvsig.oracle.dal

Class OracleSQLBuilder

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

  • Nested Class Summary

    Nested Classes
    Modifier and Type
    Class
    Description
    class 
    OracleSQLBuilder.DisposableBlobs
     
    class 
    OracleSQLBuilder.OracleAlterTableBuilder
     
    class 
    OracleSQLBuilder.OracleCreateIndexBuilder
     
    protected class 
    OracleSQLBuilder.OracleCreateTableBuilder
     
    class 
    OracleSQLBuilder.OracleFromBuilder
     
    class 
    OracleSQLBuilder.OracleSelectBuilder
     
    class 
    OracleSQLBuilder.OracleSelectColumnBuilder
     
    protected class 
    OracleSQLBuilder.OracleTableNameBuilder
     
    class 
    OracleSQLBuilder.OracleUpdateTableStatisticsBuilderBase
     

    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 static final String
    ADD_SERIAL_COLUMN_SEQUENCE_QUERY
     
    protected static final String
    ADD_SERIAL_COLUMN_TRIGGER_QUERY
     
    static final int
    BOOLEAN_STRING_DEFAULT_LENGTH
     
    protected static final String
    DELETE_FROM_OGIS_GEOMETRY_COLUMNS_QUERY
     
    static final String
    FORMAT_OPERATOR_AND
     
    static final String
    FORMAT_OPERATOR_CONCAT
     
    static final String
    FORMAT_OPERATOR_ILIKE
     
    static final String
    FORMAT_OPERATOR_NE
     
    static final String
    FORMAT_OPERATOR_NOTISNULL
     
    static final String
    FORMAT_OPERATOR_OR
     
    protected org.gvsig.expressionevaluator.Formatter
    formatter
     
    protected static final String
    INSERT_OGIS_GEOMETRY_COLUMNS_QUERY
     
    static final String
    ST_GEOMFROMEWKB
     
    static final String
    ST_GEOMFROMTEXT
     
    static final String
    ST_GEOMFROMWKB
     

    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
    OracleSQLBuilder(org.gvsig.fmap.dal.store.jdbc2.JDBCHelper helper)
     

  • Method Summary

    Modifier and Type
    Method
    Description
    org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder
    alter_table()
     
    String
    as_clob(String s)
     
    String
    blob(byte[] data)
     
    boolean
    canBeBoolean(org.gvsig.expressionevaluator.ExpressionBuilder.Value value)
     
    org.gvsig.fmap.dal.SQLBuilder.CreateIndexBuilder
    create_index()
     
    org.gvsig.fmap.dal.SQLBuilder.CreateTableBuilder
    create_table()
     
    protected org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder
    createAlterTableBuilder()
     
    org.gvsig.fmap.dal.SQLBuilder.CreateIndexBuilder
    createCreateIndexBuilder()
     
    protected org.gvsig.fmap.dal.SQLBuilder.CreateTableBuilder
    createCreateTableBuilder()
     
    protected org.gvsig.fmap.dal.SQLBuilder.FromBuilder
    createFromBuilder()
     
    org.gvsig.fmap.dal.SQLBuilder.SelectBuilder
    createSelectBuilder()
     
    protected org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder
    createSelectColumnBuilder()
     
    org.gvsig.fmap.dal.SQLBuilder.TableNameBuilder
    createTableNameBuilder()
     
    protected org.gvsig.fmap.dal.SQLBuilder.UpdateTableStatisticsBuilder
    createUpdateTableStatisticsBuilder()
     
    String
    default_schema()
     
    org.gvsig.fmap.dal.SQLBuilder.DeleteBuilder
    delete()
     
    org.gvsig.fmap.dal.SQLBuilder.DropTableBuilder
    drop_table()
     
    org.gvsig.expressionevaluator.GeometryExpressionBuilder
    expression()
     
    String
    formatAsBoolean(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, org.gvsig.expressionevaluator.ExpressionBuilder.Value value)
     
    org.gvsig.expressionevaluator.Formatter
    formatter()
     
    OracleHelper
    getHelper()
     
    int
    getMaxRecomendedSQLLength()
     
    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)
     
    String
    getProviderTableName(org.gvsig.fmap.dal.store.jdbc2.OperationsFactory.TableReference table)
     
    String
    getSerialSequenceName(String tableName, String columnName)
     
    String
    getSerialTriggerName(String tableName, String columnName)
     
    org.gvsig.fmap.dal.SQLBuilder.GrantBuilder
    grant()
     
    org.gvsig.fmap.dal.SQLBuilder.InsertBuilder
    insert()
     
    List<String>
    parameters_names()
     
    String
    quote_for_identifiers()
     
    String
    quote_for_strings()
     
    org.gvsig.fmap.dal.SQLBuilder.SelectBuilder
    select()
     
    protected void
    setBlob(PreparedStatement st, int columnIndex, byte[] bytes, OracleSQLBuilder.DisposableBlobs blobList)
     
    org.gvsig.tools.dispose.Disposable
    setStatementParameters(PreparedStatement st, List values, List<Integer> types, org.gvsig.expressionevaluator.GeometryExpressionBuilderHelper.GeometrySupportType geometrySupportType)
     
    String
    sqltype(int type, int size, int precision, int scale, int geomType, int geomSubtype)
     
    org.gvsig.fmap.dal.SQLBuilder.TableNameBuilder
    table_name()
     
    org.gvsig.fmap.dal.SQLBuilder.UpdateBuilder
    update()
     
    org.gvsig.fmap.dal.SQLBuilder.UpdateTableStatisticsBuilder
    update_table_statistics()
     

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

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

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

    accept, as_identifier, as_string, as_string, as_string, as_string, as_string, column, column, column, column_from, column_from, count, createDeleteBuilder, createDropIndexBuilder, createDropTableBuilder, createExpressionBuilder, createGrantBuilder, createGrantRoleBuilder, createInsertBuilder, createInsertColumnBuilder, createJoin, createMergeBuilder, createOrderByBuilder, createUpdateBuilder, createUpdateColumnBuilder, drop_index, geometry_support_type, getConstrainName, has_spatial_functions, isAggregateFunction, merge, parameters, setProperties, setProperties, sqlgeometrydimension, sqlgeometrytype, support_schemas, toString, toString, variables, variables_names

    Methods inherited from class java.lang.Object

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

  • Field Details

  • Constructor Details

    • OracleSQLBuilder

      public OracleSQLBuilder(org.gvsig.fmap.dal.store.jdbc2.JDBCHelper helper)

  • Method Details

    • getHelper

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

    • 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

    • expression

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

    • default_schema

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

    • getSerialSequenceName

      public String getSerialSequenceName(String tableName, String columnName)

    • getSerialTriggerName

      public String getSerialTriggerName(String tableName, String columnName)

    • 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

    • createFromBuilder

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

    • createUpdateTableStatisticsBuilder

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

    • getProviderTableName

      public String getProviderTableName(org.gvsig.fmap.dal.store.jdbc2.OperationsFactory.TableReference table)

    • setBlob

      protected void setBlob(PreparedStatement st, int columnIndex, byte[] bytes, OracleSQLBuilder.DisposableBlobs blobList) throws SQLException, IOException
      Throws:
      SQLException
      IOException

    • 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

    • getParameters

      public List<Object> getParameters(org.gvsig.fmap.dal.feature.spi.FeatureProvider feature)
      Overrides:
      getParameters in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

    • getParameters

      public List<Object> getParameters(org.gvsig.fmap.dal.feature.spi.FeatureProvider feature, List<Integer> types)
      Overrides:
      getParameters in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

    • parameters_names

      public List<String> parameters_names()
      Specified by:
      parameters_names in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      parameters_names in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • blob

      public String blob(byte[] data)

    • as_clob

      public String as_clob(String s)
      Specified by:
      as_clob in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      as_clob in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • createAlterTableBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder createAlterTableBuilder()
      Overrides:
      createAlterTableBuilder 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

    • quote_for_identifiers

      public String quote_for_identifiers()
      Overrides:
      quote_for_identifiers in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • quote_for_strings

      public String quote_for_strings()
      Overrides:
      quote_for_strings in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • createSelectColumnBuilder

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

    • select

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

    • update

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

    • update_table_statistics

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

    • drop_table

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

    • create_index

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

    • delete

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

    • insert

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

    • table_name

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

    • alter_table

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

    • create_table

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

    • grant

      public org.gvsig.fmap.dal.SQLBuilder.GrantBuilder grant()
      Specified by:
      grant in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      grant 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

    • 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

    • canBeBoolean

      public boolean canBeBoolean(org.gvsig.expressionevaluator.ExpressionBuilder.Value value)

    • formatAsBoolean

      public String formatAsBoolean(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, org.gvsig.expressionevaluator.ExpressionBuilder.Value value)