com.aspc.DBObj.Internal

Class DBServerUtil

java.lang.Object

com.aspc.DBObj.Internal.DBServerUtil

public final class DBServerUtil
extends java.lang.Object

CreateTables NB: Sybase has a limit of 30 characters for an index or table name. TODO: If an key table doesn't exist then we should make sure that when we create the key table the index version string is cleared. If I drop the index table it should gracefully recreate the table and re-index the fields.
THREAD MODE: MULTI-THREADED

Since:

February 13, 2001, 3:20 PM

Author:

Nigel Leck

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	MASTER_PROPERTY_TABLE the name of the raw properties table.
static java.lang.String	MASTER_VIRTUALDB_CREATE_INDEX_SUFFIX_COLUMN the suffix to use when we create a index.
static java.lang.String	MASTER_VIRTUALDB_CREATE_TABLE_SUFFIX_COLUMN the suffix to use when we create a table.
static java.lang.String	MASTER_VIRTUALDB_TABLE the name of the raw virtualdb table.
static java.lang.String	PREFIX_FIELD prefix of field value table
static java.lang.String	PREFIX_INDX_FLT prefix of index float
static java.lang.String	PREFIX_INDX_FLT_ARRAY prefix for ARRAY of index float
static java.lang.String	PREFIX_INDX_KEY_WORD Prefix for key word index
static java.lang.String	PREFIX_INDX_LNG prefix of index long
static java.lang.String	PREFIX_INDX_LNG_ARRAY prefix for ARRAY of index long
static java.lang.String	PREFIX_INDX_MLV Prefix for MultiLingal value index
static java.lang.String	PREFIX_INDX_MLV_ARRAY Prefix for ARRAY MultiLingal value index
static java.lang.String	PREFIX_INDX_STR prefix of index string
static java.lang.String	PREFIX_INDX_STR_ARRAY prefix for ARRAY of index string
static java.lang.String	PREFIX_LAZY prefix of layer load value table
static java.lang.String	PREFIX_ROW prefix of row header table
static java.lang.String	PREFIX_TRANS_DATA prefix of transaction data table
static java.lang.String	PREFIX_UNIQUE_FLT prefix of unique float index
static java.lang.String	PREFIX_UNIQUE_LNG prefix of unique long index
static java.lang.String	PREFIX_UNIQUE_STR prefix of unique string index
static java.lang.String	TABLE_FIELD_INDEX The field index version
static java.lang.String	TABLE_STATS_DBCLASS The statistics field table.
static java.lang.String	TABLE_STATS_FLD_COUNTS The statistics value table.
static java.lang.String	TABLE_STATS_VALUE_COUNTS The statistics field table.
static java.lang.String	TABLE_TRANS_ACK The transaction ack table.
static java.lang.String	TABLE_TRANS_GROUP The transaction system table.
static java.lang.String	TABLE_TRANS_HEADER The transaction header table raw table
static java.lang.String	TABLE_TRANS_RECORD The transaction record table raw table
static java.lang.String	TABLE_TRANS_SYSTEM The transaction system table.

Method Summary

Modifier and Type	Method and Description
void	createClassIndex(DBClass dbClass) Create the index for a class.
void	createTransHeaderIndex() create the indexes for the transaction header table.
static DBServerUtil	find(DataBase dBase) Find the table utilities for this database.
void	makeBaseTables() Create the base set of tables required.
java.lang.String	makeClassRawTable(DBClass dbClass, java.lang.String tableName) create the raw class tables.
void	makeDBIndex(java.lang.String suffix) make the index.
void	makeMasterTable(java.lang.String tableName) Make the master table
void	makeMasterTables() make all of the master database tables
void	makeNextNumber(java.lang.String suffix) Make the next number table.
void	makeTable(DBClass dbClass, java.lang.String tablePrefix) Create the set of tables for a DBClass.
void	makeThrottlingCounter() Make the throttling counter table.
java.lang.String	makeTransIndexColumn(DBClass dbClass) Create the transaction value index table.
static void	makeTransRecord(TableUtil tu) Make the trans_record table
void	reCreateBaseIndexes()

Methods inherited from class java.lang.Object

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

Field Detail

TABLE_TRANS_HEADER

