planetj.database
Class MySQLDBSystem

java.lang.Object
  |
  +--planetj.database.DBSystem
        |
        +--planetj.database.MySQLDBSystem

All Implemented Interfaces:

EventListener, IDBObject, ITaskListener, IXMLObject, Serializable

public class MySQLDBSystem

extends DBSystem

See Also:

Serialized Form

Field Summary

static String

DRIVER MYSQL driver

Fields inherited from class planetj.database.DBSystem

LIBRARIES_NOT_SUPPORTED, LIBRARIES_REQUIRED, LIBRARIES_SUPPORTED

Method Summary

String	getColumnIndicationCharacter() Returns the character that needs to be used during an insert.
byte	getLibrarySupportLevel() Gets the level of library support; this is one of the constants defined in the class.

Methods inherited from class planetj.database.DBSystem

correctDatabaseObject, createLibrary, createSystem, createSystem, createSystem, createSystem, getAlias, getAllLibraries, getCache, getDefaultDateFormat, getDefaultLibraryName, getFieldClassForSQLTypeName, getIPAddress, getLibraries, getLibrary, getLibrary, getMetaDataAlias, getMetaDataSystem, getName, getProperties, getSQLTypeNames, getSupportedDataType, getSystem, getURL, getXMLData, isBackgroundThreadsSupported, isDefaultLibraryOmitted, isDelegateToPersonal, isHasAllLibraries, removeLibrary, setDelegateToPersonal, setProperties, startRetrieveAllLibrariesTask, taskCompleted, taskFailed, taskStarted, toString

Methods inherited from class java.lang.Object

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

Field Detail

DRIVER

public static final String DRIVER

MYSQL driver

See Also:

Constant Field Values

Method Detail

getColumnIndicationCharacter

public String getColumnIndicationCharacter()

Returns the character that needs to be used during an insert. This char may be different for different DBSystems, so if necessary, override this method to return the required char An Example in MySQL: insert into depvdta (`TYPE`, `key`, `value`) values (6, 'HeHa', 'Yo') In this example the MySQLDBSystem should return a ` char The AS400DBSystem would return a " char

This char will is necessary when a column name is the same as a reserved keyword for this DBSystem. Such as KEY or USER Creation date: (6/23/2003 2:27:41 PM)

Overrides:

getColumnIndicationCharacter in class DBSystem

getLibrarySupportLevel

public byte getLibrarySupportLevel()

Gets the level of library support; this is one of the constants defined in the class. By default, libraries are required. Subclasses may override this method to indicate a different level of library support.

Overrides:

getLibrarySupportLevel in class DBSystem