wt.pom
Class DBProperties

java.lang.Object
  java.util.Dictionary
      java.util.Hashtable
          java.util.Properties
              wt.util.WTProperties
                  wt.pom.DBProperties

All Implemented Interfaces:

Cloneable, Map, Serializable

public class DBProperties

extends WTProperties

Database configuration properties.

These properties are loaded from a file identified by a property named "wt.pom.properties" in the standard Windchill properties file.

See Also:

WTProperties, Serialized Form

Nested Class Summary

Nested classes inherited from class java.util.Hashtable

Field Summary

static boolean	ALLOW_COMPOUND_PARANTHESES
static int	ALLOW_PARTIAL_UPDATE
static int	BATCH_SPEC_TABLE_EXPRESSION_THRESHOLD
static boolean	BATCH_SPEC_USE_COLUMN_LIST
static boolean	BATCH_SPEC_USE_TABLE_TYPE
static boolean	BLOB_REWRITE_ENABLED
static int	CACHED_STATEMENT_REUSE_LIMIT
private static int	CACHED_STATEMENT_RS_LIMIT
private static int	CARDINALITY_VALUE_FIXED_SIZE
static boolean	CHANGE_COMPOUND_QUERY
static boolean	COMPUTED_COLUMNS_ENABLED
static int	CONN_CLOSER_IDLE_TIMEOUT
static int	CONN_CLOSER_THRESHOLD
static int	CONN_MONITOR_SLEEP_INTERVAL
static int	CONSTANT_ARRAY_TABLE_LIMIT
static String	DB_CONNECTION_PROPERTIES_NAME_LIST
static String	DB_CONNECTION_PROPERTIES_VALUE_LIST
static String	DB_PASSWORD
static String	DB_USER
private static DBProperties	dbProperties
static int	DEFAULT_CHUNK_SIZE
static int	DEPTH_THRESHOLD_IN_CLAUSE_SIZE_LIMIT
static boolean	ENABLE_NLS_SORT
static boolean	ENABLE_SQL99_OUTERJOIN_SYNTAX
static String	EXPAND_ALL_ROLES_EXCLUDED_LINK_ROLES
static String	EXPAND_ALL_ROLES_EXCLUDED_SOURCE_CLASS_NAMES
static int	FEEDBACK_INTERVAL
static boolean	FREE_CONNECTION_IMMEDIATE
static boolean	HANDLE_620_LOCALIZED_VALUES
static int	IN_CLAUSE_BIND_LIMIT
private static int	IN_CLAUSE_BIND_OPTIMIZATION_CARDINALITY
static int	IN_CLAUSE_FIXED_SIZE
static int	IN_CLAUSE_SIZE_LIMIT
static boolean	IN_CLAUSE_USE_BIND_OPTIMIZATION
static boolean	IN_LIST_OPTIMIZATION_WARNING_ENABLED
static String	INFLATE_HINT
static boolean	INFLATE_SINGLE_TABLE_MODE
static int	INTERRUPT_INTERVAL
static String	JDBC_DRIVER
static int	JDBC_DRIVER_MAJOR_VERSION
static int	JDBC_DRIVER_MINOR_VERSION
static String	JDBC_URL
static int	LOB_CHUNK_SIZE
static boolean	LOG_APPEND
static boolean	LOG_BLOB_INFO
static boolean	LOG_CONNECTION_INFO
static boolean	LOG_CRUD_ENTER_EXIT
static boolean	LOG_ENABLED
static boolean	LOG_ENTER_EXIT
static String	LOG_FILE
static String	LOG_FILE_JDBC
static String	LOG_FILTER_JDBC
static boolean	LOG_INSERT_UPDATE
static boolean	LOG_JDBC_STATEMENTS
static boolean	LOG_MAPPING
static boolean	LOG_PROPERTIES
static boolean	LOG_REFRESH_CACHE
static boolean	LOG_SQL_EXCEPTION
static boolean	LOG_SQL_STATEMENTS
static boolean	LOG_STACK_TRACE
static boolean	LOG_STATEMENT_CACHE
static boolean	LOG_STRIPPED_SQL_STATEMENTS
static boolean	LOG_TRANSACTION
static int	MAX_DB_CONNECTIONS
static int	MAX_IDLE_STMT_CACHES
static int	MIN_DB_CONNECTIONS
static int	NAVIGATE_DEPTH_THRESHOLD
static int	NAVIGATE_DEPTH_UNION_LIMIT
static int	OBJECT_REFERENCE_QUERY_CHUNK_SIZE
static int	OBJECT_REFERENCE_QUERY_SIZE
static String	ORACLE_DRIVER
static int	PAGE_INSERT_CHUNKSIZE
static int	PAGE_THRESHOLD
static int	PAGING_CLOSE_SLEEP_INTERVAL
static int	PAGING_FETCH_LIMIT
static int	PAGING_FETCH_SLEEP_INTERVAL
static int	PAGING_QUEUE_INVOKE_TIME
static boolean	PAGING_RULE_HINT_ENABLED
static int	PAGING_SESSION_CLEANUP_TIME
static int	PAGING_SESSION_LIMIT
static int	PAGING_SNAPSHOT_QUERY_LIMIT
static int	QUERY_DEPTH_THRESHOLD
static int	QUERY_LIMIT
static String	RECOVERABLE_CONNECTION_CODES
static int	REF_INTEGRITY_OWNER_QUERY_CHUNK_THRESHOLD
static int	REF_INTEGRITY_OWNER_QUERY_OBJECT_CHUNK_SIZE
static int	REF_INTEGRITY_OWNER_QUERY_ROLE_CHUNK_SIZE
static boolean	REFRESH_CACHE_ENABLED
static int	REFRESH_CACHE_SIZE
static int	REFRESH_CACHE_SUMMARY_INTERVAL
static int	ROW_PREFETCH
static boolean	SELECT_FOR_UPDATE_ENABLED
static String	SERVICE_NAME
static int	STATEMENT_CACHE_SIZE
static int	STATEMENT_CACHE_SUMMERY_INTERVAL
static boolean	TRACE_TIMING_ENABLED
static boolean	TRACE_TIMING_SQL
static boolean	TRACE_TIMING_STACK_TRACE
static String	TRANSACTION_MODE
static boolean	upgradeSchemaMode
static boolean	USE_BIND

