Java Doc for TableDataConglomerate.java in  » Database-DBMS » mckoi » com » mckoi » database » Java Source Code / Java DocumentationJava Source Code and Java Documentation

The BEFORE_* type triggers are given the opportunity to modify the contents of the RowData before the update or insert occurs. All triggers may generate an exception which will cause the transaction to rollback.

The event carries with it the event type, the transaction that the event occurred in, and any information regarding the modification itself.

This event/listener mechanism is intended to be used to implement higher layer database triggering systems. Note that care must be taken with the commit level events because they occur inside a commit lock on this conglomerate and so synchronization and deadlock issues need to be carefully considered.

NOTE: A listener on the given table will be notified of ALL table modification events by all transactions at the time they happen.
Parameters:
  table_name - the name of the table in the conglomerate to listen forevents from.
Parameters:
  listener - the listener to be notified of events.

If deferred = IMMEDIATE only immediate constraints are tested. If deferred = DEFERRED all constraints are tested.
Parameters:
  transaction - the Transaction instance used to determine tableconstraints.
Parameters:
  table - the table to test
Parameters:
  row_indices - the list of rows that were added to the table.
Parameters:
  deferred - '1' indicates Transaction.IMMEDIATE,'2' indicates Transaction.DEFERRED.

If deferred = IMMEDIATE only immediate constraints are tested. If deferred = DEFERRED all constraints are tested.
Parameters:
  transaction - the Transaction instance used to determine tableconstraints.
Parameters:
  table - the table to test
Parameters:
  row_index - the row that was added to the table.
Parameters:
  deferred - '1' indicates Transaction.IMMEDIATE,'2' indicates Transaction.DEFERRED.

This method is useful when the constraint schema of a table changes and we need to check existing data in a table is conformant with the new constraint changes.

If deferred = IMMEDIATE only immediate constraints are tested. If deferred = DEFERRED all constraint are tested.

If deferred = IMMEDIATE only immediate constraints are tested. If deferred = DEFERRED all constraints are tested.
Parameters:
  transaction - the Transaction instance used to determine tableconstraints.
Parameters:
  table - the table to test
Parameters:
  row_indices - the set of rows that were removed from the table.
Parameters:
  deferred - '1' indicates Transaction.IMMEDIATE,'2' indicates Transaction.DEFERRED.

If deferred = IMMEDIATE only immediate constraints are tested. If deferred = DEFERRED all constraints are tested.
Parameters:
  transaction - the Transaction instance used to determine tableconstraints.
Parameters:
  table - the table to test
Parameters:
  row_index - the row that was removed from the table.
Parameters:
  deferred - '1' indicates Transaction.IMMEDIATE,'2' indicates Transaction.DEFERRED.

Note that two tables may exist within a conglomerate with the same name, however each committed table must have a unique name.

Parameters:
  src_master_table - the source master table to copy.
Parameters:
  index_set - the view of the table index to copy. the MasterTableDataSource with the copied information.

Note that two tables may exist within a conglomerate with the same name, however each committed table must have a unique name.

Parameters:
  table_def - the table definition.
Parameters:
  data_sector_size - the size of the data sectors (affects performanceand size of the file).
Parameters:
  index_sector_size - the size of the index sectors.

WARNING: Will result in total loss of all data stored in the conglomerate.

The conglomerate must be open before this method is called.

