[Greg Major]

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

[Riyad Kalla]

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?

[Greg Major]

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

[Haris Peco]

Please, see https://www.genuitec.com/forums/topic/db-explorer-and-sql-editor-bugs/#post-246294
it is same bug and will be fixing this in the 4.1.1 release (late Februar)

Thanks

[Author]

Posts