• Install & Configure Java JDK 1.6 or higher

• Install & Configure Maven 3.0 or higher

• Clone and Build (mvn clean install) the OpenEngSB with XLink and the Domains 'SQLCreate' and 'OOSoureCode'

• Clone and Build (mvn clean install) the java-loom Bridge

• Build (mvn clean install) this project

• You find the program in the directory 'target', its 'org.openengsb.xlink.xlinkjavaclient-[version]-jar-with-dependencies.jar'

• To run the program, got to 'target/classes' and copy the files 'application.properties' and 'log4j.properties' into the same directory as your .jar

• Configure the program arguments in 'application.properties'
  

  1. Change Username, Password and Context if necessary.
     
  2. If the OpenEngSB Server is not running on your local machine, the 'openengsb.hostIp' has to be changed to the Ip of the
     network interface that connects to the server (default is 127.0.0.1).
     
  3. If the OpenEngSB Server is not running on your local machine, the 'xlink.baseUrl' has to be changed as well.
     
  4. Set the 'working.dir' to a local directory.
     
  5. Copy the 'creates.sql' to this directory.
     

• Start the OpenEngSB server and make sure that the JMS-Port bundle is installed
  Note that, if server and client are not running on the same machine, the xlink base-URL (e.g. contains also the server URL) must be configured in $OPENENGSB_HOME$/etc/org.openengsb.core.services.internal.connectormanager.cfg

• Start the Java-Client

The Program filters SQL CreateStatements in this abstract syntax

A Statement is of the structure

CREATE TABLE 'TABLENAME' ( 'fieldName' 'dataType' 'listOfConstraints', );

Make sure that the opening and closing bracket have no leading or trailing spaces. Every fieldDefintion must be written in it's own row.

Accepted Constraints are PRIMARY KEY NOT NULL REFERENCES 'tableName'('fieldName')

• Client automatically connects to the OpenEngSB and registers for XLink
• .sql Files in the WorkingDirectory can be opened and CreateStatements are viewed in a List
• For each Statement, details can be displayed
• Via a PopUp-Menu (right-click on a Statement), a valid XLink-URL is copied into the clipboard
• Incoming potential Matches are searched in the WorkingDirectory and, if found, the most likely match is displayed.
• Incoming updates about other local tools that support XLink are processed.

• Creation of Statements