• Determine if any transactions have been committed since this transaction was created.
• If no transactions committed then commit this transaction and exit.
• Otherwise, determine the tables that have been changed by the committed transactions since this was created.
• If no tables changed in the tables changed by this transaction then commit this transaction and exit.
• Determine if there are any rows that have been deleted that this transaction read/deleted.
• If there are then rollback this transaction and throw an error.
• Determine if any rows have been added to the tables this transaction read/changed.
• If there are then rollback this transaction and throw an error.
• Otherwise commit the transaction.

 sUSRPKeyInfo - Primary key constraint information.
 sUSRFKeyInfo - Foreign key constraint information.
 sUSRUniqueInfo - Unique set constraint information.
 sUSRCheckInfo  - Check constraint information.
 sUSRPrimaryColumns - Primary columns information (refers to PKeyInfo)
 sUSRUniqueColumns  - Unique columns information (refers to UniqueInfo)
 sUSRForeignColumns1 - Foreign column information (refers to FKeyInfo)
 sUSRForeignColumns2 - Secondary Foreign column information (refers to
 FKeyInfo).
 

 sUSRTableColumnInfo - All table and column information.
 

 The schema layout for these tables;
 CREATE TABLE sUSRPKeyInfo (
 id          NUMERIC NOT NULL,
 name        TEXT NOT NULL,  // The name of the primary key constraint
 schema      TEXT NOT NULL,  // The name of the schema
 table       TEXT NOT NULL,  // The name of the table
 deferred    BIT  NOT NULL,  // Whether deferred or immediate
 PRIMARY KEY (id),
 UNIQUE (schema, table)
 );
 CREATE TABLE sUSRFKeyInfo (
 id          NUMERIC NOT NULL,
 name        TEXT NOT NULL,  // The name of the foreign key constraint
 schema      TEXT NOT NULL,  // The name of the schema
 table       TEXT NOT NULL,  // The name of the table
 ref_schema  TEXT NOT NULL,  // The name of the schema referenced
 ref_table   TEXT NOT NULL,  // The name of the table referenced
 update_rule TEXT NOT NULL,  // The rule for updating to table
 delete_rule TEXT NOT NULL,  // The rule for deleting from table
 deferred    BIT  NOT NULL,  // Whether deferred or immediate
 PRIMARY KEY (id)
 );
 CREATE TABLE sUSRUniqueInfo (
 id          NUMERIC NOT NULL,
 name        TEXT NOT NULL,  // The name of the unique constraint
 schema      TEXT NOT NULL,  // The name of the schema
 table       TEXT NOT NULL,  // The name of the table
 deferred    BIT  NOT NULL,  // Whether deferred or immediate
 PRIMARY KEY (id)
 );
 CREATE TABLE sUSRCheckInfo (
 id          NUMERIC NOT NULL,
 name        TEXT NOT NULL,  // The name of the check constraint
 schema      TEXT NOT NULL,  // The name of the schema
 table       TEXT NOT NULL,  // The name of the table
 expression  TEXT NOT NULL,  // The check expression
 deferred    BIT  NOT NULL,  // Whether deferred or immediate
 PRIMARY KEY (id)
 );
 CREATE TABLE sUSRPrimaryColumns (
 pk_id   NUMERIC NOT NULL, // The primary key constraint id
 column  TEXT NOT NULL,    // The name of the primary
 seq_no  INTEGER NOT NULL, // The sequence number of this constraint
 FOREIGN KEY pk_id REFERENCES sUSRPKeyInfo
 );
 CREATE TABLE sUSRUniqueColumns (
 un_id   NUMERIC NOT NULL, // The unique constraint id
 column  TEXT NOT NULL,    // The column that is unique
 seq_no  INTEGER NOT NULL, // The sequence number of this constraint
 FOREIGN KEY un_id REFERENCES sUSRUniqueInfo
 );
 CREATE TABLE sUSRForeignColumns (
 fk_id   NUMERIC NOT NULL, // The foreign key constraint id
 fcolumn TEXT NOT NULL,    // The column in the foreign key
 pcolumn TEXT NOT NULL,    // The column in the primary key
 // (referenced)
 seq_no  INTEGER NOT NULL, // The sequence number of this constraint
 FOREIGN KEY fk_id REFERENCES sUSRFKeyInfo
 );
 CREATE TABLE sUSRSchemaInfo (
 id     NUMERIC NOT NULL,
 name   TEXT NOT NULL,
 type   TEXT,              // Schema type (system, etc)
 other  TEXT,
 UNIQUE ( name )
 );
 CREATE TABLE sUSRTableInfo (
 id     NUMERIC NOT NULL,
 name   TEXT NOT NULL,     // The name of the table
 schema TEXT NOT NULL,     // The name of the schema of this table
 type   TEXT,              // Table type (temporary, system, etc)
 other  TEXT,              // Notes, etc
 UNIQUE ( name )
 );
 CREATE TABLE sUSRColumnColumns (
 t_id    NUMERIC NOT NULL,  // Foreign key to sUSRTableInfo
 column  TEXT NOT NULL,     // The column name
 seq_no  INTEGER NOT NULL,  // The sequence in the table
 type    TEXT NOT NULL,     // The SQL type of this column
 size    NUMERIC,           // The size of the column if applicable
 scale   NUMERIC,           // The scale of the column if applicable
 default TEXT NOT NULL,     // The default expression
 constraints TEXT NOT NULL, // The constraints of this column
 other   TEXT,              // Notes, etc
 FOREIGN KEY t_id REFERENCES sUSRTableInfo,
 UNIQUE ( t_id, column )
 );