| |||||||
| |||||||
|
|
|
| FAQ How can I integrate Cross Translator into my Java™ application? Default download package for Windows comes with Developer documentation in PDF format, sample Java™ source files and Cross Translator runtime JAR (ctrancmd.jar). Integration is simple and can be done with just a few method calls. My JDBC driver does not work. Are there any specific requirements for it? Your JDBC driver has to be JDBC compliant and it has to be in the CLASSPATH for translator to load and use it. If you use translator engine packaged in JARs, it is easy, simply add classpath to your JDBC driver to the CLASSPATH passed into translator JARs. However if you use translator engine or tools packaged in EXE on Windows OS then you can set classpath using special variable CT_PLUGINS in your system environment to point to JDBC driver classes or JARs. Classpath in CT_PLUGINS is appended and passed to translator engine once Windows executable starts. JDBC connection works, but when I try to execute query it fails. Some JDBC drivers require database name to be passed in as parameters via connection string in DataPath property. Then you must provide database name in DataPath property otherwise your SQL statements will be failing. Check your JDBC driver vendor for details on required connection string parameters. Databases that require specific parameters in connection string are MS SQL Server, mySQL, Oracle. My mapping produces segments out of order. How to ensure correct order? Set Mandatory property for those out-of-order segments to true. If that does not help, click on the parent of the nested segment that comes out of order. Make sure that parent segment elements do not receive NULL values from the input side. If they do, you can use Function property getEmptyIfNull on the input side to replace NULL values with empty strings. mySQL JDBC driver does not work. mySQL JDBC driver is very sensitive on parameters it receives. You must provide database name in DataPath property otherwise your SQL statements will be failing. Example of DataPath that worked in our tests: jdbc://jdbc:mysql://localhost:3306/Test?user=monty&password=greatsqldb "Test" is our database name. Use your database name instead. How can I run it on Linux? 1. Install Java™ Runtime 1.4.x (JRE) on Linux. 2. Download and unzip Linux package cpsetup.zip from Download page. 3. Following script assumes that cpsetup.zip was unzipped into /home/testuser/cptrans/ directory. Script to run Map Editor: cd /home/testuser/cptrans/ /usr/java/j2re1.4.2_06/bin/java -classpath /home/testuser/cptrans/integration/lib/activation.jar :/home/testuser/cptrans/integration/lib/bsh-2.0b1.jar :/home/testuser/cptrans/integration/lib/ctrancmd.jar :/home/testuser/cptrans/integration/lib/mailapi.jar :/home/testuser/cptrans/integration/lib/plastix.jar :/home/testuser/cptrans/integration/lib/smtp.jar axMapEditor Script to run map via command line: cd /home/testuser/cptrans/ /usr/java/j2re1.4.2_06/bin/java -classpath /home/testuser/cptrans/integration/lib/activation.jar :/home/testuser/cptrans/integration/lib/bsh-2.0b1.jar :/home/testuser/cptrans/integration/lib/ctrancmd.jar :/home/testuser/cptrans/integration/lib/mailapi.jar :/home/testuser/cptrans/integration/lib/plastix.jar :/home/testuser/cptrans/integration/lib/smtp.jar axBatchRun [path_with_map_file_name.cmp] What is the difference between map execution on Linux and Windows? Message objects in the map have DataPath property. It should point to directory with search pattern or actual file. On Windows it can be: file://C:\test\ctrans\myinputfile.txt On Linux it can be: file:///home/testuser/maps/myinputfile.txt How to add new plug-ins in a form of new conditions and functions to translator? 1. Take this small Java class and save it as Check2.java. 2. Compile single Java file containing plug-in functions with javac Check2.java. 3. JAR class file with jar utility jar -cfM Check2.jar Check2.class 4. Add path to JAR in CT_PLUGINS. Like this: D:\mypath\Check2.jar 5. Open your map. Go to Plug-in Options and add Check2 (see screen shot). Save map with different name and restart Map Editor. Open this new map. (see result screen shot) |
|
|
Site Content © 2004 Etasoft Inc. | |