Run cloverETl through ANT task

CloverDX Platform
1

Hi,

I’d like to run Clover ETL through ANT tasks,

I used the following syntax but I wasn’t able to load the plugins:

And I got the following error:

JAVA_HOME=D:\riskpro3\rp\bin\jdk
ANT_HOME=D:\riskpro3\rp\bin\ant
Buildfile: D:\riskpro3\rp\bin\run-etl.xml

runETL:
[java] INFO [main] - *** CloverETL framework/transformation graph, (c) 2002-2010 Javlin a.s, released under GNU L
esser General Public License ***
[java] INFO [main] - Running with CloverETL library version 2.9.2 build#18 compiled 22/04/2010 13:46:41
[java] INFO [main] - Running on 2 CPU(s), OS Windows XP, architecture x86, Java version 1.6.0_18, max available me
mory for JVM 506816 KB
[java] INFO [main] - Loading default properties from: defaultProperties
[java] ERROR [main] - Plugins repository ‘.\plugins’ is not available (skipped).
[java] WARN [main] - Engine starts without plugins.
[java] INFO [main] - Graph definition file: D:/ETL/workspace/test/graph/testCTmapping.grf
[java] ERROR [main] - Error in reading graph from XML !
[java] org.jetel.exception.XMLConfigurationException: Can’t load property definition from workspace.prm
[java] at org.jetel.graph.TransformationGraphXMLReaderWriter.instantiateProperties(TransformationGraphXMLReader
Writer.java:757)
[java] at org.jetel.graph.TransformationGraphXMLReaderWriter.read(TransformationGraphXMLReaderWriter.java:328)
[java] at org.jetel.graph.TransformationGraphXMLReaderWriter.read(TransformationGraphXMLReaderWriter.java:284)
[java] at org.jetel.graph.TransformationGraphXMLReaderWriter.loadGraph(TransformationGraphXMLReaderWriter.java:
213)
[java] at org.jetel.main.runGraph.main(runGraph.java:334)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:597)
[java] at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:217)
[java] at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:152)
[java] at org.apache.tools.ant.taskdefs.Java.run(Java.java:771)
[java] at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:221)
[java] at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:135)
[java] at org.apache.tools.ant.taskdefs.Java.execute(Java.java:108)
[java] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:597)
[java] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
[java] at org.apache.tools.ant.Task.perform(Task.java:348)
[java] at org.apache.tools.ant.Target.execute(Target.java:390)
[java] at org.apache.tools.ant.Target.performTasks(Target.java:411)
[java] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)
[java] at org.apache.tools.ant.Project.executeTarget(Project.java:1329)
[java] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
[java] at org.apache.tools.ant.Project.executeTargets(Project.java:1212)
[java] at org.apache.tools.ant.Main.runBuild(Main.java:801)
[java] at org.apache.tools.ant.Main.startAnt(Main.java:218)
[java] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
[java] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
[java] Caused by: java.io.FileNotFoundException: workspace.prm (The system cannot find the file specified)
[java] at java.io.FileInputStream.open(Native Method)
[java] at java.io.FileInputStream.(FileInputStream.java:106)
[java] at java.io.FileInputStream.(FileInputStream.java:66)
[java] at org.jetel.util.file.FileUtils.getInputStream(FileUtils.java:281)
[java] at org.jetel.util.file.FileUtils.getReadableChannel(FileUtils.java:226)
[java] at org.jetel.graph.TransformationGraph.loadGraphPropertiesSafe(TransformationGraph.java:724)
[java] at org.jetel.graph.TransformationGraphXMLReaderWriter.instantiateProperties(TransformationGraphXMLReader
Writer.java:755)
[java] … 31 more
[java] Java Result: -1

It seems that plugins are not loaded.
Do you have any idea how to do that?

Thanks
Jerome

2

Hello Jerome,
you need to pass -plugins and ${plugins.path} as two arguments, i.e:

<target name="runETL">
<java classname="org.jetel.main.runGraph" classpathref="classpath" >
<arg value="-plugins"/>
<arg value="${plugins.path}"/>
<arg value="${graph.path}"/>
</java>
</target>
3

Hi,

I have this problem:

[java] ERROR [main] - Error during graph initialization !
[java] java.security.AccessControlException: access denied (javax.management.MBeanTrustPermission register)
[java] at java.security.AccessControlContext.checkPermission(AccessControlContext.java:374)
[java] at java.lang.SecurityManager.checkPermission(SecurityManager.java:568)
[java] at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.checkMBeanTrustPermission(DefaultMBeanServerInterceptor.java:1824)
[java] at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(DefaultMBeanServerInterceptor.java:310)
[java] at com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(JmxMBeanServer.java:482)
[java] at org.jetel.graph.runtime.WatchDog.registerTrackingMBean(WatchDog.java:382)
[java] at org.jetel.graph.runtime.WatchDog.init(WatchDog.java:141)
[java] at org.jetel.graph.runtime.SimpleThreadManager.initWatchDog(SimpleThreadManager.java:39)
[java] at org.jetel.main.runGraph.executeGraph(runGraph.java:428)
[java] at org.jetel.main.runGraph.runGraph(runGraph.java:366)
[java] at org.jetel.main.runGraph.main(runGraph.java:328)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:597)
[java] at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:217)
[java] at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:152)
[java] at org.apache.tools.ant.taskdefs.Java.run(Java.java:771)
[java] at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:221)
[java] at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:135)
[java] at org.apache.tools.ant.taskdefs.Java.execute(Java.java:108)
[java] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:597)
[java] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
[java] at org.apache.tools.ant.Task.perform(Task.java:348)
[java] at org.apache.tools.ant.Target.execute(Target.java:390)
[java] at org.apache.tools.ant.Target.performTasks(Target.java:411)
[java] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
[java] at org.apache.tools.ant.Project.executeTarget(Project.java:1368)
[java] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
[java] at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
[java] at org.apache.tools.ant.Main.runBuild(Main.java:809)
[java] at org.apache.tools.ant.Main.startAnt(Main.java:217)
[java] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
[java] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
[java] Java Result: -1

have you some suggestion?

Thanks,
Carlo.