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/