com.bankframe.admin.tools
Class MigrateDestination

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

public class MigrateDestination

extends java.lang.Object

This class migrates the Destination table prior to MCA 5.0 to the MCA 5.0 style Destination table. This class is run before the new MCA is installed to generate an SQL script of the current destination table with migrated data. After the new MCA is installed the SQL script is run to repopulate the destination table with the migrated destinations. This may cause SQLExceptions due to migrated destinations being already installed by the MCA installation script. Check database after the migration script is run. The Destination table in MCA 5.0 has an extra column called HOST_STATUS. This class creates the SQL script for inserting data into the Destination table with the current data and the default value 'ON_LINE' in the HOST_STATUS column. If the column JNDI_NAME is found in the current database the value of the column is inserted into the updated column CONNECTOR_FACTORY_CLASSNAME, but the values in this column will still have to be updated from the factory classname in the BankframeResource.properties after the migration script is run.

Usage:
java com.bankframe.admin.tools.MigrateDestination -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 destination table

Constructor Summary

MigrateDestination()
Constructor

Method Summary

static void	main(java.lang.String[] args)
void	migrateDestination(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

MigrateDestination

public MigrateDestination()

Constructor

Method Detail

main

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

Parameters:

args - String array

migrateDestination

public void migrateDestination(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