Consultor Eletrônico



Kbase P113206: GUI SQL Explorer unavailable in OpenEdge 10.1X
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   28/11/2007
Status: Verified

FACT(s) (Environment):

Windows
OpenEdge 10.1x

SYMPTOM(s):

SQL Explorer unavailable in OpenEdge

Can't see icon for SQL Explorer under OpenEdge Programs menu

Starting and executing it manually leads to an error java.lang.NoClassDefFoundError

java stacktrace reads:

java.lang.NoClassDefFoundError
at sun/rmi/server/RemoteProxy.getSkeleton
at sun/rmi/server/UnicastServerRef.setSkeleton
at sun/rmi/server/UnicastServerRef.exportObject

SQL Explorer is not available

Unable to find GUI SQL Explorer

CAUSE:

This is an expected behavior - GUI SQL Explorer has been dropped in 10.1A as per Release notes RN#: 101A-00345.
" The GUI mode of SQLExplorer is not delivered due to JDBC3 specification changes. You can use the IDE DBNavigator or other GUI tools that conform to the JDBC3 specification in the JDBC type 4 driver."

FIX:

You can either use:
- TTY / CHUI version (sqlexp.bat)

For example:
sqlexp sports -S 9999 -H myHostName -user myUser -password myPassword

or

- the new DB Navigator which is available in the OpenEdge Architect IDE.

Another possibility is to use DbVisualiser available at http://www.minq.se/products/dbvis/