Fields inherited from class wt.util.WTProperties

RESOURCE_NAME, SERVER_CODEBASE_LOCATOR, SERVER_CODEBASE_PROPERTY

Fields inherited from class java.util.Properties

Fields inherited from class java.util.Hashtable

Constructor Summary

private	DBProperties()
private	DBProperties(Properties defaults)

Method Summary

static int	getArrayCardinalityHintValue(int a_valueCount, String a_arrayTypeName)
static DBProperties	getDBProperties() Get the local database properties.
private static DBProperties	getDBProperties(boolean load)
boolean	getServerProperty(String key, boolean defaultValue)
int	getServerProperty(String key, int defaultValue)
String	getServerProperty(String key, String defaultValue)
static boolean	isStatementCacheResultSetLimit(int a_rowCount)
private static void	logProperties()

Methods inherited from class wt.util.WTProperties

appendPropertyToFile, appendPropertyToFile, copyFile, getAppletProperties, getLocalProperties, getProperty, getProperty, getProperty, getServerCodebase, getServerCodebase, getServerProperties, getServerProperties, getURL, list, main, parseArgs, propertyNames, reset, setLocalPropertiesOnly, setVerbose, store, store, store, substitute

Methods inherited from class java.util.Properties

getProperty, list, list, load, save, setProperty, store

Methods inherited from class java.util.Hashtable

clear, clone, contains, containsKey, containsValue, elements, entrySet, equals, get, hashCode, isEmpty, keys, keySet, put, putAll, rehash, remove, size, toString, values

