Necessary changes from CloverETL ver. 1.x to 2.x

• JDBC connections must be in form of : <Connection type=”JDBC” …./> instead of <DBConnection …./>
• Added “type” attribute to sequences : <Sequence type=“SIMPLE_SEQUENCE” …./>
• “DataPolicy” attribute changed to “dataPolicy” in Readers and Writers
• Dismissed suffix “_NIO” from “type” attribute. E.g.: type=“DELIMITED_DATA_READER_NIO” to type=“DELIMITED_DATA_READER”
• Each attribute, which is not in Node mark directly, has to be in form: <attr name=”….”>…..</attr>

E.g.

create table EMPLOYEE
(
  EMP_NO      NUMBER not null,
  FIRST_NAME  VARCHAR2(15) not null,
  JOB_GRADE   NUMBER(4,2) not null,
  JOB_COUNTRY VARCHAR2(15) not null,
  SALARY      NUMBER(15,2) not null,
  FULL_NAME   VARCHAR2(35)
);

....

changed to:

create table EMPLOYEE
(
  EMP_NO      NUMBER not null,
  FIRST_NAME  VARCHAR2(15) not null,
  JOB_GRADE   NUMBER(4,2) not null,
  JOB_COUNTRY VARCHAR2(15) not null,
  SALARY      NUMBER(15,2) not null,
  FULL_NAME   VARCHAR2(35)
);

....

• Components, which can transform data have only “transform” and “transformClass” attributes instead of “transform”, “transformClass”, “javaSource”,”libraryPath”. The last two attributes must be changed to “transform” and “transformClass” respectively.
• In components with “SQLCode” attribute is preferred another attribute, which codes sql code (“dbSQL” for “DB_EXECUTE”, “sqlQuery” for DB_INPUT_TABLE and DB_OUTPUT_TABLE). In GUI “SQLCode” attribute is abandoned.
• In “SYS_EXECUTE” component “errorLines” attribute changed to “capturedErrorLines”
• “LineSeparatorSize” and “OneRecordPerLine” attributes in FIXLEN_DATA_READER were abolished. Instead of them use “recordDelimiter” attribute in metadata.
• XML comments should be represented by parameters, e.g.: graph description should be as a graph parameter “description”. (Using GUI causes loss of comments.)

• Transformation graph is not a singleton any more. Because of it, static method TransformationGraph.getReference() does not work . In classes, which extend GraphElement there is method getGraph(), in RecordTransform it is possible to call “graph” directly
• There was changed signature of fromXML method in Node class:

	public static Node fromXML(TransformationGraph graph, Element xmlElement ) throws XMLConfigurationException 

• In each constructor of DBLookupTable, SimpleLookupTable,SimpleSequence and DBConnection there is “id” string as first parameter added.
• Phase has its own class, it is not represented by int any more
• Dismissed suffix “NIO” from some components, e.g.: DelimitedDataReaderNIO.java is now DelimitedDataReader.java
• Method addNode, was moved from TransformationGraph class to Phase class, e.g.:

	graph.addNode(nodeRead,_PHASE_1); changed to _PHASE_1.addNode(nodeRead);

• Some methods throws ComponentNotReadyException instead of JetelException (e.g. SimpleLookupTable.init() )
• The structure of CloverETL was completely changed. Clover Engine was split into 5 parts: commons, component, connection, engine, lookup and sequence. These parts are handled as plug-ins. (Imports should be corrected,because of it.) You can move your components, connections, sequences, lookups to your own plug-in with xml description.