topic Re: database initialization job in Talend Studio

database initialization job

Anonymous — Mon, 17 Jun 2019 09:30:21 GMT

Hello,

I have a sql script to create a database.
the goal is to execute this script via a talend job.
the database is mysql

Best Regards

Re: database initialization job

TRF — Mon, 17 Jun 2019 09:38:11 GMT

Not sure creating a database from a Talend job is possible with "t<database>" components as soon as they require a database connection first.

However you can go with tSystem to call mysql and run your script.

Re: database initialization job

Anonymous — Mon, 17 Jun 2019 09:41:20 GMT

I did that. But it doesn't work.

Capture.PNG

Re: database initialization job

TRF — Mon, 17 Jun 2019 10:02:34 GMT

First of all, sqlplus command is for Oracle, not for MySQL.

However, share error massages if any.

Re: database initialization job

Anonymous — Mon, 17 Jun 2019 10:05:41 GMT

org.talend.designer.runprocess.ProcessorException: Erreurs de compilation du Job 
Au moins le Job "Initialisation_DSA" a des erreurs de compilation, réparez et réexportez.
Ligne en erreur: 362
Message détaillé: root cannot be resolved to a variable
Il peut y avoir d'autres erreurs causées par la compatibilité avec la JVM. Vérifiez que les paramètres de votre JVM sont les mêmes que dans le studio.

	at org.talend.designer.runprocess.JobErrorsChecker.checkLastGenerationHasCompilationError(JobErrorsChecker.java:338)

	at org.talend.designer.runprocess.DefaultRunProcessService.checkLastGenerationHasCompilationError(DefaultRunProcessService.java:510)

	at org.talend.designer.runprocess.RunProcessService.checkLastGenerationHasCompilationError(RunProcessService.java:316)

	at org.talend.designer.runprocess.ProcessorUtilities.generateBuildInfo(ProcessorUtilities.java:820)

	at org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:601)

	at org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:1861)

	at org.talend.designer.runprocess.RunProcessContext$1.run(RunProcessContext.java:601)

	at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:466)

	at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:374)

	at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:527)

	at org.eclipse.ui.internal.progress.ProgressMonitorJobsDialog.run(ProgressMonitorJobsDialog.java:284)

	at org.eclipse.ui.internal.progress.ProgressManager.run(ProgressManager.java:1190)

	at org.talend.designer.runprocess.RunProcessContext.exec(RunProcessContext.java:548)

	at org.talend.designer.runprocess.ui.ProcessComposite.exec(ProcessComposite.java:1401)

	at org.talend.designer.runprocess.ui.views.ProcessView$RunAction.run(ProcessView.java:701)

	at org.talend.designer.runprocess.ui.actions.RunProcessAction.run(RunProcessAction.java:58)

	at org.talend.designer.core.debug.JobLaunchConfigurationDelegate$1.run(JobLaunchConfigurationDelegate.java:84)

	at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)

	at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:136)

	at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4147)

	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3764)

	at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1151)

	at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

	at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1032)

	at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:148)

	at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:636)

	at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

	at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:579)

	at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)

	at org.talend.rcp.intro.Application.start(Application.java:265)

	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)

	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)

	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)

	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

	at java.lang.reflect.Method.invoke(Unknown Source)

	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:648)

	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:603)

	at org.eclipse.equinox.launcher.Main.run(Main.java:1465)

What's the expression for mysql?

Re: database initialization job

TRF — Mon, 17 Jun 2019 10:14:10 GMT

Command must be enclosed beween "" such as

"sqlplus root/root < C:/users/database.sql"

That's for compilation errors but sure sqlplus is what you need for MySQL.

Re: database initialization job

Anonymous — Mon, 17 Jun 2019 10:34:40 GMT

Thanks,

but, I have another error.

Exception in component tSystem_1 (Initialisation_DSA)
java.io.IOException: Cannot run program "sqlplus": CreateProcess error=2, Le fichier spécifié est introuvable
	at java.lang.ProcessBuilder.start(Unknown Source)
	at java.lang.Runtime.exec(Unknown Source)
	at java.lang.Runtime.exec(Unknown Source)
	at java.lang.Runtime.exec(Unknown Source)
	at local_project.initialisation_dsa_0_1.Initialisation_DSA.tSystem_1Process(Initialisation_DSA.java:353)
	at local_project.initialisation_dsa_0_1.Initialisation_DSA.runJobInTOS(Initialisation_DSA.java:707)
	at local_project.initialisation_dsa_0_1.Initialisation_DSA.main(Initialisation_DSA.java:550)
Caused by: java.io.IOException: CreateProcess error=2, Le fichier spécifié est introuvable
	at java.lang.ProcessImpl.create(Native Method)
	at java.lang.ProcessImpl.<init>(Unknown Source)
	at java.lang.ProcessImpl.start(Unknown Source)
	... 7 more

knowing that the file path is correct.

cordially,