Class Hierarchy    Previous  Next  Index

Class COM.cloudscape.synchronization.TransactionListVTI

java.lang.Object
    |
    +----COM.cloudscape.vti.VTITemplate
            |
            +----COM.cloudscape.synchronization.TransactionListVTI

public class TransactionListVTI
extends VTITemplate
Copyright © 1998-2000, Informix Software, Inc. All rights reserved.

Virtual Table to wrap a list of Replicated Transactions. This Virtual Table can be used on
  1. A failed transaction logged in SYSERRORS
  2. The REFRESH Request message, as dumped with the -Dcloudscape.DataComm.trace=true flag
  3. The REFRESH Reply message, as dumped with the -Dcloudscape.DataComm.trace=true flag
This Virtual Table has the following shape:

COLUMN NAME DATATYPE DESCRIPTION
TRAN_NUMBER int transaction number
ORIGINATING_DBID char(36) id of database where the transaction originated
ORIGINATING_COMMIT_INSTANT DatabaseInstant marks when the transaction originally committed
SUMMARY String brief description of transaction
STATEMENT_LIST ColumnResultSet a StatementListVTI holding the statements in the transaction

Here's the SQL for creating a TransactionListVTI on a failed transaction logged to SYSERRORS. The third argument specifies how long the SUMMARY columns should be, both for the Transaction and embedded Statement Lists:
SELECT * FROM new COM.cloudscape.synchronization.TransactionListVTI
( 'syserrors', '8000001c-00d0-fd77-3ed8-000a0a0b1900', 20 ) T_LIST
Here's the SQL for creating a TransactionListVTI on a REFRESH request message. 'HttpTrace0' is the name of the file dumped by the -Dcloudscape.DataComm.trace=true flag:
SELECT * FROM new COM.cloudscape.synchronization.TransactionListVTI( 'refresh request', 'HttpTrace0', 20 ) TL
Here's the SQL for creating a TransactionListVTI on a REFRESH reply message. 'HttpTrace2' is the name of the file dumped by the -Dcloudscape.DataComm.trace=true flag:
SELECT * FROM new COM.cloudscape.synchronization.TransactionListVTI( 'refresh reply', 'HttpTrace2', 20 ) T_LIST


Constructor Index

 o TransactionListVTI(String, String, int)
Make a TransactionListVTI from a bucket of transactions.

Method Index

 o close()
 
 o getInt(int)
 
 o getMetaData()
 
 o getObject(int)
 
 o getString(int)
 
 o next()
 
 o printFailedTransaction(String)
This method returns a ColumnResultSet wrapping the contents of a SYSERRORS tuple.
 o printFailedTransaction(String, int)
This method returns a ColumnResultSet wrapping the contents of a SYSERRORS tuple.
 o wasNull()
 

Constructor Detail

 o TransactionListVTI
public TransactionListVTI(java.lang.String sourceKind,
                          java.lang.String bucket,
                          int summaryColumnLength) throws java.sql.SQLException
          Make a TransactionListVTI from a bucket of transactions.
Parameters:
sourceKind - kind of bucket: "syserrors", "refresh request", "refresh reply"
bucket - bucket holding replication transactions. E.g., the id of a SYSERRORS tuple or the name of a flat file
summaryColumnLength - display length of SUMMARY column, both in this VTI and in any nested StatementListVTIs
Throws:
java.sql.SQLException - thrown on error

Method Detail

 o printFailedTransaction
public static ColumnResultSet printFailedTransaction(java.lang.String errorID)
          This method returns a ColumnResultSet wrapping the contents of a SYSERRORS tuple. The ColumnResultSet materializes a TransactionListVTI from the SYSERRORS tuple. The size of SUMMARY columns (in this VTI and its embedded Statement VTIs) is 25 characters.
Parameters:
errorID - Key of the SYSERRORS row which holds the failed transaction.
Returns:
a ColumnResultSet wrapping the transaction contents.
 o printFailedTransaction
public static ColumnResultSet printFailedTransaction(java.lang.String errorID,
                                                     int summaryColumnLength)
          This method returns a ColumnResultSet wrapping the contents of a SYSERRORS tuple. The ColumnResultSet materializes a TransactionListVTI from the SYSERRORS tuple.
Parameters:
errorID - Key of the SYSERRORS row which holds the failed transaction.
summaryColumnLength - Display length of SUMMARY column, both in this VTI and in any nested StatementListVTIs
Returns:
a ColumnResultSet wrapping the transaction contents.
 o wasNull
public boolean wasNull() throws java.sql.SQLException
Throws:
java.sql.SQLException - thrown on error
Overrides:
wasNull in class VTITemplate
 o next
public boolean next() throws java.sql.SQLException
Throws:
java.sql.SQLException - thrown on error
 o getMetaData
public java.sql.ResultSetMetaData getMetaData()
 o getInt
public int getInt(int columnIndex) throws java.sql.SQLException
Throws:
java.sql.SQLException - thrown on error
Overrides:
getInt in class VTITemplate
 o getString
public java.lang.String getString(int columnIndex) throws java.sql.SQLException
Throws:
java.sql.SQLException - thrown on error
Overrides:
getString in class VTITemplate
 o getObject
public java.lang.Object getObject(int columnIndex) throws java.sql.SQLException
Throws:
java.sql.SQLException - thrown on error
Overrides:
getObject in class VTITemplate
 o close
public void close() throws java.sql.SQLException
Throws:
java.sql.SQLException - thrown on error

  Class Hierarchy    Previous  Next  Index