facebook

New SQL Editor command does nothing [Closed]

💡
Our Forums Have Moved

For help with installation, bugs reports or feature requests, please head over to our new forums.
Genuitec Community on GitHub

  1. MyEclipse IDE
  2.  > 
  3. General Development
Viewing 15 posts - 1 through 15 (of 19 total)
  • Author
    Posts
  • #212880 Reply

    jdestremps
    Member

    When I right click on my SQL connection and select “New SQL Editor”, nothing happens. I can open the connection, see all the tables, etc, but no SQL Editor shows up. I have Eclipse 3.0 with the latest download and newly re-installed MyEclipse (both installation attempts didn’t bring up SQL Editor), on Windows XP Pro, brand new machine, lots of RAM, etc. Database connected to is Oracle (thin).

    #212886

    Riyad Kalla
    Member

    Can you check your log file for exceptions? (<workspace dir>\.metadata\.log)

    #212893

    snpe
    Member

    We can type in editor , but doesn’t exists exec icons (it exists in sqlexplorer/jfacedbc)

    regards

    #212897

    jdestremps
    Member

    I didn’t quite understand that last post. I will check my logs.

    #212898

    jdestremps
    Member

    Ok, thanks for the note about the logs. Here is the stack trace when I try to launch the SQL editor:

    !ENTRY org.eclipse.core.runtime 4 2 Aug 20, 2004 13:07:50.440
    !MESSAGE Problems occurred when invoking code from plug-in: “org.eclipse.core.runtime”.
    !STACK 0
    java.lang.NoClassDefFoundError: org/eclipse/jface/text/ITextViewerExtension5
    at com.genuitec.eclipse.sqlexplorer.plugin.editors.SQLEditor.<init>(Unknown Source)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at java.lang.Class.newInstance0(Unknown Source)
    at java.lang.Class.newInstance(Unknown Source)
    at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:143)
    at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:125)
    at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:114)
    at org.eclipse.ui.internal.WorkbenchPlugin.createExtension(WorkbenchPlugin.java:164)
    at org.eclipse.ui.internal.EditorManager$3.run(EditorManager.java:642)
    at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:819)
    at org.eclipse.core.runtime.Platform.run(Platform.java:493)
    at org.eclipse.ui.internal.EditorManager.createPart(EditorManager.java:640)
    at org.eclipse.ui.internal.EditorManager.openInternalEditor(EditorManager.java:627)
    at org.eclipse.ui.internal.EditorManager.openEditorFromDescriptor(EditorManager.java:437)
    at org.eclipse.ui.internal.EditorManager.openEditor(EditorManager.java:425)
    at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditor(WorkbenchPage.java:2099)
    at org.eclipse.ui.internal.WorkbenchPage.access$6(WorkbenchPage.java:2042)
    at org.eclipse.ui.internal.WorkbenchPage$9.run(WorkbenchPage.java:2029)
    at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:84)
    at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2024)
    at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2007)
    at com.genuitec.eclipse.sqlexplorer.sessiontree.actions.NewSQLEditor.run(Unknown Source)
    at org.eclipse.jface.action.Action.runWithEvent(Action.java:881)
    at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:536)
    at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:488)
    at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:420)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:833)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2348)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2029)
    at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1550)
    at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1526)
    at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:265)
    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:139)
    at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:47)
    at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:257)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:104)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.eclipse.core.launcher.Main.basicRun(Main.java:279)
    at org.eclipse.core.launcher.Main.run(Main.java:742)
    at org.eclipse.core.launcher.Main.main(Main.java:581)
    !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Aug 20, 2004 13:07:50.440
    !MESSAGE Error creating sql editor
    !STACK 1
    org.eclipse.ui.PartInitException: Unable to instantiate editor: com.genuitec.eclipse.sqlexplorer.plugin.editors.SQLEditor java.lang.NoClassDefFoundError: org/eclipse/jface/text/ITextViewerExtension5
    at org.eclipse.ui.internal.EditorManager.createPart(EditorManager.java:650)
    at org.eclipse.ui.internal.EditorManager.openInternalEditor(EditorManager.java:627)
    at org.eclipse.ui.internal.EditorManager.openEditorFromDescriptor(EditorManager.java:437)
    at org.eclipse.ui.internal.EditorManager.openEditor(EditorManager.java:425)
    at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditor(WorkbenchPage.java:2099)
    at org.eclipse.ui.internal.WorkbenchPage.access$6(WorkbenchPage.java:2042)
    at org.eclipse.ui.internal.WorkbenchPage$9.run(WorkbenchPage.java:2029)
    at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:84)
    at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2024)
    at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2007)
    at com.genuitec.eclipse.sqlexplorer.sessiontree.actions.NewSQLEditor.run(Unknown Source)
    at org.eclipse.jface.action.Action.runWithEvent(Action.java:881)
    at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:536)
    at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:488)
    at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:420)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:833)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2348)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2029)
    at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1550)
    at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1526)
    at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:265)
    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:139)
    at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:47)
    at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:257)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:104)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.eclipse.core.launcher.Main.basicRun(Main.java:279)
    at org.eclipse.core.launcher.Main.run(Main.java:742)
    at org.eclipse.core.launcher.Main.main(Main.java:581)
    !ENTRY org.eclipse.ui 4 0 Aug 20, 2004 13:07:50.440
    !MESSAGE Unable to instantiate editor: com.genuitec.eclipse.sqlexplorer.plugin.editors.SQLEditor java.lang.NoClassDefFoundError: org/eclipse/jface/text/ITextViewerExtension5

    #212901

    Riyad Kalla
    Member

    What is the Build ID of the version of Eclipse you have installed? Help > About

    Also did you download the entire SDK when you installed Eclipse or just the platform download? You need to use the entire SDK install (80meg)

    #212905

    jdestremps
    Member

    Build ID: 200402122000

    you mean the Java JDK? I have C:\j2sdk1.4.2_04

    #212907

    Riyad Kalla
    Member

    Build ID: 200402122000

    Ahhh, that is the problem right there. You need to be using the final release of Eclipse 3.0 GA which has a build ID 4 months after the release you are using. Lots of things changed in the API and I’m actually surprised ME was running on that build. Its a tricky mixing and matching process of release versions which is confusing for the users, sorry about that.

    you mean the Java JDK? I have C:\j2sdk1.4.2_04

    No I meant the Eclipse download, there is a platform download, JDT download and SDK download. You should download the Eclipse 3.0 SDK download.

    #212911

    jdestremps
    Member

    I think I only pulled the platform, not the SDK, so I’m getting the SDK. Why is this necessary (if you know)?

    #212912

    jdestremps
    Member

    Never mind. THanks, I posted this reply after your “Ahhh” reply. Thanks. I’ll re-install.

    #212913

    Riyad Kalla
    Member

    The SDK provides the full java tools and editing platform that our tools are built on, without them just the platform download is really for building a generic app (like a email client or something) ontop of Eclipse.

    We rely heavily on the tools and functionality provided by the JDT so we need that too, and its all in the SDK.

    #212919

    jdestremps
    Member

    Ok, so I’ve reinstalled, and now I’m getting the following error (which didn’t happen in my “broken” install, ie, it logged into the DB before). Where is this classpath set or how does it know where the oracle driver is. It’s imported as a jar already:

    java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

    #212920

    jdestremps
    Member

    and I tried both the classes12.jar as well as the classes12.zip and it doesn’t find the driver for some reason.

    #212921

    jdestremps
    Member

    Never mind. Got it.

    #212922

    jdestremps
    Member

    This can be closed as an issue.

Viewing 15 posts - 1 through 15 (of 19 total)
Reply To: New SQL Editor command does nothing [Closed]

You must be logged in to post in the forum log in