Methods inherited from class java.lang.Object

finalize, getClass, notify, notifyAll, wait, wait, wait

Field Detail

upgradeSchemaMode

public static boolean upgradeSchemaMode

dbProperties

private static DBProperties dbProperties

LOG_FILE

public static final String LOG_FILE

LOG_ENABLED

public static final boolean LOG_ENABLED

LOG_APPEND

public static final boolean LOG_APPEND

LOG_SQL_STATEMENTS

public static final boolean LOG_SQL_STATEMENTS

LOG_STRIPPED_SQL_STATEMENTS

public static final boolean LOG_STRIPPED_SQL_STATEMENTS

LOG_JDBC_STATEMENTS

public static final boolean LOG_JDBC_STATEMENTS

LOG_FILE_JDBC

public static final String LOG_FILE_JDBC

LOG_FILTER_JDBC

public static final String LOG_FILTER_JDBC

LOG_ENTER_EXIT

public static final boolean LOG_ENTER_EXIT

LOG_CRUD_ENTER_EXIT

public static final boolean LOG_CRUD_ENTER_EXIT

LOG_MAPPING

public static final boolean LOG_MAPPING

LOG_BLOB_INFO

public static final boolean LOG_BLOB_INFO

LOG_STATEMENT_CACHE

public static final boolean LOG_STATEMENT_CACHE

LOG_TRANSACTION

public static final boolean LOG_TRANSACTION

LOG_PROPERTIES

public static final boolean LOG_PROPERTIES

LOG_STACK_TRACE

public static final boolean LOG_STACK_TRACE

LOG_INSERT_UPDATE

public static final boolean LOG_INSERT_UPDATE

LOG_SQL_EXCEPTION

public static final boolean LOG_SQL_EXCEPTION

LOG_CONNECTION_INFO

public static final boolean LOG_CONNECTION_INFO

FEEDBACK_INTERVAL

public static final int FEEDBACK_INTERVAL

INTERRUPT_INTERVAL

public static final int INTERRUPT_INTERVAL

DEFAULT_CHUNK_SIZE

public static final int DEFAULT_CHUNK_SIZE

CACHED_STATEMENT_RS_LIMIT

private static final int CACHED_STATEMENT_RS_LIMIT

NAVIGATE_DEPTH_THRESHOLD

public static final int NAVIGATE_DEPTH_THRESHOLD

NAVIGATE_DEPTH_UNION_LIMIT

public static final int NAVIGATE_DEPTH_UNION_LIMIT

QUERY_DEPTH_THRESHOLD

public static final int QUERY_DEPTH_THRESHOLD

DEPTH_THRESHOLD_IN_CLAUSE_SIZE_LIMIT

public static final int DEPTH_THRESHOLD_IN_CLAUSE_SIZE_LIMIT

LOB_CHUNK_SIZE

public static final int LOB_CHUNK_SIZE

JDBC_DRIVER

public static final String JDBC_DRIVER

JDBC_DRIVER_MAJOR_VERSION

public static final int JDBC_DRIVER_MAJOR_VERSION

JDBC_DRIVER_MINOR_VERSION

public static final int JDBC_DRIVER_MINOR_VERSION

JDBC_URL

public static final String JDBC_URL

MAX_DB_CONNECTIONS

public static final int MAX_DB_CONNECTIONS

MIN_DB_CONNECTIONS

public static final int MIN_DB_CONNECTIONS

RECOVERABLE_CONNECTION_CODES

public static final String RECOVERABLE_CONNECTION_CODES

MAX_IDLE_STMT_CACHES

public static final int MAX_IDLE_STMT_CACHES

ALLOW_PARTIAL_UPDATE

public static final int ALLOW_PARTIAL_UPDATE

ALLOW_COMPOUND_PARANTHESES

public static final boolean ALLOW_COMPOUND_PARANTHESES

CONN_CLOSER_THRESHOLD

public static final int CONN_CLOSER_THRESHOLD

