Running the Samples

Section - Java Deployment

Transformation Manager is supplied complete with a set of samples in the directory "samples\\deployment\\examples". (This is a relative path from the TM install directory - thus if you have chosen to install TM in "X:\\TM" then the complete path is "X:\\TM\\samples\\deployment\\examples").

To run the samples you will need to follow the following steps:

• Open TM Design Tool and build each of the projects in turn. They have already been set to generate the jar code to "samples\\deployment\\lib". When generation has finished the directory "samples\\deployment\\lib" should contain the files :

1. ETL_BasicXMLErcHandler_1_0.jar
2. ETL_GenericToJava_1_0.jar
3. ETL_JavaToGeneric_1_0.jar
4. ETL_JavatoJavaEmbededXML_2_0.jar
5. ETL_JavaToJavaWithError_2_0.jar
6. ETL_JavaToJava_2_0.jar
7. ETL_JavaToJDBC_2_0.jar
8. ETL_JavaToXML_2_0.jar
9. ETL_JDBCToJavaFilter_1_0.jar
10. ETL_JDBCToJava_2_0.jar
11. ETL_LLJavatoJavaEmbededXML_1_0.jar
12. ETL_XMLToJava_3_0.jar
13. ETL_XMLtoXML_1_0.jar

• You will also need to build the supplied Java code. The directory "samples\\deployment\\examples contains the actual Java samples themselves - the main file here is "ExamplesInJava". This contains a number of very simple utility procedures for displaying the results of the transforms and also the static strings defining the location of the various sources and targets used in the examples. Note that for reasons of simplicity these read and write only from the supplied examples Ms Access data bases using JDBC/ODBC not from Oracle or Sybase (as is described in the text). There is, of course, no need to have Ms Access actually installed in your system.  The directories tgt and src contain the actual Java instance models used in the examples. All the Java code must be built for the system to run. This may vary from system to system. Using JBuilder (recommended) the steps you need to perform are:
  Create a new JBuilder project for your examples:

1. Set the source path to something like "X:\\TM\\samples\\deployment\\examples"
2. Add the packages "examples" and "examples.tgt" and "examples.src" to your product. 
3. Ensure that the libraries include both ofetsr.jar and the generated jar files listed above.
4. Generate and run the Java code. Running in the JBuilder debugger is highly recommended as it allows you to focus in on items of interest.