facebook

JPA Reverse engineering

  1. MyEclipse Archived
  2.  > 
  3. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #331674 Reply

    Ed ross
    Member

    I’ve created a new project and would like to generate some JPA classes.

    Our database scheme is large (~600 tables) but not unusual. I select the schema, and select about 20 tables from the schema to generate. I do not have it looking at associate tables /fk to find implied references.

    The generation process takes hours (you can see the percent change about every hour) but never even finishes.

    using myeclipse 10.6 – clean install, windows 7 64 bit.

    I’ve noticed the same issue in 8.6 using vista 32 bit.

    I’m guessing there is some configuration someplace I’ve messed up.

    Any way to make this process faster.

    Thx

    #331677 Reply

    edross,

    I could not replicate the issue at my end.

    Can you answer some more questions for us ?
    1) How large is your workspace ?
    2) Try a new workspace, create a new project in the new workspace and try to reverse engineer again.
    3) Please delete your .log file (in the .metadata folder of your workspace), try reverse engineering again and attach the resultant .log file here.

    #331788 Reply

    Ed ross
    Member

    I’m beginning to suspect the jdbc driver is the root of the issue. Had some time to try your suggestions and found there is nothing in the logs that would suggest an issue.

    I’ve tried with the oracle drivers 4, 5 & 6.

    !SESSION 2012-10-29 08:59:05.128 ———————————————–
    eclipse.buildId=unknown
    java.version=1.6.0_13
    java.vendor=Sun Microsystems Inc.
    BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_US
    Framework arguments: -showlocation
    Command-line arguments: -os win32 -ws win32 -arch x86_64 -showlocation

    !ENTRY org.eclipse.jface 2 0 2012-10-29 08:59:13.537
    !MESSAGE Keybinding conflicts occurred. They may interfere with normal accelerator operation.
    !SUBENTRY 1 org.eclipse.jface 2 0 2012-10-29 08:59:13.537
    !MESSAGE A conflict occurred for CTRL+F9:
    Binding(CTRL+F9,
    ParameterizedCommand(Command(org.eclipse.mylyn.tasks.ui.command.activateTask,Activate Task,
    ,
    Category(org.eclipse.ui.category.navigate,Navigate,null,true),
    ,
    ,,true),null),
    org.eclipse.ui.defaultAcceleratorConfiguration,
    org.eclipse.ui.contexts.window,,,system)
    Binding(CTRL+F9,
    ParameterizedCommand(Command(RunSQLAction,Run SQL,
    Run SQL,
    Category(org.eclipse.ui.category.edit,Edit,null,true),
    ,
    ,,true),null),
    org.eclipse.ui.defaultAcceleratorConfiguration,
    org.eclipse.ui.contexts.window,,,system)

    !ENTRY org.eclipse.core.filebuffers 4 0 2012-10-29 08:59:17.320
    !MESSAGE The content type with id “com.genuitec.eclipse.jsf.designer.facelets” specified in the extension point does not exist.

    !ENTRY org.eclipse.core.filebuffers 4 0 2012-10-29 08:59:17.322
    !MESSAGE The content type with id “com.genuitec.eclipse.jsf.designer.facelets” specified in the extension point does not exist.
    !SESSION 2012-10-29 09:20:52.337 ———————————————–
    eclipse.buildId=unknown
    java.version=1.6.0_13
    java.vendor=Sun Microsystems Inc.
    BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_US
    Framework arguments: -showlocation
    Command-line arguments: -os win32 -ws win32 -arch x86_64 -showlocation

    !ENTRY org.eclipse.jface 2 0 2012-10-29 09:21:02.913
    !MESSAGE Keybinding conflicts occurred. They may interfere with normal accelerator operation.
    !SUBENTRY 1 org.eclipse.jface 2 0 2012-10-29 09:21:02.913
    !MESSAGE A conflict occurred for CTRL+F9:
    Binding(CTRL+F9,
    ParameterizedCommand(Command(org.eclipse.mylyn.tasks.ui.command.activateTask,Activate Task,
    ,
    Category(org.eclipse.ui.category.navigate,Navigate,null,true),
    ,
    ,,true),null),
    org.eclipse.ui.defaultAcceleratorConfiguration,
    org.eclipse.ui.contexts.window,,,system)
    Binding(CTRL+F9,
    ParameterizedCommand(Command(RunSQLAction,Run SQL,
    Run SQL,
    Category(org.eclipse.ui.category.edit,Edit,null,true),
    ,
    ,,true),null),
    org.eclipse.ui.defaultAcceleratorConfiguration,
    org.eclipse.ui.contexts.window,,,system)

    !ENTRY org.eclipse.core.filebuffers 4 0 2012-10-29 09:21:06.555
    !MESSAGE The content type with id “com.genuitec.eclipse.jsf.designer.facelets” specified in the extension point does not exist.

    !ENTRY org.eclipse.core.filebuffers 4 0 2012-10-29 09:21:06.558
    !MESSAGE The content type with id “com.genuitec.eclipse.jsf.designer.facelets” specified in the extension point does not exist.

    #331813 Reply

    edross,

    Can you please give us some more information to help us investigate further :
    1) Can you please tell which version of Oracle you are using ?
    2) Can you please recheck whether the driver you are using is compatible with your oracle version?

    #331819 Reply

    Ed ross
    Member

    We are using oracle 11.2.02

    I have tried ojdbc4, ojdbc5 & ojdbc6

    I have tried
    oracle.jdbc.driver.OracleDriver
    and
    oracle.jdbc.OracleDriver

    I am able to work with the database explorer without issues.

    When I try and generate JPA artifacts, the dialog box will state “Generating Artifacts” but not activity for about 30 minutes. Then will give some % complete – but one table will take about 4 hours. (my estimate based on % completed I’ve never let it run all night).

    Window 7
    8 gig of ram
    Latitude E6530 quad core

    Database has many tables (hundreds )
    The schema where I try and export 1 item from has about 80 tables.

    I think it is the driver because:

    there is nothing in the logs to indicate error conditions.
    The task manager shows 0% activity while in this state. – no change in memory, no network use.

    My guess is the code is trying to gather metadata about the entire database in one query


    Mystery solved.

    the tool generates sql to find meta-data.

    Some time ago (before we upgraded to oracle 11) one of our database folks created an oracle profile for that query (to help optimmize some reverse engineering).

    The profile had a bad access plan after the upgrade and was doing multiple table scans

    #331820 Reply

    edross,

    Glad that you got the issue resolved.
    Let us know if you see any issues.

Viewing 6 posts - 1 through 6 (of 6 total)
Reply To: JPA Reverse engineering

You must be logged in to post in the forum log in