com.corticon.eclipse.studio.drivers.core

Interface IDatabaseDefinition

public interface IDatabaseDefinition

Title: IDatabaseDefinition

Description: An interface for the database definition API

Method Summary

Modifier and Type	Method and Description
boolean	areCatalogsSupported(java.lang.String astrId) Retrieve the flag for the catalogs support.
boolean	areTransactionsToBeIgnored(java.lang.String astrId) Retrieve the flag which indicates whether transactions are to be ignored.
java.lang.String	findDatabaseId(java.lang.String astrDatabaseServerName) Retrieve the Database Server ID using the database server user-friendly name (reverse lookup).
java.util.List<java.lang.String>	getAuthenticationTypes(java.lang.String astrId) Retrieve the list of authentication type strings
java.util.Collection<java.lang.String>	getDatabaseIDs() Retrieve a collection of unique database definition identifiers (IDs).
java.lang.String	getDatabaseUrlTemplate(java.lang.String astrId) Retrieve a template of the database JDBC URL.
java.lang.String	getDefaultNumericIdentityStrategy(java.lang.String astrId) Retrieve the default numeric identity strategy type.
java.lang.String	getDefaultStringIdentityStrategy(java.lang.String astrId) Retrieve the default string identity strategy.
java.lang.String	getDialect(java.lang.String astrId) Retrieve the Hibernate Dialect class name be used with a particular database.
java.lang.String	getDriverClassName(java.lang.String astrId) Retrieve the JDBC driver class name associated with a particular database.
java.util.Collection<java.lang.String>	getNumericIdentityStrategies(java.lang.String astrId) Retrieve the list of numeric identity strategies
java.util.Map<java.lang.String,java.lang.String>	getReserveWordReplacements(java.lang.String astrId) Returns a map of reserve word replacements associated with the supplied database id.
java.util.Collection<java.lang.String>	getStringIdentityStrategies(java.lang.String astrId) Retrieve the list of string identity strategies
java.util.List<java.lang.String>	getSupportedSqlTypes(java.lang.String astrId, java.lang.String astrCorticonDataTypeName) Determine whether a given Corticon Data Type can be mapped to a given SQL type within the specified database.
java.lang.String	getUserFriendlyName(java.lang.String astrId) Retrieve the user-friendly name of a particular database.
java.util.Collection<java.lang.String>	getUserFriendlyNames() Retrieve a collection of user-friendly database names for the Vocabulary Database Access tab.
java.util.Collection<java.lang.String>	getUserFriendlyNames(boolean abIncludeDeprecated) Retrieve a collection of user-friendly database names for the Vocabulary Database Access tab.
java.lang.String	getValidationQuery(java.lang.String astrId) Retrieve a query used to validate a database connection.
boolean	hasMandatoryValueStrategy(java.lang.String astrId) Retrieve the flag for the mandatory value strategy.
boolean	isDeprecated(java.lang.String astrId) Retrieve the depreciated flag.
boolean	isGetGeneratedKeysSupported(java.lang.String astrId) Retrieve the flag for the getGeneratedKeys support.
boolean	isReadOnlyModeSupported(java.lang.String astrId) Retrieve the flag for the read only mode support.
boolean	isSchemaCreationSupported(java.lang.String astrId) Retrieve the flag for the database schema creation support.
boolean	isSupportedSqlTypeMapping(java.lang.String astrId, java.lang.String astrCorticonDataTypeName, java.lang.String astrSqlTypeName) Determine whether a given Corticon Data Type can be mapped to a given SQL type within the specified database.
boolean	isVisible(java.lang.String astrId) Retrieve the visible flag.

Method Detail

findDatabaseId

java.lang.String findDatabaseId(java.lang.String astrDatabaseServerName)

Retrieve the Database Server ID using the database server user-friendly name (reverse lookup).

Parameters:

astrDatabaseServerName - Localized database server name.

Returns:

Database Server ID or null.

getDatabaseIDs

java.util.Collection<java.lang.String> getDatabaseIDs()

Retrieve a collection of unique database definition identifiers (IDs).

Returns:

The collection of database definition identifiers.

getUserFriendlyNames

java.util.Collection<java.lang.String> getUserFriendlyNames()

Retrieve a collection of user-friendly database names for the Vocabulary Database Access tab. This will not include depreciated databases.

Returns:

The collection of user-friendly database names.

getUserFriendlyNames

java.util.Collection<java.lang.String> getUserFriendlyNames(boolean abIncludeDeprecated)

Retrieve a collection of user-friendly database names for the Vocabulary Database Access tab.

Parameters:

abIncludeDeprecated - flag to indicate if depreciated databases should be included in the list.

Returns:

The collection of user-friendly database names.

getUserFriendlyName

java.lang.String getUserFriendlyName(java.lang.String astrId)

Retrieve the user-friendly name of a particular database.

Parameters:

astrId - database definition identifier whose user friendly name should be returned.

Returns:

User friendly name.

getDriverClassName

java.lang.String getDriverClassName(java.lang.String astrId)

Retrieve the JDBC driver class name associated with a particular database.

Parameters:

astrId - database definition identifier whose JDBC driver class name should be returned;

Returns:

Driver class name.

getDialect

java.lang.String getDialect(java.lang.String astrId)

