org.apache.marmotta.kiwi.persistence.mysql

Class MySQLDialect

java.lang.Object

org.apache.marmotta.kiwi.persistence.KiWiDialect

org.apache.marmotta.kiwi.persistence.mysql.MySQLDialect

public class MySQLDialect
extends KiWiDialect

A dialect for MySQL. When using MySQL, make sure the JDBC connection URL has the following arguments (workarounds for non-standard MySQL behaviour):

• characterEncoding=utf8
• zeroDateTimeBehavior=convertToNull

Otherwise MySQL will not behave correctly. For example use a connection URL like: jdbc:mysql://localhost:3306/kiwitest?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull

Author: Sebastian Schaffert

Field Summary

Fields inherited from class org.apache.marmotta.kiwi.persistence.KiWiDialect

VERSION

Constructor Summary

Constructors

Constructor and Description
MySQLDialect()

Method Summary

Methods

Modifier and Type	Method and Description
String	getDateTimeTZ(String alias) Return the SQL timezone value for a KiWiDateLiteral, corrected by the timezone offset.
String	getDriverClass() Return the name of the driver class (used for properly initialising JDBC connections)
String	getGroupConcat(String value, String separator, boolean distinct) Return the name of the aggregate function for group concatenation (string_agg in postgres, GROUP_CONCAT in MySQL)
String	getILike(String text, String pattern) Return the database specific case insensitive like comparison, e.g.
String	getRegexp(String text, String pattern, String flags) Return the database specific operator for matching a text against a regular expression.
String	getValidationQuery() Get the query string that can be used for validating that a JDBC connection to this database is still valid.
boolean	isBatchSupported() Return true if batched commits are supported by this dialect.
boolean	isRegexpSupported(String flags) Return true in case the SPARQL RE flags contained in the given string are supported.

Methods inherited from class org.apache.marmotta.kiwi.persistence.KiWiDialect

getCreateScript, getDropScript, getMigrationScript, getScript, getStatement, getStatementIdentifiers, getVersion, hasStatement, isArraySupported, isCursorSupported

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

MySQLDialect

public MySQLDialect()
             throws DriverNotFoundException

Throws:

DriverNotFoundException

Method Detail

getDriverClass

public String getDriverClass()

Return the name of the driver class (used for properly initialising JDBC connections)

Specified by:

getDriverClass in class KiWiDialect

Returns:

isBatchSupported

public boolean isBatchSupported()

Description copied from class: KiWiDialect

Return true if batched commits are supported by this dialect.

Specified by:

isBatchSupported in class KiWiDialect

Returns:

getRegexp

public String getRegexp(String text,
               String pattern,
               String flags)

Description copied from class: KiWiDialect

Return the database specific operator for matching a text against a regular expression.

Specified by:

getRegexp in class KiWiDialect

Returns:

isRegexpSupported

public boolean isRegexpSupported(String flags)

Return true in case the SPARQL RE flags contained in the given string are supported.

Specified by:

isRegexpSupported in class KiWiDialect

Parameters:

flags -

Returns:

getILike

public String getILike(String text,
              String pattern)

Description copied from class: KiWiDialect

Return the database specific case insensitive like comparison, e.g. ILIKE in Postgres.

Specified by:

getILike in class KiWiDialect

Returns:

getGroupConcat

public String getGroupConcat(String value,
                    String separator,
                    boolean distinct)

Return the name of the aggregate function for group concatenation (string_agg in postgres, GROUP_CONCAT in MySQL)

Specified by:

getGroupConcat in class KiWiDialect

Parameters:

value -

separator -

Returns:

getDateTimeTZ

public String getDateTimeTZ(String alias)

Return the SQL timezone value for a KiWiDateLiteral, corrected by the timezone offset. In PostgreSQL, this is e.g. computed by (ALIAS.tvalue + ALIAS.tzoffset * INTERVAL '1 second')

Specified by:

getDateTimeTZ in class KiWiDialect

Parameters:

alias -

Returns:

getValidationQuery

public String getValidationQuery()

Get the query string that can be used for validating that a JDBC connection to this database is still valid. Typically, this should be an inexpensive operation like "SELECT 1",

Specified by:

getValidationQuery in class KiWiDialect

Returns: