SQL Results pane cannot fetch results beyond first 100

MyEclipse Archived

Bugs

This topic has 1 reply, 2 voices, and was last updated 18 years, 3 months ago by Brian Fernandes.

Viewing 2 posts - 1 through 2 (of 2 total)

Author

Posts

August 8, 2006 at 1:30 pm #256355 Reply

Erling Molde

Member

– System Setup ——————————-
Fresh Eclipse install (y/n): yes
MyEclipse was installed as a manual installation (add extension location)
Eclipse was started with the -clean option afterwards

If this is a DB related question please answer the following:

RDBMS vendor and version:
test 1: MySQL 4.1.12a
test 2: Microsoft SQL Server 08.00.0760

JDBC driver vendor and version, and access type (thin, type-2, etc):
test 1: MySQL AB, v 3.1.12, type 4
test 2: jTDS Type 4 JDBC Driver for MS SQL Server and Sybase, v 1.2

Connection URL:
test 1: jdbc:mysql://localhost/ltkkommuner
test 2: jdbc:jtds:sqlserver://localhost/adresse

– Message Body ——————————-

I’m having problems when trying to fetch results from an sql query (in the sql editor). When the table has more than 100 rows, it fetches the first 100, but when I try to fetch the next 100 with the “Retrieve more rows” button, nothing happens, and the error listed below occurs in the log.
I’ve also tried using the “Retrieve all rows” button, this shows a dialog box with a cancel-button and som text, and never returns. When I hit the cancel-button, the operation is interrupted, and another error is reported in the log (also shown below).

I’ve also tried the same against both a MySQL database and an MS SQL Server database, with the same results.


*** Date: Tue Aug 08 19:46:57 CEST 2006

*** System properties:
OS=WindowsXP
OS version=5.1
Java version=1.5.0_07

*** MyEclipse details:
MyEclipse Enterprise Workbench

Version: 5.0 GA
Build id: 20060805-5.0-GA

*** Eclipse details:
Eclipse SDK

Version: 3.2.0
Build id: M20060629-1905

Eclipse Graphical Editing Framework

Version: 3.2.0.v20060626
Build id: 20060627-0816

Eclipse Platform

Version: 3.2.0.v20060609m-AgOexn6hlEUsvBO
Build id: M20060629-1905

Eclipse RCP

Version: 3.2.0.v20060609m-SVDNgVrNoh-MeGG
Build id: M20060629-1905

Eclipse Java Development Tools

Version: 3.2.0.v20060609m-F7snq1fxia-Z4XP
Build id: M20060629-1905

Eclipse Plug-in Development Environment

Version: 3.2.0.v20060609m------6zXJJzJzJq
Build id: M20060629-1905

Eclipse Project SDK

Version: 3.2.0.v20060609m-GNq6oQq-7es-Y81
Build id: M20060629-1905

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-launcher
C:\eclipse-SDK-3.2-win32\eclipse\eclipse.exe
-name
Eclipse
-showsplash
600
-exitdata
13ec_4c
-vm
C:\WINDOWS\system32\javaw.exe


!SESSION 2006-08-08 12:17:11.238 -----------------------------------------------
eclipse.buildId=M20060629-1905
java.version=1.5.0_07
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=no_NO
Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-08-08 13:32:14.269
!MESSAGE Error Retrieving all rows 
!STACK 0
java.lang.InterruptedException
    at com.genuitec.eclipse.sqlexplorer.actions.RetrieveAllProgress.run(RetrieveAllProgress.java:39)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)

!SESSION 2006-08-08 14:08:31.473 -----------------------------------------------
eclipse.buildId=M20060629-1905
java.version=1.5.0_07
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=no_NO
Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-08-08 14:10:29.035
!MESSAGE Error calling MoreRows Action 
!STACK 0
java.sql.SQLException: Operation not allowed after ResultSet closed
    at com.mysql.jdbc.ResultSet.checkClosed(ResultSet.java:639)
    at com.mysql.jdbc.ResultSet.next(ResultSet.java:6116)
    at net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.readRow(ResultSetReader.java:54)
    at com.genuitec.eclipse.sqlexplorer.views.SqlTableModel.fetchRows(SqlTableModel.java:99)
    at com.genuitec.eclipse.sqlexplorer.views.SqlTableModel.moreRows(SqlTableModel.java:73)
    at com.genuitec.eclipse.sqlexplorer.actions.MoreRowsAction$1.run(MoreRowsAction.java:52)
    at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)
    at com.genuitec.eclipse.sqlexplorer.actions.MoreRowsAction.run(MoreRowsAction.java:49)
    at org.eclipse.jface.action.Action.runWithEvent(Action.java:499)
    at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:539)
    at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:488)
    at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:441)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968)
    at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1914)
    at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1878)
    at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:419)
    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
    at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:95)
    at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:78)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:92)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:68)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:400)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:177)
    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.core.launcher.Main.invokeFramework(Main.java:336)
    at org.eclipse.core.launcher.Main.basicRun(Main.java:280)
    at org.eclipse.core.launcher.Main.run(Main.java:977)
    at org.eclipse.core.launcher.Main.main(Main.java:952)

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-08-08 14:14:06.113
!MESSAGE Error calling MoreRows Action 
!STACK 0
java.sql.SQLException: Invalid state, the ResultSet object is closed.
    at net.sourceforge.jtds.jdbc.JtdsResultSet.checkOpen(JtdsResultSet.java:299)
    at net.sourceforge.jtds.jdbc.JtdsResultSet.next(JtdsResultSet.java:569)
    at net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.readRow(ResultSetReader.java:54)
    at com.genuitec.eclipse.sqlexplorer.views.SqlTableModel.fetchRows(SqlTableModel.java:99)
    at com.genuitec.eclipse.sqlexplorer.views.SqlTableModel.moreRows(SqlTableModel.java:73)
    at com.genuitec.eclipse.sqlexplorer.actions.MoreRowsAction$1.run(MoreRowsAction.java:52)
    at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)
    at com.genuitec.eclipse.sqlexplorer.actions.MoreRowsAction.run(MoreRowsAction.java:49)
    at org.eclipse.jface.action.Action.runWithEvent(Action.java:499)
    at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:539)
    at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:488)
    at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:441)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968)
    at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1914)
    at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1878)
    at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:419)
    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
    at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:95)
    at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:78)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:92)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:68)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:400)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:177)
    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.core.launcher.Main.invokeFramework(Main.java:336)
    at org.eclipse.core.launcher.Main.basicRun(Main.java:280)
    at org.eclipse.core.launcher.Main.run(Main.java:977)
    at org.eclipse.core.launcher.Main.main(Main.java:952)

August 9, 2006 at 2:02 pm #256466 Reply

Brian Fernandes

Moderator

Hi,

This is an unfortunate regression in the SQL Results view caused by the addition of some other enhanced features.
Neither of the retrieve buttons are currently functionl

We are evaluating how this issue can be best resolved right now, unfortunately there is no workaround until then.

We regret the inconvenience caused,
Brian.

Author

Posts

Viewing 2 posts - 1 through 2 (of 2 total)