com.ibm.tivoli.maximo.integrity

Class DatabaseInformation

java.lang.Object

com.ibm.tivoli.maximo.dbmanage.MaximoDatabaseInfo

com.ibm.tivoli.maximo.integrity.DatabaseInformation

public class DatabaseInformation
extends MaximoDatabaseInfo

Store data about the database being checked.

Author:

John Neville

Constructor Summary

Constructors

Constructor and Description
DatabaseInformation(java.sql.Connection con) Constructor

Method Summary

Methods

Modifier and Type	Method and Description
int	getAmountLength() Return the length for amount attributes.
int	getAmountScale() Return the scale for amount attributes.
java.lang.String	getBaseLangCode() Returns the code for base language of the Maximo database.
java.sql.Connection	getConnection()
java.sql.Connection	getConnection(MTContext c) Get the connection for the context.
int	getIntegerLength() Returns the standard length of INTEGER attributes, for the MaxAttribute table.
java.util.List<java.lang.String>	getMaximoViewList() Return a list of views in Maximo.
java.lang.String	getMaxUpgVersion() Gets the version number from the MaxUpg MaxVar.
int	getMaxVarCharLength() Returns the maximum length of a string column, in characters.
MTConnection	getMTConnection()
MTStorageType	getMTStorageType(java.lang.String tablename) Return the storage type for a table.
java.util.List<java.lang.String>	getNavtiveViewList() Gets the list of views in the database.
java.lang.String	getNickName()
java.lang.String	getSchema()
java.util.Set<MTContext>	getSelectedTenants() Get the set of tenants selected.
java.util.Set<MTContext>	getSelectedUsers() Returns the selected tenants, but returns all tenants, including the master, when no tenant is targeted.
ServerType	getServerType() Returns the type of server
int	getSmallIntLength() Returns the standard length of SMALLINT attributes, for the MaxAttribute table.
SQLSpecificTransform	getSQLTransform() Get the transform to use to convert for the database platform.
java.lang.String	getSynonymMaxValue(java.lang.String synonym, java.lang.String domainid) Returns the MaxValue for the synonym value given.
int	getVarCharMultiple() Returns the value of the VARCHARMULTIPLE MaxVar, or 1 if the MaxVar isn't found.
boolean	hasExtension(java.lang.String baseTable)
boolean	hasPendingChanges()
boolean	hasTable(java.lang.String tbname)
boolean	isImportedTable(java.lang.String tableName) Returns whether a table is marked as being imported to Maximo.
boolean	isMTEnabled()
boolean	isPreMerlin()
boolean	isUsingVarGraphic() Are VarGraphic in use?
boolean	isV510() Is this database a release V510 prior or earlier?
void	resetHasExtension()
void	setPendingChanges(boolean hasPending) Set the "has pending changes" flag.
void	setSchema(java.lang.String schema)
void	setSelectedTenant(java.lang.String targetTenant) Select a single tenant.
void	setSelectedTenants(java.util.Set<MTContext> tenants) Select tenants for testing.

Methods inherited from class com.ibm.tivoli.maximo.dbmanage.MaximoDatabaseInfo

isDB2, isOracle, isSQLServer

Methods inherited from class java.lang.Object

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

Constructor Detail

DatabaseInformation

public DatabaseInformation(java.sql.Connection con)
                    throws java.sql.SQLException

Constructor

Parameters:

con - Connection to the database to store information about.

Throws:

java.sql.SQLException

Method Detail

getConnection

public java.sql.Connection getConnection()

getServerType

public ServerType getServerType()

Description copied from class: MaximoDatabaseInfo

Returns the type of server

Specified by:

getServerType in class MaximoDatabaseInfo

setSelectedTenants

public void setSelectedTenants(java.util.Set<MTContext> tenants)

Select tenants for testing.

Parameters:

tenants -

getSelectedTenants

public java.util.Set<MTContext> getSelectedTenants()
                                            throws java.sql.SQLException

Get the set of tenants selected.

Returns:

The set of tenants selected, or all tenants if none were selected. Null will be returned if MT is not enabled.

Throws:

java.sql.SQLException

isPreMerlin

public boolean isPreMerlin()
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

isMTEnabled

public boolean isMTEnabled()
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

getMTConnection

public MTConnection getMTConnection()
                             throws java.sql.SQLException

Throws:

java.sql.SQLException

getConnection

public java.sql.Connection getConnection(MTContext c)
                                  throws java.sql.SQLException

Get the connection for the context.

Parameters:

c - Context to get.

Returns:

The connection for this context.

Throws:

java.sql.SQLException

getSelectedUsers

public java.util.Set<MTContext> getSelectedUsers()
                                          throws java.sql.SQLException

Returns the selected tenants, but returns all tenants, including the master, when no tenant is targeted.

Returns:

The user set.

Throws:

java.sql.SQLException

See Also:

This does not include the master context.

getSchema

public java.lang.String getSchema()

setSchema

public void setSchema(java.lang.String schema)

