org.openrdf.sesame.sailimpl.rdbms
Class MySQL

java.lang.Object
  org.openrdf.sesame.sailimpl.rdbms.RDBMS
      org.openrdf.sesame.sailimpl.rdbms.MySQL

public class MySQL

extends RDBMS

Defines MySQL specific SQL syntax.

Author:

Arjohn Kampman

Field Summary

Fields inherited from class org.openrdf.sesame.sailimpl.rdbms.RDBMS

BOOLEAN, BOOLEAN_TYPE, FALSE, ID_INT, ID_INT_TYPE, INFOFIELD, INFOFIELD_TYPE, LABEL, LABEL_HASH, LABEL_HASH_TYPE, LABEL_TYPE, LANGUAGE, LANGUAGE_TYPE, LOCALNAME, LOCALNAME_TYPE, MAX_PREFIX_LENGTH, NAME, NAME_TYPE, PREFIX, PREFIX_TYPE, TRUE

Constructor Summary

MySQL()
Initializes MySQL specific SQL syntax.

Method Summary

void	dropIndex(String table, String[] columns) Overrides dropIndex in RDBMS.
int	getMajorVersion()
int	getMinorVersion()
String	getPatternMatchExpr(String pattern, boolean caseSensitive)
String	getPatternMatchOperator(boolean caseSensitive)
void	optimizeTable(String tableName) Optimizes a table.
void	renameTableColumn(String tableName, String currentColumnName, String newColumnName, String columnSignature)
boolean	supportsPatternMatches(boolean caseSensitive)

Methods inherited from class org.openrdf.sesame.sailimpl.rdbms.RDBMS

clearTable, convertBoolean, copyDistinctRows, copyRows, createIndex, createIndex, createInstance, createUniqueIndex, disconnect, dropIndex, dropTable, emptyStringIsNull, escapeString, executeUpdate, getConnection, getIndexName, getIndexName, getSearchStringEscape, optimizeTable, queryHasResults, renameTable, setConnectionInfo, supportsLikeEscapeClause, tableExists

Methods inherited from class java.lang.Object

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

Constructor Detail

MySQL

public MySQL()

Initializes MySQL specific SQL syntax.

Method Detail

getMajorVersion

public int getMajorVersion()

getMinorVersion

public int getMinorVersion()

dropIndex

public void dropIndex(String table,
                      String[] columns)
               throws SQLException

Overrides dropIndex in RDBMS. In MySQL, an index is identified by both its index and table name.

Overrides:

dropIndex in class RDBMS

Parameters:

table - The table name.

columns - The column names.

Throws:

SQLException

optimizeTable

public void optimizeTable(String tableName)
                   throws SQLException

Description copied from class: RDBMS

Optimizes a table. The actual action taken depends on the database.

Overrides:

optimizeTable in class RDBMS

Throws:

SQLException

renameTableColumn

public void renameTableColumn(String tableName,
                              String currentColumnName,
                              String newColumnName,
                              String columnSignature)
                       throws SQLException

Overrides:

renameTableColumn in class RDBMS

Throws:

SQLException

supportsPatternMatches

public boolean supportsPatternMatches(boolean caseSensitive)

Overrides:

supportsPatternMatches in class RDBMS

getPatternMatchOperator

public String getPatternMatchOperator(boolean caseSensitive)

Overrides:

getPatternMatchOperator in class RDBMS

getPatternMatchExpr

public String getPatternMatchExpr(String pattern,
                                  boolean caseSensitive)

Overrides:

getPatternMatchExpr in class RDBMS