[DougMH]

I’m trying to follow the webinar on 7.5, I open a table Database Explorer and right-click on Connected to…

and then New Visual SQL Query Editor. When I do it comes up fine, but no matter what database I have open, when I right-click in the “to add a table, right-click…” I simply get an empty dialog.

Any ideas? Here’s my “About” info.

MyEclipse Enterprise Workbench

Version: 7.5
Build id: 7.5-20090609

(c) Copyright Genuitec, L.L.C. 2000-2009. All rights reserved.
Visit http://www.myeclipseide.com/

This product includes software developed by the following
Eclipse Foundation http://www.eclipse.org/
Apache Software Foundation http://www.apache.org/

[support-shalini]

douglasmhurst,
There is an existing PR for the above issue using MySql. But it should work fine with MyEclipse Derby and Oracle.
Can you give some more information so that I can add to the PR?
1. What are your installation details? You can get them from MyEclipse > Installation Summary > Installation Details.
2. How did you install MyEclipse? Using all-in-one installer/Pulse/ added MyEclipse plugin to Eclipse?
Also, can you list out the databases that you have tried? This will help me replicate the issue internally. Thank you for your help.

[DougMH]

1. See below
2. I’m pretty sure here at work I installed 7.1 all-in-one, and it was upgraded to 7.5 by pulse updates.

Just FYI, I do see the tables for MyEclipse Derby.

Doug

*** Date:
Wednesday, September 2, 2009 11:29:45 AM EDT

** System properties:
OS=WindowsXP
OS version=5.1.0
Java version=1.6.0_13

*** MyEclipse details:
MyEclipse Enterprise Workbench
Version: 7.5
Build id: 7.5-20090609

*** Eclipse details:
MyEclipse Enterprise Workbench

Version: 7.5
Build id: 7.5-20090609

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-showsplash
-launcher
C:\Program Files\Genuitec\MyEclipse 7.1\myeclipse.exe
-name
Myeclipse
–launcher.library
C:\Program Files\Genuitec\MyEclipse 7.1\../Common\plugins\org.eclipse.equinox.launcher.win32.win32.x86_1.0.101.R34x_v20080731\eclipse_1115.dll
-startup
C:\Program Files\Genuitec\MyEclipse 7.1\../Common\plugins\org.eclipse.equinox.launcher_1.0.101.R34x_v20081125.jar
-clean
-configuration
configuration
-vm
C:\Program Files\Genuitec\Common\binary\com.sun.java.jdk.win32.x86_1.6.0.013\jre\bin\client\jvm.dll

[DougMH]

Also, you need to get this one fixed fast. All my tables are MySql, I’m not that great at writing complex SQL. I need HELP!

[Brian Fernandes]

Douglas,

Agreed – we do have this fixed internally. What connection URL are you using for MySQL?

Can you try and include the schema name in the connection string and see if that helps right now?

e.g. jdbc:mysql://localhost:3306/test instead of jdbc:mysql://localhost:3306/
where “test” is the name of the schema.

[DougMH]

this is a paste from my connection…

jdbc:mysql://localhost:3306/test

.. and it’s always been that way(with the schema name attached). It’s still not working for me.

[Author]

Posts