public static final java.lang.String TABLE_TRANS_HEADER

The transaction header table raw table

See Also:

Constant Field Values

TABLE_TRANS_RECORD

public static final java.lang.String TABLE_TRANS_RECORD

The transaction record table raw table

See Also:

Constant Field Values

TABLE_STATS_FLD_COUNTS

public static final java.lang.String TABLE_STATS_FLD_COUNTS

The statistics value table.

See Also:

Constant Field Values

TABLE_STATS_VALUE_COUNTS

public static final java.lang.String TABLE_STATS_VALUE_COUNTS

The statistics field table.

See Also:

Constant Field Values

TABLE_STATS_DBCLASS

public static final java.lang.String TABLE_STATS_DBCLASS

The statistics field table.

See Also:

Constant Field Values

TABLE_TRANS_SYSTEM

public static final java.lang.String TABLE_TRANS_SYSTEM

The transaction system table.

See Also:

Constant Field Values

TABLE_TRANS_GROUP

public static final java.lang.String TABLE_TRANS_GROUP

The transaction system table.

See Also:

Constant Field Values

TABLE_FIELD_INDEX

public static final java.lang.String TABLE_FIELD_INDEX

The field index version

See Also:

Constant Field Values

TABLE_TRANS_ACK

public static final java.lang.String TABLE_TRANS_ACK

The transaction ack table. Added by je59410 for GEO

See Also:

Constant Field Values

PREFIX_INDX_MLV

public static final java.lang.String PREFIX_INDX_MLV

Prefix for MultiLingal value index

See Also:

Constant Field Values

PREFIX_INDX_KEY_WORD

public static final java.lang.String PREFIX_INDX_KEY_WORD

Prefix for key word index

See Also:

Constant Field Values

PREFIX_INDX_LNG

public static final java.lang.String PREFIX_INDX_LNG

prefix of index long

See Also:

Constant Field Values

PREFIX_INDX_FLT

public static final java.lang.String PREFIX_INDX_FLT

prefix of index float

See Also:

Constant Field Values

PREFIX_INDX_STR

public static final java.lang.String PREFIX_INDX_STR

prefix of index string

See Also:

Constant Field Values

PREFIX_UNIQUE_LNG

public static final java.lang.String PREFIX_UNIQUE_LNG

prefix of unique long index

See Also:

Constant Field Values

PREFIX_UNIQUE_STR

public static final java.lang.String PREFIX_UNIQUE_STR

prefix of unique string index

See Also:

Constant Field Values

PREFIX_UNIQUE_FLT

public static final java.lang.String PREFIX_UNIQUE_FLT

prefix of unique float index

See Also:

Constant Field Values

PREFIX_INDX_MLV_ARRAY

public static final java.lang.String PREFIX_INDX_MLV_ARRAY

Prefix for ARRAY MultiLingal value index

See Also:

Constant Field Values

PREFIX_INDX_LNG_ARRAY

public static final java.lang.String PREFIX_INDX_LNG_ARRAY

prefix for ARRAY of index long

See Also:

Constant Field Values

PREFIX_INDX_FLT_ARRAY

public static final java.lang.String PREFIX_INDX_FLT_ARRAY

prefix for ARRAY of index float

See Also:

Constant Field Values

PREFIX_INDX_STR_ARRAY

public static final java.lang.String PREFIX_INDX_STR_ARRAY

prefix for ARRAY of index string

See Also:

Constant Field Values

PREFIX_FIELD

public static final java.lang.String PREFIX_FIELD

prefix of field value table

See Also:

Constant Field Values

PREFIX_LAZY

public static final java.lang.String PREFIX_LAZY

prefix of layer load value table

See Also:

Constant Field Values

PREFIX_ROW

public static final java.lang.String PREFIX_ROW

prefix of row header table

See Also:

Constant Field Values

PREFIX_TRANS_DATA

public static final java.lang.String PREFIX_TRANS_DATA

prefix of transaction data table

See Also:

Constant Field Values

MASTER_PROPERTY_TABLE

public static final java.lang.String MASTER_PROPERTY_TABLE

the name of the raw properties table.

See Also:

Constant Field Values

MASTER_VIRTUALDB_TABLE

public static final java.lang.String MASTER_VIRTUALDB_TABLE

