HALE via command line - using postgres

Added by An Crabbe over 2 years ago

I would like to use the command line for transforming my HALE project, since the GUI cannot handle my data (> 4 million records).
I made the project in HALE on a subset of the data, made sure it worked perfectly fine and saved the project as 'halez'

However I cannot get it to work. I tried the following syntax. But to be honnest, I have no clue what I am doing or if it makes sense or if all parameters are required...
(I put an ' before the dashes because otherwise my text would be striped trough and I didn't know how to change it)

C:\HALE-2.9.3> HALE
'-nosplash
'-application hale.transform
'-project MYPROJECT.halez <-- I put it in the HALE folder
'-source jdbc:postgresql://localhost:5432/MYDATABASE
'-providerId eu.esdihumboldt.hale.io.jdbc.JDBCInstanceReader
'-jdbc.user MYUSER
'-jdbc.password MYPASSWORD
'-contentType eu.esdihumboldt.hale.io.jdbc
'-charset UTF-8
'-target MYOUTPUT.gml
'-preset GMLFeatureCollection <-- i created this preset in the project

It only gives me the following pop-up text (see below message).
Can anyone help me with this syntax?

Thank you.

---------------------------
HUMBOLDT Alignment Editor
---------------------------
Java was started but returned exit code=1
'-Xmx800m
'-XX:MaxPermSize=128m
'-Dsun.net.client.defaultConnectTimeout=10000
'-Dsun.net.client.defaultReadTimeout=20000
'-Dcache.level1.enabled=false
'-Dcache.level1.size=0
'-Dcache.level2.enabled=false
'-Dcache.level2.size=0
'-Djava.class.path=C:\HALE-2.9.3\\plugins/org.eclipse.equinox.launcher_1.3.0.v20140415-2008.jar
'-os win32
'-ws win32
'-arch x86_64
'-launcher C:\HALE-2.9.3\HALE.exe
'-name HUMBOLDT Alignment Editor
'--launcher.library C:\HALE-2.9.3\\plugins/org.eclipse.equinox.launcher.win32.win32.x86_64_1.1.200.v20140603-1326\eclipse_1603.dll
'-startup C:\HALE-2.9.3\\plugins/org.eclipse.equinox.launcher_1.3.0.v20140415-2008.jar
'--launcher.overrideVmargs
'-clean
'-application hale.transform
'-project MYPROJECT.halez
'-source jdbc:postgresql://localhost:5432/MYDATABASE
'-providerId eu.esdihumboldt.hale.io.jdbc.JDBCInstanceReader
'-jdbc.user USERNAME
'-jdbc.password PASSWORD
'-contentType eu.esdihumboldt.hale.io.jdbc
'-charset UTF-8
'-target MYOUTPUT.gml
'-preset GMLFeatureCollection
'-vm C:\HALE-2.9.3\jre\bin\server\jvm.dll
'-vmargs
'-Xmx800m
'-XX:MaxPermSize=128m
'-Dsun.net.client.defaultConnectTimeout=10000
'-Dsun.net.client.defaultReadTimeout=20000
'-Dcache.level1.enabled=false
'-Dcache.level1.size=0
'-Dcache.level2.enabled=false
'-Dcache.level2.size=0
'-Djava.class.path=C:\HALE-2.9.3\\plugins/org.eclipse.equinox.launcher_1.3.0.v20140415-2008.jar
---------------------------
OK
---------------------------


Replies (1)

RE: HALE via command line - using postgres - Added by Simon Templer over 2 years ago

Hi Ann,

you should do three things:

  1. either run the command line with Java or use the -console parameter before -application to also get textual feedback from the command line call
  2. change the -providerId to eu.esdihumboldt.hale.io.jdbc.instance.reader - the identifier must be used here, not the implementation class
  3. provide settings for source or target with a -S preceding the setting name, e.g. -Sjdbc.user USERNAME

More information can be found in the HALE help

As an alternative you can also try use one of the following options to run the transformation from the HALE UI (both found in the Transformation menu):

  • "Transform project data" if you reduced your data using "instance sampling"
  • "Transform external data" to transform a different source for the data than what is configured in the project

Best regards,
Simon

(1-1/1)