[ccullum@yemtech.com]

I have just upgraded myeclipseide and I am trying out the db explorer. I create a new profile, I us mmmysql, host as localhost, port 3306, the database I use, so my line looks like:
jdbc:mysql://localhost:3306/db
but it does not connect and all I get is an error with org.gjt.mm.mysql.Driver
I know the password I am using is good, that is what I use to get into MySQL Admin

[Scott Anderson]

Can you please post all the information we request in the ‘Posting Guidelines’ thread at the top of this forum in addition to any entries in the log file at <workspace>/.metadata/.log. With that information we’ll have some context from which we can start diagnosing the problem.

[ccullum@yemtech.com]

Here is my info
There was no error in the .log
the jdk is 1.4.2_04
I am using Win2K
Eclipse version info:
Version: 3.0.0
Build id: 200406251208
Freshly installed, not upgraded
MyEclipse version 3.7.200
Tomcat server 5.0.24

[Scott Anderson]

Any entries in the log file at <workspace>/.metadata/.log?

[Riyad Kalla]

org.gjt.mm.mysql.Driver

This is the old driver name when it used to be part of the GJT projects, try and set the driver back up and do “Find Driver” to use the com.mysql.jdbc.Driver class instead and see if that works. I think in the newer drivers they removed the old org.gjt driver, I might be wrong thought (I’ve always used the com.mysql one).

[ccullum@yemtech.com]

Thanks rkalla, that seems to have worked.
One issue I have is that the foreign keys do not show up under the foreign keys section. Is that not implemented yet?

[ccullum@yemtech.com]

Here is what was in the .log regarding the foreign key:
!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Jul 17, 2004 12:02:46.531
!MESSAGE Error getting fk data
!STACK 0
java.lang.NullPointerException
at com.genuitec.eclipse.sqlexplorer.dbviewer.details.W.<init>(Unknown Source)
at com.genuitec.eclipse.sqlexplorer.dbviewer.details.FKDetail$1.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:69)
at com.genuitec.eclipse.sqlexplorer.dbviewer.details.FKDetail.activate(Unknown Source)
at com.genuitec.eclipse.sqlexplorer.dbviewer.DetailManager$1.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:89)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:796)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2772)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2431)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1377)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1348)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:254)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:141)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:96)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:335)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:273)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:129)
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:183)
at org.eclipse.core.launcher.Main.run(Main.java:644)
at org.eclipse.core.launcher.Main.main(Main.java:628)

[ccullum@yemtech.com]

Please let me know if you need anything else

[Riyad Kalla]

Hmmm strange, let me send this along. I’m assuming you are using Innodb for those tables with FK’s right?

[Riyad Kalla]

Oh yea, also what version of Connector/J are you using? and MySQL?

[ccullum@yemtech.com]

Yes I am using InnoDB.
The version of MySql is 4.0.18-max-nt
the version of connector is 3.0.10-stable.
What else do you need

[Riyad Kalla]

That should be good, I sent the report to the devs.

[partitura]

Hello – I was having the same problem as ccullum listed above. However, my setup is:
MyEclipseIDE 3.8beta2
Elcipse 3.0
Mac OSX 10.3
I can confirm that I had to substitute a local com.mysql.jdbc.Driver for the MyEclipseIDE DB explorer to work.

[John Myers]

I’m trying to use the oracle drivers and upon looking in the log I realize the drivers listed in the popup menu aren’t being found. How was this popup list generated? The mm.mysql driver is really old.

[ccullum@yemtech.com]

Any news on this yet?

[Author]

Posts