MyEclipse :: View topic - Database explorer will not execute statements since upgrade

MyEclipse: Database explorer will not execute statements since upgrade

gregmajor - Feb 07, 2006 - 08:26 PM
Post subject: Database explorer will not execute statements since upgrade

I get an error of "This statement is already closed" when I try to execute a simple statement against an open connection in the database explorer. Something simple like 'select * from users'. The same queries work fine from within my own applications.

This work fine until I updated to the latest version of myeclipse using the update manager.

I am using firebird 1.5.1 at it worked fine until the update and I make a connection okay.

My log is as follows:

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-02-07 15:09:43.187
!MESSAGE Error processing query: 'select * from users'
!STACK 0
org.firebirdsql.jdbc.FBSQLException: This statement is already closed.
at org.firebirdsql.jdbc.AbstractStatement.close(AbstractStatement.java:218)
at com.genuitec.eclipse.sqlexplorer.views.SqlTableModel.fetchRows(SqlTableModel.java:119)
at com.genuitec.eclipse.sqlexplorer.views.SqlTableModel.<init>(SqlTableModel.java:70)
at com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.processQuery(SqlExecProgress.java:214)
at com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.run(SqlExecProgress.java:161)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-02-07 15:09:43.187
!MESSAGE Could not close statement
!STACK 0
org.firebirdsql.jdbc.FBSQLException: This statement is already closed.
at org.firebirdsql.jdbc.AbstractStatement.close(AbstractStatement.java:218)
at com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress$LocalThread.endMonitor(SqlExecProgress.java:85)
at com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress$LocalThread.endMonitor(SqlExecProgress.java:78)
at com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.processQuery(SqlExecProgress.java:245)
at com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.run(SqlExecProgress.java:161)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)

My environment is:

*** Date: Tue Feb 07 15:13:08 EST 2006

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

*** MyEclipse details:
MyEclipse Enterprise Workbench

Version: 4.1.0 GA
Build id: 20060122-4.1-GA

*** Eclipse details:
Eclipse SDK

Version: 3.1.1
Build id: M20050929-0840

Eclipse Project SDK

Version: 3.1.1
Build id: M20050929-0840

Eclipse Platform

Version: 3.1.1
Build id: M20050929-0840

Eclipse Java Development Tools

Version: 3.1.1
Build id: M20050929-0840

Eclipse Graphical Editing Framework

Version: 3.1
Build id: 200509301327

Eclipse RCP

Version: 3.1.1
Build id: M20050929-0840

Eclipse Plug-in Development Environment

Version: 3.1.1
Build id: M20050929-0840

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-launcher
C:\bin\eclipse3.1.1\eclipse.exe
-name
Eclipse
-showsplash
600
-exitdata
cfc_38
-vm
C:\WINDOWS\system32\javaw.exe

support-rkalla - Feb 07, 2006 - 09:11 PM
Post subject:

Can you explain what version you upgraded from, and how you performed the upgrade? Did you just unzip a new version of MyEclipse ontop of the old one, or did you uninstall/reinstall or did you use the udpate manager?

gregmajor - Feb 08, 2006 - 01:07 PM
Post subject:

I upgraded from version 4.0.3 and did it with the ugrade manager.

support-snpe - Feb 08, 2006 - 01:30 PM
Post subject:

Please, see http://myeclipseide.com/index.php?name=PNphpBB2&file=viewtopic&p=52333#52333
it is same bug and will be fixing this in the 4.1.1 release (late Februar)

Thanks