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, quoteTimestampLiteral
public String getConcatenationExpression(String[] sqlFragments)
Vendor
a
and b
is
"a || b
" in standard SQL, but CONCAT(a, b)
in MySQL.getConcatenationExpression
in interface Vendor
getConcatenationExpression
in class SQL92
sqlFragments
- An array of SQL expressions to be concatenatedpublic String quoteIdentifier(String identifier)
Vendor
quoteIdentifier
in interface Vendor
quoteIdentifier
in class SQL92
identifier
- An identifier, such as a table or column namepublic String quoteStringLiteral(String s)
Vendor
quoteStringLiteral
in interface Vendor
quoteStringLiteral
in class SQL92
s
- An arbitrary character stringpublic Properties getDefaultConnectionProperties()
Vendor
getDefaultConnectionProperties
in interface Vendor
getDefaultConnectionProperties
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 broken