Run cloverETl through ANT task

jcuendet

• September 10, 2010 00:00

• Answered

Follow

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:

<project name="etl">

<property name="clover.home" value="D:/ETL/eclipse/plugins/com.cloveretl.gui_2.9.2/lib"/>
<property name="java.args" value="-server -XX:+UseConcMarkSweepGC -Xmx1024m -Xms1024m"/>
<property name="graph.path" value="D:/ETL/workspace/test/graph/testCTmapping.grf"/>
<property name="plugins.path" value="D:/ETL/eclipse/plugins/com.cloveretl.gui_2.9.2/lib/plugins"/>

<path id="classpath">
<fileset dir="${clover.home}/lib" includes="*.jar"/>
</path>

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

</project>

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.<init>(FileInputStream.java:106)
[java] at java.io.FileInputStream.<init>(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

• 

  avackova

  • September 10, 2010 12:03

  0

  Comment actions Permalink

  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>
  

• 

  carlo.balbo

  • April 10, 2012 10:56

  0

  Comment actions Permalink

  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.

Please sign in to leave a comment.