planetj.database
Class SQLServerDBSystem

java.lang.Object
  planetj.database.DBSystem
      planetj.database.SQLServerDBSystem

All Implemented Interfaces:

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

public class SQLServerDBSystem

extends DBSystem

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

See Also:

Serialized Form

Field Summary

static java.lang.String

DRIVER SQL Server driver

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	SQLServerDBSystem() SQLServerDBSystem constructor comment.
protected	SQLServerDBSystem(java.lang.String url) SQLServerDBSystem constructor comment.
protected	SQLServerDBSystem(java.lang.String pURL, java.lang.String pAlias) SQLServerDBSystem constructor comment.

Method Summary

java.lang.Object	correctDatabaseObject(java.lang.Object object, int datatype) Returns an object of the appropriate type for insertion into the database.
java.lang.String	getLibraryTableSeparator() Get the separator that should be placed between a library and a table for the system.

Methods inherited from class planetj.database.DBSystem

addSQLTypeName, correctOperation, correctOperationSQL, correctSQLLiteral, createLibrary, createSystem, createSystem, createSystem, createSystem, getAlias, getAllLibraries, getCache, getColumnDataTypeName, getColumnIndicationCharacter, getColumnPrimaryKeyName, getDataType, getDBLibraryName, getDefaultDateFormat, getDefaultLibraryName, getDefaultTimeFormat, getDefaultTimestampFormat, getFieldClassForSQLTypeName, getIPAddress, getLibraries, getLibrary, getLibrary, getLibrarySupportLevel, getMetaDataAlias, getMetadataColumns, getMetadataLibraries, getMetaDataSystem, getMetadataTables, getName, getProperties, getSQLTypeNames, getSupportedDataType, getSystem, getURL, getXMLData, handleConnectionEvent, isAS400, isBackgroundThreadsSupported, isDB2, isDefaultLibraryOmitted, isDelegateToPersonal, isHasAllLibraries, isMSAccess, isMySQL, isOracle, isSQLServer, removeLibrary, setAlias, setDelegateToPersonal, setMetaDataAlias, setProperties, 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

SQL Server driver

See Also:

Constant Field Values

Constructor Detail

SQLServerDBSystem

protected SQLServerDBSystem()

SQLServerDBSystem constructor comment.

SQLServerDBSystem

protected SQLServerDBSystem(java.lang.String url)

SQLServerDBSystem constructor comment.

Parameters:

url - java.lang.String

SQLServerDBSystem

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

SQLServerDBSystem constructor comment.

Parameters:

pURL - java.lang.String

pAlias - java.lang.String

Method Detail

correctDatabaseObject

public java.lang.Object correctDatabaseObject(java.lang.Object object,
                                              int datatype)

Returns an object of the appropriate type for insertion into the database. In some cases, the default object type for a given datatype may not be appropriate for a given DB system - this method addresses that issue

Overrides:

correctDatabaseObject in class DBSystem

Parameters:

object - The object to be inserted into the database

datatype - The datatype of the database field

Returns:

The corrected object to be inserted into the database

getLibraryTableSeparator

public java.lang.String getLibraryTableSeparator()

Description copied from class: DBSystem

Get the separator that should be placed between a library and a table for the system. e.g. LibraryName.Table or LibraryName..Table

Overrides:

getLibraryTableSeparator in class DBSystem