Import from database error

  • othiery


    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):

    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

    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.eclipse.ui.internal.AbstractSelectionService.fireSelection(
        at org.eclipse.ui.internal.AbstractSelectionService$1.selectionChanged(
        at org.eclipse.jface.viewers.Viewer$
        at org.eclipse.ui.internal.JFaceUtil$
        at org.eclipse.jface.viewers.Viewer.fireSelectionChanged(
        at org.eclipse.jface.viewers.StructuredViewer.updateSelection(
        at org.eclipse.jface.viewers.StructuredViewer.handleSelect(
        at org.eclipse.jface.viewers.StructuredViewer$4.widgetSelected(
        at org.eclipse.jface.util.OpenStrategy.fireSelectionEvent(
        at org.eclipse.jface.util.OpenStrategy.access$3(
        at org.eclipse.jface.util.OpenStrategy$1.handleEvent(
        at org.eclipse.swt.widgets.EventTable.sendEvent(
        at org.eclipse.swt.widgets.Widget.sendEvent(
        at org.eclipse.swt.widgets.Display.runDeferredEvents(
        at org.eclipse.swt.widgets.Display.readAndDispatch(
        at org.eclipse.ui.internal.Workbench.runEventLoop(
        at org.eclipse.ui.internal.Workbench.runUI(
        at org.eclipse.ui.internal.Workbench.access$4(
        at org.eclipse.ui.internal.Workbench$
        at org.eclipse.core.databinding.observable.Realm.runWithDefault(
        at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(
        at org.eclipse.ui.PlatformUI.createAndRunWorkbench(
        at org.eclipse.ui.internal.ide.application.IDEApplication.start(
        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(
        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(
        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(
        at org.eclipse.equinox.launcher.Main.basicRun(

    Thanks again for your great work,


    • 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).