HSQLDB, InterbaseOrFirebird, MSAccess, MySQL, Oracle, PostgreSQL, SQL92, SQLServer
Constructor and Description |
---|
SQLServer() |
Modifier and Type | Method and Description |
---|---|
Expression |
booleanExpressionToSimpleExpression(Expression expression)
Expressions can not return true or false in Microsoft SQL
Server.
|
DataType |
getDataType(int jdbcType,
String name,
int size)
Returns a
DataType corresponding to a JDBC type. |
String |
getRowNumLimitAsQueryAppendage(int limit)
Technically speaking, SQL 92 supports NO way of limiting
result sets (ROW_NUMBER appeared in SQL 2003).
|
String |
getRowNumLimitAsSelectModifier(int limit)
Returns a modifier for the SELECT keyword that adds a limit
to the number of returned rows for engines that support this (
TOP n ) |
boolean |
isIgnoredTable(String schema,
String table)
TODO Use the Filter interface for this
|
String |
quoteBinaryLiteral(String hexString) |
String |
quoteDateLiteral(String date) |
String |
quoteTimeLiteral(String time) |
String |
quoteTimestampLiteral(String timestamp) |
afterCancel, afterClose, afterQuery, beforeCancel, beforeClose, beforeQuery, getConcatenationExpression, getDefaultConnectionProperties, getRelationNameAliasExpression, getRowNumLimitAsExpression, initializeConnection, quoteAttribute, quoteIdentifier, quoteRelationName, quoteStringLiteral
public String getRowNumLimitAsSelectModifier(int limit)
Vendor
TOP n
)getRowNumLimitAsSelectModifier
in interface Vendor
getRowNumLimitAsSelectModifier
in class SQL92
limit
- A maximum number of rows, or Database.NO_LIMIT
public String getRowNumLimitAsQueryAppendage(int limit)
SQL92
getRowNumLimitAsQueryAppendage
in interface Vendor
getRowNumLimitAsQueryAppendage
in class SQL92
limit
- A maximum number of rows, or Database.NO_LIMIT
public String quoteBinaryLiteral(String hexString)
quoteBinaryLiteral
in interface Vendor
quoteBinaryLiteral
in class SQL92
public String quoteDateLiteral(String date)
quoteDateLiteral
in interface Vendor
quoteDateLiteral
in class SQL92
public String quoteTimeLiteral(String time)
quoteTimeLiteral
in interface Vendor
quoteTimeLiteral
in class SQL92
public String quoteTimestampLiteral(String timestamp)
quoteTimestampLiteral
in interface Vendor
quoteTimestampLiteral
in class SQL92
public DataType getDataType(int jdbcType, String name, int size)
Vendor
DataType
corresponding to a JDBC type. This may be
an unsupported datatype; in this case, its DataType.isUnsupported()
method will return true. null
will be returned if the vendor
code doesn't handle this datatype at all; that should generally be
considered a bug.getDataType
in interface Vendor
getDataType
in class SQL92
jdbcType
- A java.sql.Types
constantname
- The type name, as reported by java.sql
metadata methods, normalized to uppercasesize
- Character size of the type, or 0 if not applicablenull
if the vendor code is brokenpublic Expression booleanExpressionToSimpleExpression(Expression expression)
booleanExpressionToSimpleExpression
in interface Vendor
booleanExpressionToSimpleExpression
in class SQL92
expression
- A boolean expressionpublic boolean isIgnoredTable(String schema, String table)
Vendor
isIgnoredTable
in interface Vendor
isIgnoredTable
in class SQL92
schema
- A schema name, or null
for the connection's default schematable
- A table nametrue
if this is a system table that doesn't contain user/application data