Hello,
Is it possible to use variables in the Database URL: and DAtabase User: fields in the JDBC Override Connection piece in SQLQry Node?
The connection string below works when used in the SQLQRY Node, but I am trying to use a variable inside the node:
My variable called ScottWorksUrl is: "jdbc:sqlserver://SQL.SCW.PRD.co.scott.mn.us;databaseName=ScottWorks"
This is the error:
java.sql.SQLException Mar 23, 2015 2:40:26 PM CDT Plug-in Vendor: Infor Plug-in Name: Infor Process Designer Plug-in ID: com.lawson.bpm.designer Product Version: 10.0.3.v201402261818 Exception detected in Class: com.lawson.bpm.designer.wizards.SQLQueryBuilderPage Error message: Unable to load table types. Cannot access data necessary for requested node type. Exception detail: java.sql.SQLException: No suitable driver found for at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.lawson.bpm.designer.wizards.SQLQueryBuilderPage.getJDBCConnection(Unknown Source) at com.lawson.bpm.designer.wizards.SQLQueryBuilderPage.loadTableTypes(Unknown Source) at com.lawson.bpm.designer.wizards.SQLQueryBuilderPage.createPageContent(Unknown Source) at com.lawson.bpm.designer.wizards.SQLQueryBuilderPage.createControl(Unknown Source) at org.eclipse.jface.wizard.Wizard.createPageControls(Wizard.java:170) at org.eclipse.jface.wizard.WizardDialog.createPageControls(WizardDialog.java:669) at org.eclipse.jface.wizard.WizardDialog.createContents(WizardDialog.java:543) at org.eclipse.jface.window.Window.create(Window.java:431) at org.eclipse.jface.dialogs.Dialog.create(Dialog.java:1089) at org.eclipse.jface.window.Window.open(Window.java:790) at com.lawson.bpm.designer.editor.properties.panels.SQLBuilderPanel.handleCreateButton(Unknown Source) at com.lawson.bpm.designer.editor.properties.panels.GetOrCreatePanel$1.widgetSelected(Unknown Source) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:228) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3823) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3422) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2384) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2348) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2200) at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:495) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:288) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:490) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at com.lawson.bpm.designer.Application.start(Unknown Source) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193) 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:386) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179) 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:549) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504) at org.eclipse.equinox.launcher.Main.run(Main.java:1236) at org.eclipse.equinox.launcher.Main.main(Main.java:1212)
Hi Wanda,
John is correct (as usual). You should use configuration sets, but you can reference them as variables. We do this so we can use different dbusers within the flow, but use a standard db driver and url. See attached.