CONN_CLOSER_IDLE_TIMEOUT

public static final int CONN_CLOSER_IDLE_TIMEOUT

CONN_MONITOR_SLEEP_INTERVAL

public static final int CONN_MONITOR_SLEEP_INTERVAL

DB_USER

public static final String DB_USER

DB_PASSWORD

public static final String DB_PASSWORD

DB_CONNECTION_PROPERTIES_NAME_LIST

public static final String DB_CONNECTION_PROPERTIES_NAME_LIST

DB_CONNECTION_PROPERTIES_VALUE_LIST

public static final String DB_CONNECTION_PROPERTIES_VALUE_LIST

SERVICE_NAME

public static final String SERVICE_NAME

ROW_PREFETCH

public static final int ROW_PREFETCH

STATEMENT_CACHE_SIZE

public static final int STATEMENT_CACHE_SIZE

CACHED_STATEMENT_REUSE_LIMIT

public static final int CACHED_STATEMENT_REUSE_LIMIT

USE_BIND

public static final boolean USE_BIND

OBJECT_REFERENCE_QUERY_SIZE

public static final int OBJECT_REFERENCE_QUERY_SIZE

OBJECT_REFERENCE_QUERY_CHUNK_SIZE

public static final int OBJECT_REFERENCE_QUERY_CHUNK_SIZE

INFLATE_HINT

public static final String INFLATE_HINT

IN_CLAUSE_FIXED_SIZE

public static final int IN_CLAUSE_FIXED_SIZE

QUERY_LIMIT

public static final int QUERY_LIMIT

IN_CLAUSE_SIZE_LIMIT

public static final int IN_CLAUSE_SIZE_LIMIT

IN_CLAUSE_BIND_LIMIT

public static final int IN_CLAUSE_BIND_LIMIT

IN_CLAUSE_USE_BIND_OPTIMIZATION

public static final boolean IN_CLAUSE_USE_BIND_OPTIMIZATION

IN_CLAUSE_BIND_OPTIMIZATION_CARDINALITY

private static final int IN_CLAUSE_BIND_OPTIMIZATION_CARDINALITY

CARDINALITY_VALUE_FIXED_SIZE

private static final int CARDINALITY_VALUE_FIXED_SIZE

INFLATE_SINGLE_TABLE_MODE

public static final boolean INFLATE_SINGLE_TABLE_MODE

IN_LIST_OPTIMIZATION_WARNING_ENABLED

public static final boolean IN_LIST_OPTIMIZATION_WARNING_ENABLED

TRANSACTION_MODE

public static final String TRANSACTION_MODE

PAGING_QUEUE_INVOKE_TIME

public static final int PAGING_QUEUE_INVOKE_TIME

PAGING_SESSION_CLEANUP_TIME

public static final int PAGING_SESSION_CLEANUP_TIME

PAGING_SESSION_LIMIT

public static final int PAGING_SESSION_LIMIT

CHANGE_COMPOUND_QUERY

public static final boolean CHANGE_COMPOUND_QUERY

STATEMENT_CACHE_SUMMERY_INTERVAL

public static final int STATEMENT_CACHE_SUMMERY_INTERVAL

PAGE_THRESHOLD

public static final int PAGE_THRESHOLD

PAGE_INSERT_CHUNKSIZE

public static final int PAGE_INSERT_CHUNKSIZE

PAGING_FETCH_LIMIT

public static final int PAGING_FETCH_LIMIT

PAGING_FETCH_SLEEP_INTERVAL

public static final int PAGING_FETCH_SLEEP_INTERVAL

PAGING_CLOSE_SLEEP_INTERVAL

public static final int PAGING_CLOSE_SLEEP_INTERVAL

PAGING_SNAPSHOT_QUERY_LIMIT

public static final int PAGING_SNAPSHOT_QUERY_LIMIT

PAGING_RULE_HINT_ENABLED

public static final boolean PAGING_RULE_HINT_ENABLED

FREE_CONNECTION_IMMEDIATE

