com.bankframe.admin.tools
Class MigratePersisterTxnMap

java.lang.Object
  com.bankframe.admin.tools.MigratePersisterTxnMap

public class MigratePersisterTxnMap

extends java.lang.Object

This class creates an SQL script with the current contents of the Persister_Txn_Map table. This class is run before the new MCA is installed to generate an SQL script of the current Persister_Txn_Map table. After the new MCA is installed the SQL script is run to repopulate the Persister_Txn_Map table with the original Persister data. This may cause SQLExceptions due to migrated Persister data being already installed by the MCA installation script. Check database after the migration script is run. The METHODNAME column in the Persister_Txn_Map table for MCA 5.0 has a size of 100 characters. Previously this column was 50 characters in length.

Usage:
java com.bankframe.admin.tools.MigratePersisterTxnMap -url [jdbcUrl] -driver [jdbcDriver] -u [username] -p [password] -t [tablespace] -script [script name]
Options:

1. -url The JDBC URL of the database
2. -driver The JDBC Driver to use to access the database. Note the driver must be in the classpath
3. -u The username to connect to the database as
4. -p The password to connect to the database as
5. -t The tablespace to use. This defaults to the username
6. -script The name of the SQL script to create with the migrated contents of the persister_txn_map table

Author:

ETU

Constructor Summary

MigratePersisterTxnMap()
Constructor

Method Summary

static void	main(java.lang.String[] args)
void	migratePersisterTxnMap(java.lang.String url, java.lang.String driver, java.lang.String username, java.lang.String password, java.lang.String tablespace, java.lang.String script) This method initialises tool and starts processing

Methods inherited from class java.lang.Object

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

Constructor Detail

MigratePersisterTxnMap

public MigratePersisterTxnMap()

Constructor

Method Detail

main

public static void main(java.lang.String[] args)

Parameters:

args - String array

migratePersisterTxnMap

public void migratePersisterTxnMap(java.lang.String url,
                                   java.lang.String driver,
                                   java.lang.String username,
                                   java.lang.String password,
                                   java.lang.String tablespace,
                                   java.lang.String script)
                            throws java.sql.SQLException,
                                   java.io.IOException

This method initialises tool and starts processing

Parameters:

url - is the JDBC URL of the database

driver - is the JDBC Driver to use to access the database. Note the driver must be in the classpath

username - is the username to connect to the database as

password - is the password to connect to the database as

script - is contents script file name.

tablespace - is the tablespace to use. This defaults to the username

Throws:

java.sql.SQLException

java.io.IOException