Package nl.b3p.jdbc.util.converter
Class MssqlJdbcConverter
java.lang.Object
nl.b3p.jdbc.util.converter.GeometryJdbcConverter
nl.b3p.jdbc.util.converter.MssqlJdbcConverter
- Author:
- Matthijs Laan, mprins
-
Field Summary
Fields inherited from class nl.b3p.jdbc.util.converter.GeometryJdbcConverter
gf, wkt
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionbuildLimitSql
(StringBuilder sql, int limit) buildPaginationSql
(String sql, int offset, int limit) org.locationtech.jts.geom.Geometry
convertToJTSGeometryObject
(Object nativeObj) convertToNativeGeometryObject
(org.locationtech.jts.geom.Geometry g) convertToNativeGeometryObject
(org.locationtech.jts.geom.Geometry g, int srid) getMViewRefreshSQL
(String mview) return een dummy query omdat mssql geen materialized views kent.return een dummy query omdat mssql geen materialized views kent.getSelectNextValueFromSequenceSQL
(String seqName) get the database flavour specific SQL statement to get the next value from a sequence.boolean
isDuplicateKeyViolationMessage
(String message) boolean
isFKConstraintViolationMessage
(String message) bepaal of een melding een constraint violation betreft.boolean
void
boolean
Methods inherited from class nl.b3p.jdbc.util.converter.GeometryJdbcConverter
convertToNativeGeometryObject, convertToSQLObject, createNativePoint, createPSGeometryPlaceholder, getUpdateSequenceSQL
-
Constructor Details
-
MssqlJdbcConverter
public MssqlJdbcConverter()
-
-
Method Details
-
isDuplicateKeyViolationMessage
- Specified by:
isDuplicateKeyViolationMessage
in classGeometryJdbcConverter
-
isFKConstraintViolationMessage
Description copied from class:GeometryJdbcConverter
bepaal of een melding een constraint violation betreft.- Specified by:
isFKConstraintViolationMessage
in classGeometryJdbcConverter
- Parameters:
message
- de melding uit de database- Returns:
true
als de melding een contraint violation betreft
-
convertToNativeGeometryObject
public Object convertToNativeGeometryObject(org.locationtech.jts.geom.Geometry g, int srid) throws SQLException - Specified by:
convertToNativeGeometryObject
in classGeometryJdbcConverter
- Throws:
SQLException
-
convertToNativeGeometryObject
public Object convertToNativeGeometryObject(org.locationtech.jts.geom.Geometry g) throws SQLException - Specified by:
convertToNativeGeometryObject
in classGeometryJdbcConverter
- Throws:
SQLException
-
getSchema
- Specified by:
getSchema
in classGeometryJdbcConverter
-
setSchema
-
getGeomTypeName
- Specified by:
getGeomTypeName
in classGeometryJdbcConverter
-
buildPaginationSql
- Specified by:
buildPaginationSql
in classGeometryJdbcConverter
-
buildLimitSql
- Specified by:
buildLimitSql
in classGeometryJdbcConverter
-
useSavepoints
public boolean useSavepoints()- Specified by:
useSavepoints
in classGeometryJdbcConverter
-
isPmdKnownBroken
public boolean isPmdKnownBroken()- Specified by:
isPmdKnownBroken
in classGeometryJdbcConverter
-
getGeotoolsDBTypeName
- Specified by:
getGeotoolsDBTypeName
in classGeometryJdbcConverter
-
getMViewsSQL
return een dummy query omdat mssql geen materialized views kent.- Specified by:
getMViewsSQL
in classGeometryJdbcConverter
- Returns:
- een dummy select query omdat mssql geen materialized views kent.
-
getMViewRefreshSQL
return een dummy query omdat mssql geen materialized views kent.- Specified by:
getMViewRefreshSQL
in classGeometryJdbcConverter
- Returns:
- een dummy update query omdat mssql geen materialized views kent.
-
getSelectNextValueFromSequenceSQL
Description copied from class:GeometryJdbcConverter
get the database flavour specific SQL statement to get the next value from a sequence.- Specified by:
getSelectNextValueFromSequenceSQL
in classGeometryJdbcConverter
- Parameters:
seqName
- name of sequence- Returns:
- SQL statement specific for the flavour of database
-
convertToJTSGeometryObject
- Specified by:
convertToJTSGeometryObject
in classGeometryJdbcConverter
-