This is a migrated thread and some comments may be shown as answers.

Reverse Engineering Wizard does not show any Tables/Classes

11 Answers 227 Views

Getting Started

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

11 Answers, 1 is accepted

answered on 20 May 2009, 12:27 AM

With the Q1 2009 version of openAccess loaded on my computer:

If I re-open the the project created with the Q3 2008 version of OpenAccess and start the reverse engineering wizard (all tables/classes are shown - as previousely noted). If I then select the Merge Schema Changes step, the form/dialog comes up empty. If I then check the 'Display Unchanged' Items check box I see all the Tables and Classes.
If I repeat the process with a project created under the Q1 2009 version of OpenAccess, I get empty forms/dialogs at all stages listed above

I have tried unloading the Q1 2009 version of OpenAcess and re-installing the Q3 2008 version to verify that I can still successfully reverse engineer new projects under Q3 2008. This worked OK.

Reloading Q1 2009 version recreated the same problem that has been documented in this thread.

answered on 22 May 2009, 10:03 AM

Hello Barry,

Can you please try the following

Ensure that there is no existing reversemapping.config in the new project before you execute the wizard.
Open the working project with Q1 2009 version and perform a 'Reload schema' (You need not save the settings). Do you get any schema objects after a reload?
Can you compare the app.config files of the working and non-working projects to ensure that exactly the same connection parameters are used.

Awaiting your findings.
All the best,

Ady

the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

answered on 23 May 2009, 04:16 AM

After enabling a project to use OpenAccess version Q3 2008 and another project using Q1 2009 the only difference in the app.config file is in the section starting

<section name="openaccess ......". The version Q1 2009 project contains an attribue 'requirePermission="false"' that is not present in the Q3 2008 version. The connection data is the same between the two projects.

Reloading the Q1 2009 version with no reverse engineering mapping does not do anything.

When starting the reverse engineering wizard in the Q3 2008 project the first thing that happens is that an options dialog comes is displayed. In this dialog you select the schema. In the Q1 2009 this options dialog does not appear.

In the Q3 2008 project after saving the configuration from the reverse engineering wizard, the reversemapping.config file ends with an options section that contains a list of all schemata that is contained in the database and a <usedShcemata> tag identifying the schema selected in the options dialog that comes up at the start of the reverse engineering wizard process.

In the Q1 2009 project after saving the the reverse mapping wizard configuration (where there is no prompt to select a schema) there is no list of schemata at the end of the reversmappong.config file, and the <usedSchemata> is set to "(default)". In the database that I am using the default schema has no objects (tables, views etc). If I manually edit the reversemapping.config file so that the <usedSchemata> element points to a valid schema, and then run the reverse engineering schema and do merge changes, I see all the tables in the database and can proceed to finish the wizard and generate the appropriate classes.

It appears that the Q1 2009 version is not able to find the schema in the database.

AN ASIDE: If I am trying to enable a class libary (that does not contain an app.config file) to use openAccess where is the connection information stored?

Having realised that the empty default schema may be the problem, I have tried enabling a project to use OpenAccess Q1 2009 against an oracle database that has objects in the default schema and that works OK!

Barry