Eclipse Community Forums: BIRT

Home » Archived » BIRT » Data Set error(Whenever I try to preview the result for my data set, I get the error stating that SQL statement doesn't return a ResultSet Object)

Show: Today's Messages :: Show Polls :: Message Navigator

Data Set error [message #1720572]

Tue, 19 January 2016 12:30

Siddhanr Maharana

Messages: 1
Registered: January 2016

Junior Member

Every query from my public schema accessing my postgreSQL Amazon redshift DB throws me the following error each time I try to preview the result.

org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot execute the statement.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:[Amazon][JDBC](10460) Invalid fetch size: 10000. Valid size range: 0 to 500.0.
;

Thanks in advance

Report message to a moderator

Re: Data Set error [message #1747366 is a reply to message #1720572]

Mon, 14 November 2016 01:35

Alex Whiteley

Messages: 1
Registered: November 2016

Junior Member

Hi,

I have just installed Eclipse for use in BIRT reporting on a Redshift database. I don't have any programming experience and have not made any changes to configuration in the installation.

I get the same error as above: if someone could advise how to diagnose and fix the error I would appreciate it.

Steps taken:

== INSTALLATION ==
* Operating System: Microsoft Windows 10
* Install Eclipse IDE for Java and Report Developers -- Version: Neon Release (4.6.0) -- Build id: 20160613-1800
* Download Redshift SSL CA and import it into the 'cacerts' truststore
* Download Redshift driver from Amazon (class: com.amazon.redshift.jdbc42.Driver)
* Set perspective in Eclipse to Report Design by Window > Perspective > Open Perspective > Report Design
* Create a project and a report

== DATA SET ==
* Create Data Source for Redshift database, using driver installed above
* Click [Test Connection] button to confirm successful connection to Redshift Data Source
* Create Data Set with source set to the Data Source created above
* Define a SQL query of the Redshift data source
* Click [Preview Results]

On previewing the results, an error is generated:

org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot execute the statement.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:[Amazon][JDBC](10460) Invalid fetch size: 10000. Valid size range: 0 to 500.0.
;
java.sql.SQLException: [Amazon][JDBC](10460) Invalid fetch size: 10000. Valid size range: 0 to 500.0.
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:52)
... etc.

However, this appears to affect previewing only:

== WORKAROUND ==
* Drag a Table item from the Palette to the Layout designer
* In the Insert Table window, set the Data Set to the data set created above
* For binding columns, select all
* Click [OK]
* Confirm a table is created in the report, with labels and data corresponding to the Data Set
* Generate the report by Run > View Report > In Web Browser

No errors are generated and the data appears to display correctly.

Obviously this is not a great workaround as it is time-consuming and clunky. Would appreciate if someone could help me get to the bottom of this.

Hopefully I have given enough details to go on; please let me know if you need more details or clarification.

Thanks,
Alex

Report message to a moderator

Re: Data Set error [message #1749799 is a reply to message #1747366]

Mon, 12 December 2016 13:59

Sarang Manjrekar

Messages: 1
Registered: December 2016

Junior Member

Hi Alex,

While creating the data set with redshift driver RedshiftJDBC42-1.2.1.1001.jar, I get the error as :

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.JDBCSelectionPageHelper$TestInProcessDialog$TestConnectionJob$1.run(JDBCSelectionPageHelper.java:218)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:182)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4024)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3700)
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.java:396)
at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper$8.widgetSelected(JDBCSelectionPageHelper.java:1036)
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:4248)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1501)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1524)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1509)
at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1313)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4072)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3698)
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.NewDataSourceAction.run(NewDataSourceAction.java:127)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:473)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:565)
at org.eclipse.jface.action.ActionContributionItem.lambda$4(ActionContributionItem.java:397)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4248)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1501)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1524)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1509)
at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1313)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4072)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3698)
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)

Any idea, what could be the cause ?

Report message to a moderator

Previous Topic:	Color Coding in Cross Tab
Next Topic:	Page break

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 06:52:20 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter