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:
-url
The JDBC URL of the database
-driver
The JDBC Driver to use to access the database. Note the driver must be in the classpath
-u
The username to connect to the database as
-p
The password to connect to the database as
-t
The tablespace to use. This defaults to the username
-script
The name of the SQL script to create with the migrated contents of the destination table
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 |
MigrateDestination
public MigrateDestination()
- Constructor
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 databasedriver
- is the JDBC Driver to use to access the database.
Note the driver must be in the classpathusername
- is the username to connect to the database aspassword
- is the password to connect to the database asscript
- is contents script file name.tablespace
- is the tablespace to use. This defaults to the username
- Throws:
java.sql.SQLException
java.io.IOException
Copyright © 2005, 2007, Oracle. All rights reserved.