Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Connect to DB2 Database with SSL in url
milanrawat
<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
Clement Wong
<p><a data-ipb='nomediaparse' href='
http://www.ibm.com/developerworks/data/library/techarticle/dm-0806sogalad/'>http://www.ibm.com/developerworks/data/library/techarticle/dm-0806sogalad/</a></p>
;
<p> </p>
<p>You follow all these steps, specifically Step 6 of importing the SSL certificate for the client (JDBC) machine?</p>
<p> </p>
<p>Or these steps for Client Side, depending on your DB2 server version?</p>
<p><a data-ipb='nomediaparse' href='
http://www.ibm.com/developerworks/data/library/techarticle/dm-1306securesocketlayers/'>http://www.ibm.com/developerworks/data/library/techarticle/dm-1306securesocketlayers/</a></p>
;