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:

ExpressionBuilder.Visitable, SQLBuilder

public class H2SpatialSQLBuilder
extends JDBCSQLBuilderBase

Nested Class Summary

Nested Classes

Modifier and Type	Class and 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

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

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

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

Field Summary

Fields

Modifier and Type	Field and Description
protected 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 and Description
H2SpatialSQLBuilder(H2SpatialHelper helper)

Method Summary

Modifier and Type	Method and Description
protected SQLBuilder.AlterTableBuilder	createAlterTableBuilder()
SQLBuilder.CreateIndexBuilder	createCreateIndexBuilder()
protected SQLBuilder.CreateTableBuilder	createCreateTableBuilder()
SQLBuilder.SelectBuilder	createSelectBuilder()
SQLBuilder.TableNameBuilder	createTableNameBuilder()
Formatter	formatter()
H2SpatialHelper	getHelper()
int	getMaxRecomendedSQLLength()
Disposable	setParameters(java.sql.PreparedStatement st, FeatureProvider feature)
Disposable	setStatementParameters(java.sql.PreparedStatement st, java.util.List values, java.util.List<java.lang.Integer> types, GeometryExpressionBuilderHelper.GeometrySupportType geometrySupportType)
java.lang.Object	sqlgeometrydimension(int type, int subtype)
java.lang.Object	sqlgeometrynumdimension(int type, int subtype)
java.lang.Object	sqlgeometrytype(int geomtype, int geomsubtype)
java.lang.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_from, column_from, column, column, column, 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_names, parameters, quote_for_identifiers, quote_for_strings, select, setProperties, setProperties, support_schemas, table_name, toString, toString, update_table_statistics, update, variables_names, variables

Methods inherited from class java.lang.Object

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

Field Detail

formatter

protected Formatter formatter

Constructor Detail

H2SpatialSQLBuilder

public H2SpatialSQLBuilder(H2SpatialHelper helper)

Method Detail

formatter

public Formatter formatter()

Specified by:

formatter in interface SQLBuilder

Overrides:

formatter in class SQLBuilderBase

sqlgeometrydimension

public java.lang.Object sqlgeometrydimension(int type,
                                             int subtype)

Specified by:

sqlgeometrydimension in interface SQLBuilder

Overrides:

sqlgeometrydimension in class SQLBuilderBase

sqltype

public java.lang.String sqltype(int type,
                                int size,
                                int precision,
                                int scale,
                                int geomtype,
                                int geomSubtype)

Specified by:

sqltype in interface SQLBuilder

Overrides:

sqltype in class SQLBuilderBase

sqlgeometrytype

public java.lang.Object sqlgeometrytype(int geomtype,
                                        int geomsubtype)

Specified by:

sqlgeometrytype in interface SQLBuilder

Overrides:

sqlgeometrytype in class SQLBuilderBase

sqlgeometrynumdimension

public java.lang.Object sqlgeometrynumdimension(int type,
                                                int subtype)

getHelper

public H2SpatialHelper getHelper()

Overrides:

getHelper in class JDBCSQLBuilderBase

setParameters

public Disposable setParameters(java.sql.PreparedStatement st,
                                FeatureProvider feature)

Overrides:

setParameters in class JDBCSQLBuilderBase

createAlterTableBuilder

protected SQLBuilder.AlterTableBuilder createAlterTableBuilder()

Overrides:

createAlterTableBuilder in class SQLBuilderBase

createTableNameBuilder

public SQLBuilder.TableNameBuilder createTableNameBuilder()

Specified by:

createTableNameBuilder in interface SQLBuilder

Overrides:

createTableNameBuilder in class SQLBuilderBase

createCreateTableBuilder

protected SQLBuilder.CreateTableBuilder createCreateTableBuilder()

Overrides:

createCreateTableBuilder in class SQLBuilderBase

createSelectBuilder

public SQLBuilder.SelectBuilder createSelectBuilder()

Specified by:

createSelectBuilder in interface SQLBuilder

Overrides:

createSelectBuilder in class SQLBuilderBase

createCreateIndexBuilder

public SQLBuilder.CreateIndexBuilder createCreateIndexBuilder()

Overrides:

createCreateIndexBuilder in class SQLBuilderBase

setStatementParameters

public Disposable setStatementParameters(java.sql.PreparedStatement st,
                                         java.util.List values,
                                         java.util.List<java.lang.Integer> types,
                                         GeometryExpressionBuilderHelper.GeometrySupportType geometrySupportType)
                                  throws java.sql.SQLException

Overrides:

setStatementParameters in class JDBCSQLBuilderBase

Throws:

java.sql.SQLException

getMaxRecomendedSQLLength

public int getMaxRecomendedSQLLength()

Specified by:

getMaxRecomendedSQLLength in interface SQLBuilder

Overrides:

getMaxRecomendedSQLLength in class SQLBuilderBase