public static final boolean FREE_CONNECTION_IMMEDIATE

ORACLE_DRIVER

public static final String ORACLE_DRIVER

HANDLE_620_LOCALIZED_VALUES

public static final boolean HANDLE_620_LOCALIZED_VALUES

BLOB_REWRITE_ENABLED

public static final boolean BLOB_REWRITE_ENABLED

ENABLE_NLS_SORT

public static boolean ENABLE_NLS_SORT

CONSTANT_ARRAY_TABLE_LIMIT

public static final int CONSTANT_ARRAY_TABLE_LIMIT

TRACE_TIMING_ENABLED

public static boolean TRACE_TIMING_ENABLED

TRACE_TIMING_STACK_TRACE

public static boolean TRACE_TIMING_STACK_TRACE

TRACE_TIMING_SQL

public static boolean TRACE_TIMING_SQL

COMPUTED_COLUMNS_ENABLED

public static boolean COMPUTED_COLUMNS_ENABLED

SELECT_FOR_UPDATE_ENABLED

public static boolean SELECT_FOR_UPDATE_ENABLED

REFRESH_CACHE_ENABLED

public static final boolean REFRESH_CACHE_ENABLED

LOG_REFRESH_CACHE

public static final boolean LOG_REFRESH_CACHE

REFRESH_CACHE_SUMMARY_INTERVAL

public static final int REFRESH_CACHE_SUMMARY_INTERVAL

REFRESH_CACHE_SIZE

public static final int REFRESH_CACHE_SIZE

EXPAND_ALL_ROLES_EXCLUDED_SOURCE_CLASS_NAMES

public static final String EXPAND_ALL_ROLES_EXCLUDED_SOURCE_CLASS_NAMES

EXPAND_ALL_ROLES_EXCLUDED_LINK_ROLES

public static final String EXPAND_ALL_ROLES_EXCLUDED_LINK_ROLES

REF_INTEGRITY_OWNER_QUERY_CHUNK_THRESHOLD

public static final int REF_INTEGRITY_OWNER_QUERY_CHUNK_THRESHOLD

REF_INTEGRITY_OWNER_QUERY_ROLE_CHUNK_SIZE

public static final int REF_INTEGRITY_OWNER_QUERY_ROLE_CHUNK_SIZE

REF_INTEGRITY_OWNER_QUERY_OBJECT_CHUNK_SIZE

public static final int REF_INTEGRITY_OWNER_QUERY_OBJECT_CHUNK_SIZE

BATCH_SPEC_TABLE_EXPRESSION_THRESHOLD

public static final int BATCH_SPEC_TABLE_EXPRESSION_THRESHOLD

BATCH_SPEC_USE_TABLE_TYPE

public static final boolean BATCH_SPEC_USE_TABLE_TYPE

BATCH_SPEC_USE_COLUMN_LIST

public static final boolean BATCH_SPEC_USE_COLUMN_LIST

ENABLE_SQL99_OUTERJOIN_SYNTAX

public static boolean ENABLE_SQL99_OUTERJOIN_SYNTAX

Constructor Detail

DBProperties

private DBProperties()

DBProperties

private DBProperties(Properties defaults)

Method Detail

getDBProperties

public static DBProperties getDBProperties()
                                    throws IOException

Get the local database properties.

Throws:

IOException

getDBProperties

private static DBProperties getDBProperties(boolean load)
                                     throws IOException

Throws:

IOException

getServerProperty

public String getServerProperty(String key,
                                String defaultValue)

getServerProperty

public boolean getServerProperty(String key,
                                 boolean defaultValue)

getServerProperty

public int getServerProperty(String key,
                             int defaultValue)

isStatementCacheResultSetLimit

public static boolean isStatementCacheResultSetLimit(int a_rowCount)

getArrayCardinalityHintValue

public static int getArrayCardinalityHintValue(int a_valueCount,
                                               String a_arrayTypeName)

logProperties

private static void logProperties()