Connect OpenEdge 10.1B with SQL Explorer Tool

[andre060508]

I want to connect OpenEdge 10.1B with the SQL Explorer Tool.
So I use the following link:

C:\PROGRESS\OpenEdge10.1B\bin\jvmStartw.exe -f "C:\PROGRESS\OpenEdge10.1B\sqlexp.prm"

Connection URL:
jdbc:datadirectpenedge://localhost:15102;databaseName=pavar

I can see the GUI, but when I try to connect I get this Error:

java.lang.NoClassDefFoundError
at sun/rmi/server/RemoteProxy.getSkeleton
at sun/rmi/server/UnicastServerRef.setSkeleton
at sun/rmi/server/UnicastServerRef.exportObject
at java/rmi/server/UnicastRemoteObject.exportObject
at java/rmi/server/UnicastRemoteObject.<init>
at com/progress/common/networkevents/EventBroker.<init>
at com/progress/vj/explorer/ProgressExplorer.getClientEventBroker
at com/progress/vj/util/ProDialog.<clinit>
at com/progress/vj/util/ProDialog.getActiveProDlg
at com/progress/vj/util/ProMsgBox.show
at com/progress/vj/util/ProMsgBox.error
at com/progress/vj/util/ProMsgBox.error
at com/progress/vj/sql/explorer/SQLExplorerGUI.workingCallback
at com/ms/lang/Delegate.dynamicInvoke0
at com/ms/lang/Delegate.dynamicInvoke
at com/ms/wfc/ui/Control.invokeMarshaledCallback
at com/ms/wfc/ui/Control.wndProc
at com/ms/wfc/ui/Form.wndProc
at com/ms/wfc/app/Application$ParkingForm.wndProc
at com/ms/wfc/ui/Control$ControlWindow.wndProc
at com/ms/wfc/app/Window.callback
at com/ms/wfc/win32/Windows.DispatchMessage
at com/ms/wfc/app/Application$ThreadContext.runMessageLoop
at com/ms/wfc/app/Application.run
at com/progress/vj/sql/explorer/SQLExplorerGUI.main

Questions: Why is there no link for the SQL Explorer Tool in OpenEdge 10.1A and 10.1B?
Is it possible to use it and how can I solve this problem.

 

[Casper]

Starting 10.1A the SQL explorer GUI was dropped from the release. You can still use the character version. (sqlexp.bat) or you can use any other GUI sql tool. (sQuirrel, DB navigator from OE architect etc.... ).

Casper.

 

[Lieven]

> Connection URL:
> jdbc:datadirectpenedge://localhost:15102;databaseName=pavar


some hints to explore to get your jdbc working:


(1)
You must include the following jar files in your classpath:

%DLC%/java/openedge.jar;%DLC%/java/util.jar:%DLC%/java/base.jar

see also:
http://www.psdn.com/library/servlet/KbServlet/download/111-102-98/dmsdv.pdf


(2)
change the URL:
jdbc:datadirectpenedge://host:port;databaseName=dns;defaultSchema=pub

found in this link:
http://knowledgebase.datadirect.com/kbase.nsf/SupportLink+Online/12273?OpenDocument



(3)
add the bin directory of progress to the path of windows

example:
PATH=%PATH%;D:\Develop\Progress\DLC\dlc9.1d\bin


good luck,
lieven