planetj.database
Class AS400DBSystem

java.lang.Object
  planetj.database.DBSystem
      planetj.database.AS400DBSystem

All Implemented Interfaces:

java.util.EventListener, IDBObject, ITaskListener, IXMLObject, java.io.Serializable

public class AS400DBSystem

extends DBSystem

Insert the type's description here. Creation date: (11/29/2002 1:14:19 PM)

See Also:

Serialized Form

Field Summary

static java.lang.String	DEFAULT_CONNECTION_PROPERTIES
static java.lang.String	DRIVER AS400 driver
static java.lang.String	NATIVE_DRIVER
static java.lang.String	PROMPT_EQUALS_FALSE
static java.lang.String	SORT_EQUALS_LANGUAGE
static java.lang.String	TRACE_EQUALS_FALSE
static java.lang.String	TRANSLATE_BINARY_EQUALS_TRUE

Fields inherited from class planetj.database.DBSystem

LIBRARIES_NOT_SUPPORTED, LIBRARIES_REQUIRED, LIBRARIES_SUPPORTED, METADATA_CATALOG_NAME_FIELD, METADATA_COLUMN_NAME_FIELD, METADATA_COLUMN_NAME_OPERATION, METADATA_COLUMN_NAME_OPERATION_FOR_CATALOGS, METADATA_LIBRARY_NAME, METADATA_LIBRARY_NAME_FIELD, METADATA_SYSTEM_NAME_FIELD, METADATA_TABLE_NAME_FIELD, METADATA_TABLE_NAME_FOR_COLUMNS, METADATA_TABLE_NAME_FOR_LIBRARIES, METADATA_TABLE_NAME_FOR_TABLES, METADATA_TABLE_NAME_OPERATION, METADATA_TABLE_NAME_OPERATION_FOR_CATALOGS

Constructor Summary

protected	AS400DBSystem() AS400DatabaseSystem constructor comment.
protected	AS400DBSystem(java.lang.String url) AS400DatabaseSystem constructor comment.
protected	AS400DBSystem(java.lang.String pURL, java.lang.String pAlias) AS400DatabaseSystem constructor comment.

Method Summary

java.lang.String	getColumnIndicationCharacter() Returns the character that needs to be used during an insert.
java.lang.String	getProperties() Gets the connection JDBC properties of the system.
void	setProperties(java.lang.String properties) Sets the connection JDBC properties of the system.

Methods inherited from class planetj.database.DBSystem

addSQLTypeName, correctDatabaseObject, correctOperation, correctOperationSQL, correctSQLLiteral, createLibrary, createSystem, createSystem, createSystem, createSystem, getAlias, getAllLibraries, getCache, getColumnDataTypeName, getColumnPrimaryKeyName, getDataType, getDBLibraryName, getDefaultDateFormat, getDefaultLibraryName, getDefaultTimeFormat, getDefaultTimestampFormat, getFieldClassForSQLTypeName, getIPAddress, getLibraries, getLibrary, getLibrary, getLibrarySupportLevel, getLibraryTableSeparator, getMetaDataAlias, getMetadataColumns, getMetadataLibraries, getMetaDataSystem, getMetadataTables, getName, getSQLTypeNames, getSupportedDataType, getSystem, getURL, getXMLData, handleConnectionEvent, isAS400, isBackgroundThreadsSupported, isDB2, isDefaultLibraryOmitted, isDelegateToPersonal, isHasAllLibraries, isMSAccess, isMySQL, isOracle, isSQLServer, removeLibrary, setAlias, setDelegateToPersonal, setMetaDataAlias, setURL, setURLInternal, startRetrieveAllLibrariesTask, taskCompleted, taskFailed, taskStarted, toString

Methods inherited from class java.lang.Object

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

Field Detail

DRIVER

public static final java.lang.String DRIVER

AS400 driver

See Also:

Constant Field Values

NATIVE_DRIVER

public static final java.lang.String NATIVE_DRIVER

See Also:

Constant Field Values

PROMPT_EQUALS_FALSE

public static final java.lang.String PROMPT_EQUALS_FALSE

See Also:

Constant Field Values

TRACE_EQUALS_FALSE

public static final java.lang.String TRACE_EQUALS_FALSE

See Also:

Constant Field Values

TRANSLATE_BINARY_EQUALS_TRUE

public static final java.lang.String TRANSLATE_BINARY_EQUALS_TRUE

See Also:

Constant Field Values

SORT_EQUALS_LANGUAGE

public static final java.lang.String SORT_EQUALS_LANGUAGE

See Also:

Constant Field Values

DEFAULT_CONNECTION_PROPERTIES

public static final java.lang.String DEFAULT_CONNECTION_PROPERTIES

See Also:

Constant Field Values

Constructor Detail

AS400DBSystem

protected AS400DBSystem()

AS400DatabaseSystem constructor comment.

AS400DBSystem

protected AS400DBSystem(java.lang.String url)

AS400DatabaseSystem constructor comment.

Parameters:

url - java.lang.String

AS400DBSystem

protected AS400DBSystem(java.lang.String pURL,
                        java.lang.String pAlias)

AS400DatabaseSystem constructor comment.

Parameters:

pURL - java.lang.String

pAlias - java.lang.String

Method Detail

getColumnIndicationCharacter

public java.lang.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

getProperties

public java.lang.String getProperties()

Description copied from class: DBSystem

Gets the connection JDBC properties of the system.

Overrides:

getProperties in class DBSystem

Returns:

String

setProperties

public void setProperties(java.lang.String properties)

Description copied from class: DBSystem

Sets the connection JDBC properties of the system.

Overrides:

setProperties in class DBSystem