the name of the raw virtualdb table.

See Also:

Constant Field Values

MASTER_VIRTUALDB_CREATE_TABLE_SUFFIX_COLUMN

public static final java.lang.String MASTER_VIRTUALDB_CREATE_TABLE_SUFFIX_COLUMN

the suffix to use when we create a table.

See Also:

Constant Field Values

MASTER_VIRTUALDB_CREATE_INDEX_SUFFIX_COLUMN

public static final java.lang.String MASTER_VIRTUALDB_CREATE_INDEX_SUFFIX_COLUMN

the suffix to use when we create a index.

See Also:

Constant Field Values

Method Detail

find

@CheckReturnValue
 @Nonnull
public static DBServerUtil find(@Nonnull
                                                            DataBase dBase)

Find the table utilities for this database.

Parameters:

dBase - The database.

Returns:

The table utilities.

makeTransIndexColumn

@Nonnull
public java.lang.String makeTransIndexColumn(@Nonnull
                                                      DBClass dbClass)
                                               throws java.sql.SQLException

Create the transaction value index table.

Parameters:

dbClass - the logical class name.

Returns:

the column name.

Throws:

java.sql.SQLException - A serious problem

createClassIndex

public void createClassIndex(@Nonnull
                             DBClass dbClass)
                      throws java.sql.SQLException

Create the index for a class.

Parameters:

dbClass - the logical class

Throws:

java.sql.SQLException - A SQL exception

makeClassRawTable

@Nonnull
public java.lang.String makeClassRawTable(DBClass dbClass,
                                                   java.lang.String tableName)
                                            throws java.sql.SQLException

create the raw class tables.

Parameters:

dbClass - the logical class

tableName - the table table.

Returns:

the table name.

Throws:

java.sql.SQLException - A SQL exception

makeTable

public void makeTable(@Nonnull
                      DBClass dbClass,
                      @Nonnull
                      java.lang.String tablePrefix)
               throws java.sql.SQLException

Create the set of tables for a DBClass. Error Handling:

Possible to have two servers conflict on this. Just continue. If the tables have been created by the other server then great otherwise we'll get an error later.

Parameters:

dbClass - The logical class

tablePrefix - The table prefix

Throws:

java.sql.SQLException - A SQL exception

makeDBIndex

public void makeDBIndex(@Nonnull
                        java.lang.String suffix)
                 throws java.sql.SQLException

make the index.

Parameters:

suffix - the suffix

Throws:

java.sql.SQLException - A SQL exception

makeNextNumber

public void makeNextNumber(@Nonnull
                           java.lang.String suffix)
                    throws java.sql.SQLException

Make the next number table.

Parameters:

suffix - the class suffix

Throws:

java.sql.SQLException - A SQL exception

makeThrottlingCounter

public void makeThrottlingCounter()
                           throws java.sql.SQLException

Make the throttling counter table.

Throws:

java.sql.SQLException - A SQL exception

makeMasterTables

public void makeMasterTables()
                      throws java.lang.Exception

make all of the master database tables

Throws:

java.lang.Exception - a serious problem

makeMasterTable

public void makeMasterTable(@Nonnull
                            java.lang.String tableName)
                     throws java.lang.Exception

Make the master table

Parameters:

tableName - The table name.

Throws:

java.lang.Exception - A serious problem

createTransHeaderIndex

public void createTransHeaderIndex()
                            throws java.sql.SQLException

create the indexes for the transaction header table.

Throws:

java.sql.SQLException - could not create the indexes.

makeTransRecord

public static void makeTransRecord(@Nonnull
                                   TableUtil tu)
                            throws java.sql.SQLException

Make the trans_record table

Parameters:

tu - the table utilities to use.

Throws:

java.sql.SQLException - a serious problem.

reCreateBaseIndexes

public void reCreateBaseIndexes()
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

makeBaseTables

public void makeBaseTables()
                    throws java.sql.SQLException

Create the base set of tables required. TODO: SYBASE we should create the RecentLink as ONE PER PAGE. Because this provides the concurrency locking as well. Error Handling:

Possible to have two servers conflict on this. Just continue. If the tables have been created by the other server then great otherwise we'll get an error later.

Throws:

java.sql.SQLException - A SQL exception