Home
Designing Analytics Reports
Connect to DB2 Database with SSL in url
Migrateduser
<p>HI,</p>
<p>I am trying to connect BIRT (v4.3) to DB2 database. The url looks like:</p>
<p> </p>
<p>jdbc:db2://<SomeServer>/LRDUIMT4:sslConnection=true;</p>
<p> </p>
<p>When I do test Connection in Edit DataSource, I get the following error:</p>
<p> </p>
<div>org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, [jcc][t4][2030][11211][3.53.70] A communication error occurred during operations on the connection's underlying socket, socket input stream, </div>
<div>or socket output stream. Error location: T4Agent.sendRequest(). Message: sun.security.validator.ValidatorException: PKIX path building failed: sun.security. ....</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:304)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:206)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.tryCreateConnection(JDBCDriverManager.java:792)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:713)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:609)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:581)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:649)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:147)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:175)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper.testConnection(JDBCSelectionPageHelper.java:961)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper.access$11(JDBCSelectionPageHelper.java:929)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper$8.widgetSelected(JDBCSelectionPageHelper.java:852)</div>
<div>at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)</div>
<div>at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)</div>
<div>at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1057)</div>
<div>at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4170)</div>
<div>at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3759)</div>
<div>at org.eclipse.jface.window.Window.runEventLoop(Window.java:826)</div>
<div>at org.eclipse.jface.window.Window.open(Window.java:802)</div>
<div>at org.eclipse.birt.report.designer.ui.dialogs.BaseDialog.open(BaseDialog.java:111)</div>
<div>at org.eclipse.birt.report.designer.data.ui.providers.EditableDataSourceNodeProvider.performEdit(EditableDataSourceNodeProvider.java:73)</div>
<div>at org.eclipse.birt.report.designer.internal.ui.views.DefaultNodeProvider.performRequest(DefaultNodeProvider.java:472)</div>
<div>at org.eclipse.birt.report.designer.internal.ui.views.actions.EditAction.doAction(EditAction.java:85)</div>
<div>at org.eclipse.birt.report.designer.internal.ui.views.actions.AbstractElementAction.run(AbstractElementAction.java:70)</div>
<div>at org.eclipse.birt.report.designer.internal.ui.views.RenameListener.doubleClick(RenameListener.java:214)</div>
<div>at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:845)</div>
<div>at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)</div>
<div>at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:49)</div>
<div>at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:175)</div>
<div>at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:843)</div>
<div>at org.eclipse.jface.viewers.AbstractTreeViewer.handleDoubleSelect(AbstractTreeViewer.java:1477)</div>
<div>at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1246)</div>
<div>at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:249)</div>
<div>at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:246)</div>
<div>at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:307)</div>
<div>at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)</div>
<div>at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1057)</div>
<div>at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4170)</div>
<div>at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3759)</div>
<div>at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1113)</div>
<div>at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)</div>
<div>at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:997)</div>
<div>at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:138)</div>
<div>at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:610)</div>
<div>at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)</div>
<div>at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:567)</div>
<div>at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)</div>
<div>at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)</div>
<div>at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)</div>
<div>at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)</div>
<div>at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)</div>
<div>at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:354)</div>
<div>at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:181)</div>
<div>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</div>
<div>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</div>
<div>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</div>
<div>at java.lang.reflect.Method.invoke(Method.java:597)</div>
<div>at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:636)</div>
<div>at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)</div>
<div>at org.eclipse.equinox.launcher.Main.run(Main.java:1450)</div>
<div>at org.eclipse.equinox.launcher.Main.main(Main.java:1426)</div>
<div> </div>
<div>Please tell me where am I wrong. It used to work fine wihout SSL.</div>
Find more posts tagged with
Comments
There are no comments yet