Database explorer will not execute statements since upgrade

MyEclipse Forum Index » MyEclipse IDE » Database Tools (DB Explorer, Hibernate, etc.)

Author

Message

gregmajor

Post subject: Database explorer will not execute statements since upgrade

Posted: Feb 07, 2006 - 08:26 PM

Registered Member

Joined: Feb 07, 2006
Posts: 2

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

Post subject:

Posted: Feb 07, 2006 - 09:11 PM

Moderator

Joined: Jan 06, 2004
Posts: 23310

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?

_________________
Riyad
MyEclipse Support