[resolved] Database connection from context

peterko — Mon, 01 Sep 2014 09:22:30 GMT

Hey.
It is possible from the context, that was loaded with component tContextLoad create a DB connection in the metadata? If yes, how?
We need to have context loaded from an external file. I use context for tPostgresqlnput. But then when I want to save the connection to the repository, and in the "New Database Connection on repository (Step 2.2)" applies the check, I get an error:

Connection failure. You must change the Database Settings.
  java.lang.Exception: Impossible to initialize the connection !
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1089)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:301)
      at org.talend.repository.ui.utils.ManagerConnection.check(ManagerConnection.java:261)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm.checkConnection(DatabaseForm.java:2096)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm.access$41(DatabaseForm.java:2021)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$24.widgetSelected(DatabaseForm.java:2349)
      at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:234)
      at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1258)
      at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3540)
      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3161)
      at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
      at org.eclipse.jface.window.Window.open(Window.java:801)
      at org.talend.repository.metadata.MetadataService.openMetadataConnection(MetadataService.java:240)
      at org.talend.designer.core.ui.editor.properties.controllers.PropertyTypeController.createButtonCommand(PropertyTypeController.java:539)
      at org.talend.designer.core.ui.editor.properties.controllers.AbstractRepositoryController.createCommand(AbstractRepositoryController.java:295)
      at org.talend.designer.core.ui.editor.properties.controllers.AbstractRepositoryController.access$0(AbstractRepositoryController.java:293)
      at org.talend.designer.core.ui.editor.properties.controllers.AbstractRepositoryController$1.widgetSelected(AbstractRepositoryController.java:256)
      at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:234)
      at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1258)
      at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3540)
      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3161)
      at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2640)
      at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2604)
      at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2438)
      at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:671)
      at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
      at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:664)
      at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
      at org.talend.rcp.intro.Application.start(Application.java:159)
      at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
      at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
      at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369)
      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:606)
      at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:619)
      at org.eclipse.equinox.launcher.Main.basicRun(Main.java:574)
      at org.eclipse.equinox.launcher.Main.run(Main.java:1407)

Re: [resolved] Database connection from context

Anonymous — Mon, 01 Sep 2014 11:03:25 GMT

Hi pantolik,
Talend does not have that feature to create metadata connection using context variable.For more please go through it.
https://community.talend.com/t5/Design-and-Development/Creating-a-Metadata-Db-Connection-using-existing-Context/td-p/112725

Re: [resolved] Database connection from context

peterko — Mon, 01 Sep 2014 11:39:13 GMT

Thanks

topic Re: [resolved] Database connection from context in Talend Studio

[resolved] Database connection from context

Re: [resolved] Database connection from context

Re: [resolved] Database connection from context