[Girish Pandit]

This message has not been recovered.

[Loyal Water]

Girish,
Can you go to MyEclipse > Installation Summary > Installation Details and paste the information here for me.

The MYSQL database is a local database or a remote database ?

[Girish Pandit]

Sorry for the delay in response but here is the installation details

*** Date:
Friday, January 25, 2008 10:34:45 PM EST

** System properties:
OS=WindowsXP
OS version=5.1
Java version=1.5.0_11

*** MyEclipse details:
MyEclipse Enterprise Workbench
Version: 6.0.1 GA
Build id: 6.0.1-GA-200710

*** Eclipse details:
MyEclipse Enterprise Workbench

Version: 6.0.1 GA
Build id: 6.0.1-GA-200710

Eclipse Platform

Version: 3.3.1.R33x_r20070911-_19UEkpF-B7Uh2hKy75y
Build id: M20070921-1145

Eclipse RCP

Version: 3.3.1.R33x_r20070802-8y8eE8sEV3Fz0z0GlHJrXvTAUS
Build id: M20070921-1145

Eclipse Java Development Tools

Version: 3.3.1.r331_v20070629-7o7jE72EDlXAbqAcnbmyg1rf8RIL
Build id: M20070921-1145

Eclipse Plug-in Development Environment

Version: 3.3.1.R33x_r20070802-7N7M3D1VIA_52JsDFsEC
Build id: M20070921-1145

Eclipse Graphical Editing Framework

Version: 3.3.1.v20070814
Build id: 20070814-1555

Eclipse Project SDK

Version: 3.3.1.R33x_r20070802-7M7J78_mu1mnlRa7A4Ns52XeZ6D0
Build id: M20070921-1145

Eclipse Graphical Editing Framework

Version: 3.3.1.v20070814
Build id: 20070814-1555

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-showsplash
-launcher
C:\working\Development\ide\MyEclipse_6.0.1\eclipse\eclipse.exe
-name
Eclipse
–launcher.library
C:\working\Development\ide\MyEclipse_6.0.1\eclipse\plugins\org.eclipse.equinox.launcher.win32.win32.x86_1.0.1.R33x_v20070828\eclipse_1020.dll
-startup
C:\working\Development\ide\MyEclipse_6.0.1\eclipse\plugins\org.eclipse.equinox.launcher_1.0.1.R33x_v20070828.jar
-exitdata
f0_7c
-vm
C:\working\Development\ide\MyEclipse_6.0.1\jre\bin\javaw.exe

[Girish Pandit]

I tried both local as well as remote database and in both the cases I have same scenario.

[Riyad Kalla]

Girish,
For MySQL you won’t see any key relationships unless you are using the InnoDB table type, my guess is that you are using MYISAM table types which don’t maintain any relationship information in them.

As for MS SQL Server, either you don’t have any foreign keys setup on your table *or* the driver you are using to connect to the DB isn’t handling/reporting/querying that information correctly when reporting it to the ER Diagram generator. WHich driver are you using? Microsoft released an updated one a year or so ago, and I know the jTDS is a great driver alternative to the Microsoft one: http://jtds.sourceforge.net/

[Girish Pandit]

it looks like with MySQL what you mention is the case, it is set to use MYISAM.

About MS SQL, I will check with that. As for as I remember I used the MS SQL server driver came with MS SQL 2005 but I will double check on that.

[Author]

Posts