setSelectedTenant

public void setSelectedTenant(java.lang.String targetTenant)
                       throws java.sql.SQLException

Select a single tenant.

Parameters:

targetTenant -

Throws:

java.sql.SQLException

getSQLTransform

public SQLSpecificTransform getSQLTransform()
                                     throws java.sql.SQLException

Get the transform to use to convert for the database platform.

Returns:

The transform.

Throws:

java.sql.SQLException

getMaxUpgVersion

public java.lang.String getMaxUpgVersion()
                                  throws java.sql.SQLException

Gets the version number from the MaxUpg MaxVar.

Returns:

The version number, i.e. 7500

Throws:

java.sql.SQLException

setPendingChanges

public void setPendingChanges(boolean hasPending)

Set the "has pending changes" flag. Refers to the configuration changes made in the *CFG framework tables.

Parameters:

hasPending -

hasPendingChanges

public boolean hasPendingChanges()

getIntegerLength

public int getIntegerLength()
                     throws java.lang.NumberFormatException,
                            java.sql.SQLException

Returns the standard length of INTEGER attributes, for the MaxAttribute table.

Throws:

java.sql.SQLException

java.lang.NumberFormatException

getSmallIntLength

public int getSmallIntLength()
                      throws java.lang.NumberFormatException,
                             java.sql.SQLException

Returns the standard length of SMALLINT attributes, for the MaxAttribute table.

Throws:

java.sql.SQLException

java.lang.NumberFormatException

getAmountLength

public int getAmountLength()
                    throws java.lang.NumberFormatException,
                           java.sql.SQLException

Return the length for amount attributes.

Throws:

java.sql.SQLException

java.lang.NumberFormatException

getAmountScale

public int getAmountScale()
                   throws java.lang.NumberFormatException,
                          java.sql.SQLException

Return the scale for amount attributes.

Throws:

java.sql.SQLException

java.lang.NumberFormatException

isV510

public boolean isV510()

Description copied from class: MaximoDatabaseInfo

Is this database a release V510 prior or earlier?

Specified by:

isV510 in class MaximoDatabaseInfo

isUsingVarGraphic

public boolean isUsingVarGraphic()
                          throws java.sql.SQLException

Description copied from class: MaximoDatabaseInfo

Are VarGraphic in use?

Specified by:

isUsingVarGraphic in class MaximoDatabaseInfo

Throws:

java.sql.SQLException

getMaxVarCharLength

public int getMaxVarCharLength()

Description copied from class: MaximoDatabaseInfo

Returns the maximum length of a string column, in characters.

Specified by:

getMaxVarCharLength in class MaximoDatabaseInfo

getVarCharMultiple

public int getVarCharMultiple()
                       throws java.sql.SQLException

Description copied from class: MaximoDatabaseInfo

Returns the value of the VARCHARMULTIPLE MaxVar, or 1 if the MaxVar isn't found.

Specified by:

getVarCharMultiple in class MaximoDatabaseInfo

Throws:

java.sql.SQLException

getMTStorageType

public MTStorageType getMTStorageType(java.lang.String tablename)
                               throws java.sql.SQLException

Return the storage type for a table.

Parameters:

tablename -

Returns:

The storagetype for the table, or null if the table wasn't found or MT is not enabled.

Throws:

java.sql.SQLException

isImportedTable

public boolean isImportedTable(java.lang.String tableName)
                        throws java.sql.SQLException

Returns whether a table is marked as being imported to Maximo.

Parameters:

tableName -

Returns:

true if the table was marked as imported

Throws:

java.sql.SQLException

getSynonymMaxValue

public java.lang.String getSynonymMaxValue(java.lang.String synonym,
                                  java.lang.String domainid)
                                    throws java.sql.SQLException

Returns the MaxValue for the synonym value given.

Parameters:

synonym -

domainid -

Returns:

The MaxValue for the synonym, or null if the synonym wasn't found.

Throws:

java.sql.SQLException

getBaseLangCode

public java.lang.String getBaseLangCode()
                                 throws java.sql.SQLException

Returns the code for base language of the Maximo database.

Throws:

java.sql.SQLException

hasExtension

public boolean hasExtension(java.lang.String baseTable)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

resetHasExtension

public void resetHasExtension()

getNavtiveViewList

public java.util.List<java.lang.String> getNavtiveViewList()
                                                    throws java.sql.SQLException

Gets the list of views in the database. Uses the list from the DatabaseInformation object, if available. Otherwise this method will get this information and set it in the DI.

Throws:

java.sql.SQLException

See Also:

DatabaseInformation

getMaximoViewList

public java.util.List<java.lang.String> getMaximoViewList()
                                                   throws java.sql.SQLException

Return a list of views in Maximo.

Parameters:

dc -

Returns:

Throws:

java.sql.SQLException

getNickName

public java.lang.String getNickName()

hasTable

public boolean hasTable(java.lang.String tbname)
                 throws java.sql.SQLException

Throws:

java.sql.SQLException