[Ed ross]

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

[support-pradeep]

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.

[Ed ross]

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.

[support-pradeep]

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?

[Ed ross]

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

[support-pradeep]

edross,

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

[Author]

Posts