Hi, It seems this is occurred since the DAS server does not have a valid certificate from an authorized CA. Please add DAS server certificate in to JDK keystore and check by following steps.
- Access the DAS url from browser and export the certificate - Export the certificate to JDK key store using keytool. Thanks, Anupama On Mon, Nov 21, 2016 at 1:06 AM, Pawan Gunaratne <[email protected]> wrote: > Hi, > > After creating the JDBC connection in Eclipse BIRT it didn't allow to get > the table data available in DAS. Also it didn't show any tables/streams > available in DAS. When I'm trying to retrieve the data using SELECT queries > it will throw the following exception. > > ------------------------------------------------------------ > ------------------------------------------------------------ > ---------------------------------------- > org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot get the > result set metadata. > org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement > does not return a ResultSet object. > SQL error #1:Error in Get Column Data Types : > ; > java.sql.SQLException: Error in Get Column Data Types : > at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler. > newException(ExceptionHandler.java:52) > at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler. > throwException(ExceptionHandler.java:108) > at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler. > throwException(ExceptionHandler.java:84) > at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement. > getRuntimeMetaData(PreparedStatement.java:414) > at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement. > getProjectedColumns(PreparedStatement.java:377) > at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement. > doGetMetaData(PreparedStatement.java:347) > at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement. > execute(PreparedStatement.java:563) > at org.eclipse.birt.data.engine.executor.DataSourceQuery. > execute(DataSourceQuery.java:980) > at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$ > OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:607) > at org.eclipse.birt.data.engine.impl.QueryExecutor.execute( > QueryExecutor.java:1251) > at org.eclipse.birt.data.engine.impl.ServiceForQueryResults. > executeQuery(ServiceForQueryResults.java:233) > at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator( > QueryResults.java:178) > at org.eclipse.birt.data.engine.impl.QueryResults.getResultMetaData( > QueryResults.java:132) > at org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHelper. > getRuntimeMetaData(DataSetMetaDataHelper.java:196) > at org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHelper. > getRealMetaData(DataSetMetaDataHelper.java:155) > at org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHelper. > getDataSetMetaData(DataSetMetaDataHelper.java:117) > at org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHelper. > refreshMetaData(DataSetMetaDataHelper.java:385) > at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl. > refreshMetaData(DataRequestSessionImpl.java:414) > at org.eclipse.birt.report.designer.data.ui.dataset.ExternalUIUtil. > updateColumnCache(ExternalUIUtil.java:109) > at org.eclipse.birt.report.designer.data.ui.providers. > DefaultDataServiceProvider.updateColumnCache(DefaultDataServiceProvider. > java:139) > at org.eclipse.birt.report.designer.internal.ui.data. > DataService.updateColumnCache(DataService.java:173) > at org.eclipse.birt.report.designer.data.ui.dataset.DataSetUIUtil. > updateColumnCache(DataSetUIUtil.java:99) > at org.eclipse.birt.report.designer.data.ui.dataset. > DataSetEditor.okPressed(DataSetEditor.java:687) > at org.eclipse.birt.report.designer.data.ui.property. > AbstractPropertyDialog.buttonPressed(AbstractPropertyDialog.java:650) > at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:618) > at org.eclipse.swt.widgets.TypedListener.handleEvent( > TypedListener.java:249) > at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) > at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5219) > at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1340) > at org.eclipse.swt.widgets.Display.runDeferredEvents( > Display.java:4553) > at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4143) > at org.eclipse.jface.window.Window.runEventLoop(Window.java:818) > at org.eclipse.jface.window.Window.open(Window.java:794) > at org.eclipse.birt.report.designer.ui.dialogs. > BaseDialog.open(BaseDialog.java:117) > at org.eclipse.birt.report.designer.data.ui.providers. > EditableDataSetNodeProvider.performEdit(EditableDataSetNodeProvider. > java:102) > at org.eclipse.birt.report.designer.internal.ui.views. > DefaultNodeProvider.performRequest(DefaultNodeProvider.java:472) > at org.eclipse.birt.report.designer.internal.ui.views. > actions.EditAction.doAction(EditAction.java:85) > at org.eclipse.birt.report.designer.internal.ui.views. > actions.AbstractElementAction.run(AbstractElementAction.java:70) > at org.eclipse.birt.report.designer.internal.ui.views. > RenameListener.doubleClick(RenameListener.java:214) > at org.eclipse.jface.viewers.StructuredViewer$1.run( > StructuredViewer.java:833) > at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42) > at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:50) > at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:173) > at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick( > StructuredViewer.java:830) > at org.eclipse.jface.viewers.AbstractTreeViewer.handleDoubleSelect( > AbstractTreeViewer.java:1470) > at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected( > StructuredViewer.java:1264) > at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent( > OpenStrategy.java:252) > at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:249) > at org.eclipse.jface.util.OpenStrategy$1.handleEvent( > OpenStrategy.java:311) > > at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) > at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5219) > at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1340) > at org.eclipse.swt.widgets.Display.runDeferredEvents( > Display.java:4553) > at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4143) > at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$4.run( > PartRenderingEngine.java:1121) > at org.eclipse.core.databinding.observable.Realm. > runWithDefault(Realm.java:336) > at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run( > PartRenderingEngine.java:1022) > at org.eclipse.e4.ui.internal.workbench.E4Workbench. > createAndRunUI(E4Workbench.java:150) > at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:687) > at org.eclipse.core.databinding.observable.Realm. > runWithDefault(Realm.java:336) > at org.eclipse.ui.internal.Workbench.createAndRunWorkbench( > Workbench.java:604) > at org.eclipse.ui.PlatformUI.createAndRunWorkbench( > PlatformUI.java:148) > at org.eclipse.ui.internal.ide.application.IDEApplication. > start(IDEApplication.java:138) > 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:388) > at org.eclipse.core.runtime.adaptor.EclipseStarter.run( > EclipseStarter.java:243) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:62) > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:673) > at org.eclipse.equinox.launcher.Main.basicRun(Main.java:610) > at org.eclipse.equinox.launcher.Main.run(Main.java:1519) > at org.eclipse.equinox.launcher.Main.main(Main.java:1492) > Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL > statement does not return a ResultSet object. > SQL error #1:Error in Get Column Data Types : > ; > java.sql.SQLException: Error in Get Column Data Types : > at org.eclipse.birt.report.data.oda.jdbc.Statement. > executeQuery(Statement.java:482) > at org.eclipse.birt.report.data.oda.jdbc.Statement. > getMetaUsingDefaultPolicy(Statement.java:389) > at org.eclipse.birt.report.data.oda.jdbc.Statement. > getMetaData(Statement.java:330) > at org.eclipse.birt.report.data.oda.jdbc.bidi.BidiStatement. > getMetaData(BidiStatement.java:56) > at org.eclipse.datatools.connectivity.oda.consumer. > helper.OdaQuery.doGetMetaData(OdaQuery.java:423) > at org.eclipse.datatools.connectivity.oda.consumer. > helper.OdaQuery.getMetaData(OdaQuery.java:390) > at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement. > getRuntimeMetaData(PreparedStatement.java:407) > ... 72 more > Caused by: java.sql.SQLException: Error in Get Column Data Types : > at org.wso2.das.jdbcdriver.jdbc.DASJConnection.getColumnDataTypes( > DASJConnection.java:498) > at org.wso2.das.jdbcdriver.jdbc.DASJStatement.executeDASQuery( > DASJStatement.java:344) > at org.wso2.das.jdbcdriver.jdbc.DASJPreparedStatement.executeQuery( > DASJPreparedStatement.java:80) > at org.eclipse.birt.report.data.oda.jdbc.Statement. > executeQuery(Statement.java:478) > ... 78 more > Caused by: javax.net.ssl.SSLHandshakeException: > sun.security.validator.ValidatorException: > PKIX path building failed: > sun.security.provider.certpath.SunCertPathBuilderException: > unable to find valid certification path to requested target > at sun.security.ssl.Alerts.getSSLException(Alerts.java:192) > at sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1949) > at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:302) > at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:296) > at sun.security.ssl.ClientHandshaker.serverCertificate( > ClientHandshaker.java:1509) > at sun.security.ssl.ClientHandshaker.processMessage( > ClientHandshaker.java:216) > at sun.security.ssl.Handshaker.processLoop(Handshaker.java:979) > at sun.security.ssl.Handshaker.process_record(Handshaker.java:914) > at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:1062) > at sun.security.ssl.SSLSocketImpl.performInitialHandshake( > SSLSocketImpl.java:1375) > at sun.security.ssl.SSLSocketImpl.startHandshake( > SSLSocketImpl.java:1403) > at sun.security.ssl.SSLSocketImpl.startHandshake( > SSLSocketImpl.java:1387) > at sun.net.www.protocol.https.HttpsClient.afterConnect( > HttpsClient.java:559) > at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnec > tion.connect(AbstractDelegateHttpsURLConnection.java:185) > at sun.net.www.protocol.http.HttpURLConnection.getInputStream0( > HttpURLConnection.java:1546) > at sun.net.www.protocol.http.HttpURLConnection.getInputStream( > HttpURLConnection.java:1474) > at sun.net.www.protocol.https.HttpsURLConnectionImpl.getInputStream( > HttpsURLConnectionImpl.java:254) > at org.wso2.das.jdbcdriver.dasInterface.DASServiceConnector.sendGet( > DASServiceConnector.java:48) > at org.wso2.das.jdbcdriver.jdbc.DASJConnection.getColumnDataTypes( > DASJConnection.java:494) > ... 81 more > Caused by: sun.security.validator.ValidatorException: PKIX path building > failed: sun.security.provider.certpath.SunCertPathBuilderException: > unable to find valid certification path to requested target > at sun.security.validator.PKIXValidator.doBuild( > PKIXValidator.java:387) > at sun.security.validator.PKIXValidator.engineValidate( > PKIXValidator.java:292) > at sun.security.validator.Validator.validate(Validator.java:260) > at sun.security.ssl.X509TrustManagerImpl.validate( > X509TrustManagerImpl.java:324) > at sun.security.ssl.X509TrustManagerImpl.checkTrusted( > X509TrustManagerImpl.java:229) > at sun.security.ssl.X509TrustManagerImpl.checkServerTrusted( > X509TrustManagerImpl.java:124) > at sun.security.ssl.ClientHandshaker.serverCertificate( > ClientHandshaker.java:1491) > ... 95 more > Caused by: sun.security.provider.certpath.SunCertPathBuilderException: > unable to find valid certification path to requested target > at sun.security.provider.certpath.SunCertPathBuilder. > build(SunCertPathBuilder.java:141) > at sun.security.provider.certpath.SunCertPathBuilder.engineBuild( > SunCertPathBuilder.java:126) > at java.security.cert.CertPathBuilder.build(CertPathBuilder.java:280) > at sun.security.validator.PKIXValidator.doBuild( > PKIXValidator.java:382) > ... 101 more > > ------------------------------------------------------------ > ------------------------------------------------------------ > -------------------------------------- > > Here I have attached a screenshot of basic error message also. So any kind > of help would be appreciated. > > Thanks, > Pawan > > > On Tue, Nov 15, 2016 at 11:32 AM, Pawan Gunaratne <[email protected]> wrote: > >> Hi, >> >> That exception issue is settled. It's a problem of missing some part of >> the database URL property. >> It should be >>>> *jdbc:dasjdriver:* >> >> *https://localhost:9443/analytics/ >> <https://www.google.com/url?q=https%3A%2F%2Flocalhost%3A9443%2Fanalytics%2F&sa=D&sntz=1&usg=AFQjCNFhjYINkte5BaQp05Fe1Ly8PgPVaQ>* >> Thanks, >> Pawan >> >> On Wed, Nov 9, 2016 at 12:06 PM, Pawan Gunaratne <[email protected]> wrote: >> >>> Hi, >>> >>> I'm working on DAS report generation stuff. So I have tried to connect >>> eclipse BIRT reporting tool with WSO2 DAS using DAS JDBC driver. but >>> I'm getting an exception after giving the connection properties.That >>> exception is related to connection properties. >>> >>> ------------------------------------------------------------ >>> ------------------------------------------ >>> org.eclipse.datatools.connectivity.oda.OdaException: Failed to create a >>> connection. Please verify the connection properties. >>> at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelecti >>> onPageHelper$TestInProcessDialog$TestConnectionJob$1.run(JDB >>> CSelectionPageHelper.java:218) >>> at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35) >>> at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchr >>> onizer.java:182) >>> at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.jav >>> a:4528) >>> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java >>> :4146) >>> at org.eclipse.jface.window.Window.runEventLoop(Window.java:818) >>> at org.eclipse.jface.window.Window.open(Window.java:794) >>> at org.eclipse.jface.dialogs.MessageDialog.open(MessageDialog.j >>> ava:396) >>> at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelecti >>> onPageHelper$8.widgetSelected(JDBCSelectionPageHelper.java:1036) >>> at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListe >>> ner.java:249) >>> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) >>> at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5219) >>> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1340) >>> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.ja >>> va:4553) >>> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java >>> :4143) >>> at org.eclipse.jface.window.Window.runEventLoop(Window.java:818) >>> at org.eclipse.jface.window.Window.open(Window.java:794) >>> at org.eclipse.birt.report.designer.data.ui.actions.NewDataSour >>> ceAction.run(NewDataSourceAction.java:127) >>> at org.eclipse.jface.action.Action.runWithEvent(Action.java:473) >>> at org.eclipse.jface.action.ActionContributionItem.handleWidget >>> Selection(ActionContributionItem.java:565) >>> at org.eclipse.jface.action.ActionContributionItem.lambda$4(Act >>> ionContributionItem.java:397) >>> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) >>> at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5219) >>> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1340) >>> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.ja >>> va:4553) >>> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java >>> :4143) >>> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine >>> $4.run(PartRenderingEngine.java:1121) >>> at org.eclipse.core.databinding.observable.Realm.runWithDefault >>> (Realm.java:336) >>> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine >>> .run(PartRenderingEngine.java:1022) >>> at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRu >>> nUI(E4Workbench.java:150) >>> at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:687) >>> at org.eclipse.core.databinding.observable.Realm.runWithDefault >>> (Realm.java:336) >>> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Work >>> bench.java:604) >>> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.j >>> ava:148) >>> at org.eclipse.ui.internal.ide.application.IDEApplication.start >>> (IDEApplication.java:138) >>> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(Eclips >>> eAppHandle.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(EclipseS >>> tarter.java:388) >>> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS >>> tarter.java:243) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce >>> ssorImpl.java:62) >>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe >>> thodAccessorImpl.java:43) >>> at java.lang.reflect.Method.invoke(Method.java:498) >>> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:673) >>> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:610) >>> at org.eclipse.equinox.launcher.Main.run(Main.java:1519) >>> at org.eclipse.equinox.launcher.Main.main(Main.java:1492) >>> >>> ------------------------------------------------------------ >>> -------------------------------------- >>> >>> Here I have attached a screenshot of connection properties also*. *So >>> need any kind of help to fix this issue. >>> >>> Thanks, >>> Pawan >>> >>> >>> -- >>> *Pawan Gunaratne* >>> Software Engineering Intern >>> *WSO2* >>> *Mob : 0770373556* >>> >> >> >> >> -- >> *Pawan Gunaratne* >> Software Engineering Intern >> *WSO2* >> *Mob : 0770373556* >> > > > > -- > *Pawan Gunaratne* > Software Engineering Intern > *WSO2* > *Mob : 0770373556* > -- Anupama Pathirage Associate Technical Lead WSO2, Inc. http://wso2.com/ Email: [email protected] Mobile:+94 71 8273 979
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
