| Modifier and Type | Class and Description |
|---|---|
static class |
MySQL.MySQLCompatibilityBitDataType |
static class |
MySQL.MySQLCompatibilityDateDataType |
static class |
MySQL.MySQLCompatibilityTimeDataType |
static class |
MySQL.MySQLCompatibilityTimestampDataType |
HSQLDB, InterbaseOrFirebird, MSAccess, MySQL, Oracle, PostgreSQL, SQL92, SQLServer| Constructor and Description |
|---|
MySQL() |
| Modifier and Type | Method and Description |
|---|---|
String |
getConcatenationExpression(String[] sqlFragments)
Concatenation of
a and b is
"a || b" in standard SQL, but CONCAT(a, b)
in MySQL. |
DataType |
getDataType(int jdbcType,
String name,
int size)
Returns a
DataType corresponding to a JDBC type. |
Properties |
getDefaultConnectionProperties()
Returns a set of default connection properties to be used
when connecting to this database engine type
|
String |
quoteIdentifier(String identifier)
Handles special characters in identifiers.
|
String |
quoteStringLiteral(String s)
Handles special characters in strings.
|
afterCancel, afterClose, afterQuery, beforeCancel, beforeClose, beforeQuery, booleanExpressionToSimpleExpression, getRelationNameAliasExpression, getRowNumLimitAsExpression, getRowNumLimitAsQueryAppendage, getRowNumLimitAsSelectModifier, initializeConnection, isIgnoredTable, quoteAttribute, quoteBinaryLiteral, quoteDateLiteral, quoteRelationName, quoteTimeLiteral, quoteTimestampLiteralpublic String getConcatenationExpression(String[] sqlFragments)
Vendora and b is
"a || b" in standard SQL, but CONCAT(a, b)
in MySQL.getConcatenationExpression in interface VendorgetConcatenationExpression in class SQL92sqlFragments - An array of SQL expressions to be concatenatedpublic String quoteIdentifier(String identifier)
VendorquoteIdentifier in interface VendorquoteIdentifier in class SQL92identifier - An identifier, such as a table or column namepublic String quoteStringLiteral(String s)
VendorquoteStringLiteral in interface VendorquoteStringLiteral in class SQL92s - An arbitrary character stringpublic Properties getDefaultConnectionProperties()
VendorgetDefaultConnectionProperties in interface VendorgetDefaultConnectionProperties in class SQL92public DataType getDataType(int jdbcType, String name, int size)
VendorDataType 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 VendorgetDataType in class SQL92jdbcType - 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 broken