Retrieve the Hibernate Dialect class name be used with a particular database.

Parameters:

astrId - database definition identifier whose Hibernate Dialect class name should be returned;

Returns:

Hibernate dialect class.

getDatabaseUrlTemplate

java.lang.String getDatabaseUrlTemplate(java.lang.String astrId)

Retrieve a template of the database JDBC URL.

Parameters:

astrId - database definition identifier whose database URL template should be returned;

Returns:

Database URL template.

getValidationQuery

java.lang.String getValidationQuery(java.lang.String astrId)

Retrieve a query used to validate a database connection. The query must return a single row with return value “1”.

Parameters:

astrId - database definition identifier whose validation query should be returned;

Returns:

Validation query.

isSupportedSqlTypeMapping

boolean isSupportedSqlTypeMapping(java.lang.String astrId,
                                  java.lang.String astrCorticonDataTypeName,
                                  java.lang.String astrSqlTypeName)

Determine whether a given Corticon Data Type can be mapped to a given SQL type within the specified database.

Parameters:

astrId - Database definition ID.

astrCorticonDataTypeName - Corticon Data Type name (e.g., Decimal).

astrSqlTypeName - SQL type name (e.g., DECIMAL).

Returns:

true if the mapping is valid.

getSupportedSqlTypes

java.util.List<java.lang.String> getSupportedSqlTypes(java.lang.String astrId,
                                                      java.lang.String astrCorticonDataTypeName)

Determine whether a given Corticon Data Type can be mapped to a given SQL type within the specified database.

Parameters:

astrId - Database definition ID.

astrCorticonDataTypeName - Corticon Data Type name (e.g., Decimal).

Returns:

List of supported SQL types.

getDefaultStringIdentityStrategy

java.lang.String getDefaultStringIdentityStrategy(java.lang.String astrId)

Retrieve the default string identity strategy.

Parameters:

astrId - database definition identifier whose validation query should be returned;

Returns:

Identity strategy name or null if not defined.

getDefaultNumericIdentityStrategy

java.lang.String getDefaultNumericIdentityStrategy(java.lang.String astrId)

Retrieve the default numeric identity strategy type.

Parameters:

astrId - database definition identifier whose validation query should be returned;

Returns:

Identity strategy name or null if not defined.

isSchemaCreationSupported

boolean isSchemaCreationSupported(java.lang.String astrId)

Retrieve the flag for the database schema creation support.

Parameters:

astrId - database definition identifier whose validation query should be returned;

Returns:

true if database schema creation is supported.

areTransactionsToBeIgnored

boolean areTransactionsToBeIgnored(java.lang.String astrId)

Retrieve the flag which indicates whether transactions are to be ignored.

Parameters:

astrId - database definition identifier whose validation query should be returned;

Returns:

true if transactions should be ignored.

isReadOnlyModeSupported

boolean isReadOnlyModeSupported(java.lang.String astrId)

Retrieve the flag for the read only mode support.

Parameters:

astrId - database definition identifier whose validation query should be returned;

Returns:

true if read only mode is supported.

isGetGeneratedKeysSupported

boolean isGetGeneratedKeysSupported(java.lang.String astrId)

Retrieve the flag for the getGeneratedKeys support.

Parameters:

astrId - database definition identifier whose validation query should be returned;

Returns:

true if getGeneratedKeys is supported.

hasMandatoryValueStrategy

boolean hasMandatoryValueStrategy(java.lang.String astrId)

Retrieve the flag for the mandatory value strategy.

Parameters:

astrId - database definition identifier whose validation query should be returned;

Returns:

true if the value strategy is mandatory.

areCatalogsSupported

boolean areCatalogsSupported(java.lang.String astrId)

Retrieve the flag for the catalogs support.

Parameters:

astrId - database definition identifier whose validation query should be returned;

Returns:

true if catalogs are supported.

getNumericIdentityStrategies

java.util.Collection<java.lang.String> getNumericIdentityStrategies(java.lang.String astrId)

Retrieve the list of numeric identity strategies

Parameters:

astrId - Database definition ID.

Returns:

Set of numeric identity strategies.

getStringIdentityStrategies

java.util.Collection<java.lang.String> getStringIdentityStrategies(java.lang.String astrId)

Retrieve the list of string identity strategies

Parameters:

astrId - Database definition ID.

Returns:

Set of string identity strategies.

isDeprecated

boolean isDeprecated(java.lang.String astrId)

Retrieve the depreciated flag.

Parameters:

astrId - database definition identifier whose depreciated flag should be returned;

Returns:

true if the database is depreciated.

isVisible

boolean isVisible(java.lang.String astrId)

Retrieve the visible flag.

Parameters:

astrId - database definition identifier whose visible flag should be returned;

Returns:

true if the database is visible.

getAuthenticationTypes

java.util.List<java.lang.String> getAuthenticationTypes(java.lang.String astrId)

Retrieve the list of authentication type strings

Parameters:

astrId - Database definition ID.

Returns:

Set of authentication type strings.

getReserveWordReplacements

java.util.Map<java.lang.String,java.lang.String> getReserveWordReplacements(java.lang.String astrId)

Returns a map of reserve word replacements associated with the supplied database id.

Parameters:

astrId - Database definition ID.

Returns:

Map that contains the original values (keys) and their replacements (value)