Package org.eclipse.net4j.db.mysql
Class MYSQLAdapter
- java.lang.Object
-
- org.eclipse.net4j.spi.db.DBAdapter
-
- org.eclipse.net4j.db.mysql.MYSQLAdapter
-
- All Implemented Interfaces:
IDBAdapter
public class MYSQLAdapter extends DBAdapter
ADB adapterfor MySQL databases.- Since:
- 2.0
- Author:
- Eike Stepper
-
-
Nested Class Summary
-
Nested classes/interfaces inherited from class org.eclipse.net4j.spi.db.DBAdapter
DBAdapter.FieldInfo
-
-
Field Summary
Fields Modifier and Type Field Description static java.lang.StringNAMEstatic java.lang.StringVERSION-
Fields inherited from interface org.eclipse.net4j.db.IDBAdapter
REGISTRY
-
-
Constructor Summary
Constructors Modifier Constructor Description MYSQLAdapter()protectedMYSQLAdapter(java.lang.String name, java.lang.String version)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description protected voidaddIndexField(java.lang.StringBuilder builder, IDBField field)protected voiddropPrimaryKey(IDBIndex index, java.lang.StringBuilder builder)intgetMaxFieldNameLength()intgetMaxTableNameLength()java.lang.String[]getReservedWords()protected java.lang.StringgetTypeName(IDBField field)booleanisDuplicateKeyException(java.sql.SQLException ex)Check if an exception indicates a constraint violation (duplicate key)booleanisTypeIndexable(DBType type)java.sql.ConnectionmodifyConnection(java.sql.Connection connection)protected java.lang.StringsqlModifyField(java.lang.String tableName, java.lang.String fieldName, java.lang.String definition)java.lang.StringsqlRenameField(IDBField field, java.lang.String oldName)-
Methods inherited from class org.eclipse.net4j.spi.db.DBAdapter
adaptType, addIndex, alterTable, appendFieldDefs, appendFieldNames, convertString, convertString, convertString, convertToSQL, createConnectionProvider, createConstraints, createField, createFieldDefinition, createFieldDefinitions, createIndex, createIndex, createIndex, createIndexFields, createJDBCDataSource, createPrimaryKey, createTable, createTable, createTables, doCreateTable, dropField, dropIndex, dropIndex, dropTable, dropTable, dropTables, format, format, generateReservedWords, getDefaultDBLength, getDropTableSQL, getFieldLength, getJDBCDriver, getName, getSQL92ReservedWords, getVersion, isColumnNotFoundException, isPrimaryKeyShadow, isReservedWord, isTableNotFoundException, isValidFirstChar, openSchemaTransaction, readFields, readIndices, readIndices, readSchema, readSchema, readTables, sqlModifyField, toString, updateSchema, validateTable
-
-
-
-
Field Detail
-
NAME
public static final java.lang.String NAME
- See Also:
- Constant Field Values
-
VERSION
public static final java.lang.String VERSION
- See Also:
- Constant Field Values
-
-
Method Detail
-
getMaxTableNameLength
public int getMaxTableNameLength()
- Specified by:
getMaxTableNameLengthin interfaceIDBAdapter- Overrides:
getMaxTableNameLengthin classDBAdapter- Since:
- 2.0
-
getMaxFieldNameLength
public int getMaxFieldNameLength()
- Specified by:
getMaxFieldNameLengthin interfaceIDBAdapter- Overrides:
getMaxFieldNameLengthin classDBAdapter- Since:
- 2.0
-
getTypeName
protected java.lang.String getTypeName(IDBField field)
- Overrides:
getTypeNamein classDBAdapter
-
dropPrimaryKey
protected void dropPrimaryKey(IDBIndex index, java.lang.StringBuilder builder)
- Overrides:
dropPrimaryKeyin classDBAdapter
-
addIndexField
protected void addIndexField(java.lang.StringBuilder builder, IDBField field)- Overrides:
addIndexFieldin classDBAdapter
-
getReservedWords
public java.lang.String[] getReservedWords()
-
isTypeIndexable
public boolean isTypeIndexable(DBType type)
- Specified by:
isTypeIndexablein interfaceIDBAdapter- Overrides:
isTypeIndexablein classDBAdapter
-
isDuplicateKeyException
public boolean isDuplicateKeyException(java.sql.SQLException ex)
Description copied from interface:IDBAdapterCheck if an exception indicates a constraint violation (duplicate key)- Specified by:
isDuplicateKeyExceptionin interfaceIDBAdapter- Overrides:
isDuplicateKeyExceptionin classDBAdapter
-
sqlRenameField
public java.lang.String sqlRenameField(IDBField field, java.lang.String oldName)
- Specified by:
sqlRenameFieldin interfaceIDBAdapter- Overrides:
sqlRenameFieldin classDBAdapter
-
sqlModifyField
protected java.lang.String sqlModifyField(java.lang.String tableName, java.lang.String fieldName, java.lang.String definition)- Overrides:
sqlModifyFieldin classDBAdapter
-
modifyConnection
public java.sql.Connection modifyConnection(java.sql.Connection connection)
- Specified by:
modifyConnectionin interfaceIDBAdapter- Overrides:
modifyConnectionin classDBAdapter
-
-