This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 204601 - Unable to obtain oracle table list for Hibernate Reverse Engineering Wizard
Summary: Unable to obtain oracle table list for Hibernate Reverse Engineering Wizard
Status: RESOLVED WONTFIX
Alias: None
Product: javaee
Classification: Unclassified
Component: Hibernate (show other bugs)
Version: 7.1
Hardware: PC Other
: P4 normal (vote)
Assignee: Sergey Petrov
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-11-02 21:38 UTC by esmithbss
Modified: 2016-07-07 08:55 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description esmithbss 2011-11-02 21:38:17 UTC
The Hibernate Reverse Engineering wizard does not obtain the list of tables from an oracle database properly for the second page of the wizard.

During the process, an error message dialog is presented to the user and immediately removed so the user cannot see/read the contents.

There is no error listed in the IDE Log file.

Steps to reproduce:

1) Ensure the Oracle Database Server is accessible.
2) Add the Oracle jdbc driver to the Oracle Thin database connection provider
3) Create a new service connection to the Oracle database.  Ensure you can access the proper schema and see the tables within that schema.
4) Create a new Java application.
5) Create a Hibernate.cfg.xml file using the New/Other/Hibernate Configuration Wizard.  Map this to your Oracle database.
6) Add the correct hibernate.default_schema property to your hibernate.cfg.xml file. 
7) Create a HibernateUtil.java using the New/Other/HibernateUtil.java wizard.
8) Run the Hibernate Reverse Engineering Wizard to create your reveng.xml file.

Leave the defaults on the first page of the wizard alone and click "Next >"

At this point, 

A) An error message flashes across the screen and is unreadable because it vanishes immediately.

B) The second page of the wizard properly shows the hibernate.cfg.xml in the Configuration File pull down

C) The Available Tables list is empty.
Comment 1 Sergey Petrov 2011-11-03 10:16:19 UTC
Need to obtain this database to evaluate.
I have a question regarding step 6, what will happens if omitted?
Can default be set at connection node at Services tab? For example wizard will likely fail if default isn't set for javaDB but don't remember if there may be any error messages regarding this fail.
Regarding errro message, is it rreally error? it may be some connection window which is closed fast right after connection established.
Comment 2 Sergey Petrov 2011-11-03 12:19:48 UTC
From brief evaluation it just isn't supported to use not fully defined connection (or connection to another schema) and combine it with hibernate.default_schema property, current hibernate support require connection to have full information to get tables. Is it the case? 
Not sure if it's a defect in this case if corrsponding red message is shown like :can't connect with selected cfg"
Comment 3 Sergey Petrov 2011-11-07 10:30:15 UTC
As got no additional details and it may be enhancement/unsupported case - >P4,
feel free to change back and share your feeling on the issue and additional details.
Comment 4 Martin Balin 2016-07-07 08:55:22 UTC
This old bug may not be relevant anymore. If you can still reproduce it in 8.2 development builds please reopen this issue.

Thanks for your cooperation,
NetBeans IDE 8.2 Release Boss