| garrycl |
| Newbie |
|
| Maleny |
|
|
| None Specified |
|
| Thursday, September 4, 2014 |
| Wednesday, January 21, 2015 1:02:50 AM |
6
[0.03% of all post / 0.00 posts per day] |
|
We have a situation where we receive an error message stating that the parameters passed to an output XML file are not equal in number.
The situation occurs when one of the XML outputs is an intermediary source for the other XML output. And, only occurs after we add a dynamic path/filename to the upstream/intermediary output file.
Any thoughts appreciated.
Garry
|
Fantastic, the "concat" did the job :)
The command line now has only one arg, e.g: /JID 1645.bzo7fdts23551ex4e88uo791p44c3a9ca56a02ca599c0855
Thank you.
Garry
|
Thanks for that.
However, these are URL's to an API.
E.G.:
http://branches.xxxxx.com/api/app/api/rest/accounts/get/xml/?data=<Accounts><JID>1645.bzo7fdts23551ex4e88uo791p44c3a9ca56a02ca599c0855</JID><SourceOrTarget>Source</SourceOrTarget><System>1</System></Accounts>
The JID is what will need to be replaced for each job.
All the best.
Garry
|
We are using multiple data sources with a URL to each of them. Each is an endpoint for our API.
One parameter will change for each of the mapping transforms, i.e. the same parameter for each of the URLs. That is, our "Migration ID" to identify which data set is to be transformed.
Our intention is to use generated Java and the command line input to perform these ongoing transforms.
Whilst we could use the dynamic filename system, the number of URLs and their length would make this a "messy" option. Whereas, a simple wildcard with the "Migration ID" as a command line input would be very nice :)
Any clues on how this could be achieved?
Thank you.
Garry
|
OK, I've been able to resolve this by adding the path to the driver in the build.xml file.
<target name="test" depends="compile">
<java classpath="C:\Users\GarryClaridge\Documents\MapForceJava\Test4;C:\Program Files (x86)\MySQL\MySQL Connector J\mysql-connector-java-5.1.32-bin.jar" classname="com.mapforce.MappingConsole" fork="true" failonerror="false">
<arg line="${cmdline}"/>
</java>
</target>
The next runtime issue is this error from the MappingMapToConnection1.class:
test:
[java] Mapping Application
[java] Connecting to UDSN_QB database...
[java] Connecting to Connection1 database...
[java] ERROR: [QODBC] Option value changed.
[java] Stack Trace:
[java] sun.jdbc.odbc.JdbcOdbcSQLWarning: [QODBC] Option value changed.
...
at com.mapforce.MappingMapToConnection1.run(MappingMapToConnection1.java:819)
...
It is at this line:
writeDB(mapping, new com.altova.db.Catalog(Connection1TargetConnection, 60, true));
Any ideas?
Garry
|
I am using the trial version of MapForce 2014 del 2 sp1.
I have successfully created a test map from Quickbooks to MySQL. Unfortunately, I have not been able to successfully compile the exported Java code using the Eclipse IDE.
[java] Mapping Application
[java] ERROR: com.mysql.jdbc.Driver
[java] Stack Trace:
[java] java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
[java] at java.net.URLClassLoader$1.run(Unknown Source)
[java] at java.net.URLClassLoader$1.run(Unknown Source)
[java] at java.security.AccessController.doPrivileged(Native Method)
[java] at java.net.URLClassLoader.findClass(Unknown Source)
[java] at java.lang.ClassLoader.loadClass(Unknown Source)
[java] at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
[java] at java.lang.ClassLoader.loadClass(Unknown Source)
[java] at java.lang.Class.forName0(Native Method)
[java] at java.lang.Class.forName(Unknown Source)
[java] at com.mapforce.MappingConsole.main(MappingConsole.java:34)
Yet, I have added the driver jar to the referenced libraries in the Eclipse Java Project:
C:\Program Files (x86)\MySQL\MySQL Connector J\mysql-connector-java-5.1.32-bin.jar
I can independently compile the MappingConsole.java code with other obvious errors - however, it passes the driver class load. Other test classes including the driver work fully. The problem seems to only occur when I attempt to compile from the build.xml file.
<?xml version="1.0"?>
<project name="Mapping" default="test" basedir=".">
<property name="build.sysclasspath" value="last"/>
<target name="compile">
<javac srcdir="." classpath="." />
</target>
<target name="test" depends="compile">
<java classpath="C:\Users\GarryClaridge\Documents\MapForceJava\Test4" classname="com.mapforce.MappingConsole" fork="true" failonerror="true">
<arg line="${cmdline}"/>
</java>
</target>
<target name="clean">
<delete>
<fileset dir=".">
<include name="**/*.class"/>
<include name="*.jar"/>
</fileset>
</delete>
</target>
<target name="manifest" depends="compile">
<mkdir dir="C:\Users\GarryClaridge\Documents\MapForceJava\Test4/META-INF"/>
<manifest file="C:\Users\GarryClaridge\Documents\MapForceJava\Test4/META-INF/MANIFEST.MF" mode="replace">
<attribute name="Created-By" value="MapForce 2014r2sp1"/>
<attribute name="Main-Class" value="com.mapforce.MappingConsole"/>
</manifest>
</target>
<target name="jar" depends="manifest">
<jar destfile="Mapping.jar" manifest="C:\Users\GarryClaridge\Documents\MapForceJava\Test4/META-INF/MANIFEST.MF" basedir="." includes="**/*.xml **/*.class **/*.png **/*.wsdl **/MANIFEST.MF" excludes="**/*.java"/>
</target>
</project>
Any help will be greatly appreciated :)
All the best.
Garry
|
|
