Import from database error

Help
othiery
2009-07-03
2013-05-13
  • othiery
    othiery
    2009-07-03

    Hi,

    First a great thank you for doing ERMaster, which is a great piece of software.

    Then unfortunately I find myself unable to import some MySQL databases with more than a few tables. I get a memory error at start of the import process, just after the parameters dialog.

    I can provide the DDL if needed.

    PostgreSQL database import seems OK for a few dozen tables (about 30 in my first test) but I had problems with a 270-tables database. The import of tables seemed to succeed and then while refreshing the design area the UI started freezing for minutes using half the processor time until I killed the process. I can provide this DDL too if you need test samples for large database schemas.

    I am using the following versions :
    * OS: winXP on client Win2k3 SP2 on server
    * MySQL server: 5.0.26 community nt
    * MySQL JDBC connector: 5.1.7
    * PostgreSQL server: 8.2.9
    * PostgreSQL JDBC driver: 8.3-604
    * Eclipse RCP 3.3.3.r33x_r20080129
    * GEF 3.3.2.v20080129
    * ERMaster 1.0.0.v20090701-2139

    Besides, I get lots of the following error (from Eclipse error log):

    eclipse.buildId=I20070625-1500
    java.version=1.6.0_11
    java.vendor=Sun Microsystems Inc.
    BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=fr_FR
    Command-line arguments:  -os win32 -ws win32 -arch x86
    This is a continuation of log file D:\dev\ermaster\.metadata\.bak_4.log
    Created Time: 2009-07-03 15:52:39.859

    Error
    Fri Jul 03 15:55:27 CEST 2009
    org.eclipse.pde.internal.runtime.logview.LogEntry cannot be cast to org.eclipse.gef.EditPart

    java.lang.ClassCastException: org.eclipse.pde.internal.runtime.logview.LogEntry cannot be cast to org.eclipse.gef.EditPart
        at org.insightech.er.editor.view.contributor.ERDiagramActionBarContributor$1.selectionChanged(ERDiagramActionBarContributor.java:206)
        at org.eclipse.ui.internal.AbstractSelectionService.fireSelection(AbstractSelectionService.java:156)
        at org.eclipse.ui.internal.AbstractSelectionService$1.selectionChanged(AbstractSelectionService.java:62)
        at org.eclipse.jface.viewers.Viewer$2.run(Viewer.java:162)
        at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:37)
        at org.eclipse.core.runtime.Platform.run(Platform.java:857)
        at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:46)
        at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:199)
        at org.eclipse.jface.viewers.Viewer.fireSelectionChanged(Viewer.java:160)
        at org.eclipse.jface.viewers.StructuredViewer.updateSelection(StructuredViewer.java:2047)
        at org.eclipse.jface.viewers.StructuredViewer.handleSelect(StructuredViewer.java:1138)
        at org.eclipse.jface.viewers.StructuredViewer$4.widgetSelected(StructuredViewer.java:1168)
        at org.eclipse.jface.util.OpenStrategy.fireSelectionEvent(OpenStrategy.java:227)
        at org.eclipse.jface.util.OpenStrategy.access$3(OpenStrategy.java:221)
        at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:388)
        at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
        at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938)
        at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682)
        at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293)
        at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389)
        at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353)
        at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219)
        at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466)
        at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289)
        at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461)
        at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
        at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106)
        at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:169)
        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106)
        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76)
        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363)
        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176)
        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.equinox.launcher.Main.invokeFramework(Main.java:508)
        at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447)
        at org.eclipse.equinox.launcher.Main.run(Main.java:1173)

    Thanks again for your great work,

    Olivier

     
    • Thank you for using ERMaster and reporting.

      Firstly following bug was fixed at version 1.0.0.v20090714-0000.

      - java.lang.ClassCastException: org.eclipse.pde.internal.runtime.logview.LogEntry cannot be cast to org.eclipse.gef.EditPart

       
    • It was changed so as not to layout imported tables automatically but to layout it evenly,
      when there were more than 100 numbers of tables,
      because it takes a lot of time to layout the imported table automatically, 
      when there are a lot of tables.

       
    • Finally

      > I get a memory error at start of the import process

      Does this go well by expanding the JavaVM heap memory?
      Please try to expanding the heap memory of Eclipse (for example -Xmx1024m).