Package org.citydb.database.adapter.h2
Class SQLAdapter
- java.lang.Object
-
- org.citydb.database.adapter.AbstractSQLAdapter
-
- org.citydb.database.adapter.h2.SQLAdapter
-
public class SQLAdapter extends AbstractSQLAdapter
-
-
Field Summary
-
Fields inherited from class org.citydb.database.adapter.AbstractSQLAdapter
databaseAdapter, databaseOperations
-
-
Constructor Summary
Constructors Modifier Constructor Description protected
SQLAdapter(AbstractDatabaseAdapter databaseAdapter)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description org.citydb.sqlbuilder.select.projection.Function
getAggregateExtentFunction(org.citydb.sqlbuilder.schema.Column envelope)
java.lang.String
getBigInt()
org.citydb.sqlbuilder.select.PredicateToken
getBinarySpatialPredicate(SpatialOperatorName operator, org.citydb.sqlbuilder.schema.Column targetColumn, GeometryObject geometry, boolean negate)
BlobExportAdapter
getBlobExportAdapter(java.sql.Connection connection, BlobType type)
BlobImportAdapter
getBlobImportAdapter(java.sql.Connection connection, BlobType type)
java.lang.String
getCharacter(int nrOfChars)
java.lang.String
getCharacterVarying(int nrOfChars)
java.lang.String
getCreateUnloggedTable(java.lang.String tableName, java.lang.String columns)
java.lang.String
getCreateUnloggedTableAsSelect(java.lang.String tableName, java.lang.String select)
java.lang.String
getCurrentSequenceValue(java.lang.String sequence)
org.citydb.sqlbuilder.select.PredicateToken
getDistancePredicate(SpatialOperatorName operator, org.citydb.sqlbuilder.schema.Column targetColumn, GeometryObject geometry, double distance, boolean negate)
java.lang.String
getDoublePrecision()
java.lang.String
getHierarchicalGeometryQuery()
java.lang.String
getInteger()
int
getMaximumNumberOfItemsForInOperator()
java.lang.String
getNextSequenceValue(java.lang.String sequence)
java.lang.String
getNextSequenceValuesQuery(java.lang.String sequence)
java.lang.String
getNumeric()
java.lang.String
getNumeric(int precision)
java.lang.String
getNumeric(int precision, int scale)
java.lang.String
getPolygon2D()
java.lang.String
getPseudoTableName()
java.lang.String
getReal()
java.lang.String
getSmallInt()
java.lang.String
getUnloggedIndexProperty()
boolean
requiresPseudoTableInSelect()
boolean
spatialPredicateRequiresNoIndexHint()
boolean
supportsFetchFirstClause()
-
Methods inherited from class org.citydb.database.adapter.AbstractSQLAdapter
fillPlaceHolders, prepareStatement, resolveDatabaseOperationName
-
-
-
-
Constructor Detail
-
SQLAdapter
protected SQLAdapter(AbstractDatabaseAdapter databaseAdapter)
-
-
Method Detail
-
getInteger
public java.lang.String getInteger()
- Specified by:
getInteger
in classAbstractSQLAdapter
-
getSmallInt
public java.lang.String getSmallInt()
- Specified by:
getSmallInt
in classAbstractSQLAdapter
-
getBigInt
public java.lang.String getBigInt()
- Specified by:
getBigInt
in classAbstractSQLAdapter
-
getNumeric
public java.lang.String getNumeric()
- Specified by:
getNumeric
in classAbstractSQLAdapter
-
getNumeric
public java.lang.String getNumeric(int precision)
- Specified by:
getNumeric
in classAbstractSQLAdapter
-
getNumeric
public java.lang.String getNumeric(int precision, int scale)
- Specified by:
getNumeric
in classAbstractSQLAdapter
-
getReal
public java.lang.String getReal()
- Specified by:
getReal
in classAbstractSQLAdapter
-
getDoublePrecision
public java.lang.String getDoublePrecision()
- Specified by:
getDoublePrecision
in classAbstractSQLAdapter
-
getCharacter
public java.lang.String getCharacter(int nrOfChars)
- Specified by:
getCharacter
in classAbstractSQLAdapter
-
getCharacterVarying
public java.lang.String getCharacterVarying(int nrOfChars)
- Specified by:
getCharacterVarying
in classAbstractSQLAdapter
-
getPolygon2D
public java.lang.String getPolygon2D()
- Specified by:
getPolygon2D
in classAbstractSQLAdapter
-
getCreateUnloggedTable
public java.lang.String getCreateUnloggedTable(java.lang.String tableName, java.lang.String columns)
- Specified by:
getCreateUnloggedTable
in classAbstractSQLAdapter
-
getCreateUnloggedTableAsSelect
public java.lang.String getCreateUnloggedTableAsSelect(java.lang.String tableName, java.lang.String select)
- Specified by:
getCreateUnloggedTableAsSelect
in classAbstractSQLAdapter
-
getUnloggedIndexProperty
public java.lang.String getUnloggedIndexProperty()
- Specified by:
getUnloggedIndexProperty
in classAbstractSQLAdapter
-
requiresPseudoTableInSelect
public boolean requiresPseudoTableInSelect()
- Specified by:
requiresPseudoTableInSelect
in classAbstractSQLAdapter
-
getPseudoTableName
public java.lang.String getPseudoTableName()
- Specified by:
getPseudoTableName
in classAbstractSQLAdapter
-
getMaximumNumberOfItemsForInOperator
public int getMaximumNumberOfItemsForInOperator()
- Specified by:
getMaximumNumberOfItemsForInOperator
in classAbstractSQLAdapter
-
spatialPredicateRequiresNoIndexHint
public boolean spatialPredicateRequiresNoIndexHint()
- Specified by:
spatialPredicateRequiresNoIndexHint
in classAbstractSQLAdapter
-
supportsFetchFirstClause
public boolean supportsFetchFirstClause()
- Specified by:
supportsFetchFirstClause
in classAbstractSQLAdapter
-
getHierarchicalGeometryQuery
public java.lang.String getHierarchicalGeometryQuery()
- Specified by:
getHierarchicalGeometryQuery
in classAbstractSQLAdapter
-
getNextSequenceValue
public java.lang.String getNextSequenceValue(java.lang.String sequence)
- Specified by:
getNextSequenceValue
in classAbstractSQLAdapter
-
getCurrentSequenceValue
public java.lang.String getCurrentSequenceValue(java.lang.String sequence)
- Specified by:
getCurrentSequenceValue
in classAbstractSQLAdapter
-
getNextSequenceValuesQuery
public java.lang.String getNextSequenceValuesQuery(java.lang.String sequence)
- Specified by:
getNextSequenceValuesQuery
in classAbstractSQLAdapter
-
getBlobImportAdapter
public BlobImportAdapter getBlobImportAdapter(java.sql.Connection connection, BlobType type) throws java.sql.SQLException
- Specified by:
getBlobImportAdapter
in classAbstractSQLAdapter
- Throws:
java.sql.SQLException
-
getBlobExportAdapter
public BlobExportAdapter getBlobExportAdapter(java.sql.Connection connection, BlobType type)
- Specified by:
getBlobExportAdapter
in classAbstractSQLAdapter
-
getBinarySpatialPredicate
public org.citydb.sqlbuilder.select.PredicateToken getBinarySpatialPredicate(SpatialOperatorName operator, org.citydb.sqlbuilder.schema.Column targetColumn, GeometryObject geometry, boolean negate)
- Specified by:
getBinarySpatialPredicate
in classAbstractSQLAdapter
-
getDistancePredicate
public org.citydb.sqlbuilder.select.PredicateToken getDistancePredicate(SpatialOperatorName operator, org.citydb.sqlbuilder.schema.Column targetColumn, GeometryObject geometry, double distance, boolean negate)
- Specified by:
getDistancePredicate
in classAbstractSQLAdapter
-
getAggregateExtentFunction
public org.citydb.sqlbuilder.select.projection.Function getAggregateExtentFunction(org.citydb.sqlbuilder.schema.Column envelope)
- Specified by:
getAggregateExtentFunction
in classAbstractSQLAdapter
-
-