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 137620 - Create entity bean from database wizard (Oracle)
Summary: Create entity bean from database wizard (Oracle)
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: DB schema (show other bugs)
Version: 6.x
Hardware: All Linux
: P3 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords: REGRESSION
Depends on:
Blocks:
 
Reported: 2008-06-18 20:04 UTC by suedonne123
Modified: 2008-08-06 04:31 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 suedonne123 2008-06-18 20:04:11 UTC
I use New Create Entity Bean from Database wizard...
When I specify my datasource which is Oracle, it starts to pull in the database schema and I start
seeing lots of corrupt/strange tables (BIN?*123adsfj...stuff like that, so I am pretty sure there is
an Oracle problem here...)

Once all the strange tables plus my "real" tables are scanned through, I can see the "real" tables, 
I select one, then click ok...I am never able to create the entity bean here...it just silently does nothing
that I could tell anyway...no error message and no entity bean created...

I know that the oracle database has corrupt information based on looking at contents of the Oracle system tables:
all_objects    vs    all_tables

BUT, I know that using Netbeans 6.0.1, I do NOT see this behavior....My guess is that 6.1 is looking at
a different system table than did 6.0.1

Can you advise on this problem?
Comment 1 Peter Pis 2008-06-18 23:35:02 UTC
Reassigning to "j2ee" for evaluation.
Comment 2 suedonne123 2008-06-19 02:23:10 UTC
Okay, not sure what netbeans would like to do with this information but here is what my DBA found...

Oracle created the concept of a recycle bin in 10g. 
He is disabling this feature on our database...
The recycled tables were cleared with the 'purge recyclebin' command.

Now, when we run Netbeans 6.1 against this particular database, we no longer see the
garbage tables (or as officially called, the recyclables)

The oddity for us however, was that Netbeans 6.0.1 did NOT pick up these recycled tables...
Comment 3 Andrei Badea 2008-06-19 09:57:14 UTC
Should check if there is a regression in the database support. In the meanwhile, can you please check that you are using
a 10.x version of the Oracle JDBC driver?
Comment 4 suedonne123 2008-06-19 18:03:59 UTC
Using ojdbc14.jar which I believe is Oracle Thin Client Driver...
Here is Manifest info from the jar...

Manifest-Version: 1.0
Specification-Title:    Oracle JDBC driver classes for use with JDK14
Sealed: true
Created-By: 1.4.2_14 (Sun Microsystems Inc.)
Implementation-Title:   ojdbc14.jar
Specification-Vendor:   Oracle Corporation
Specification-Version:  Oracle JDBC Driver version - "10.2.0.4.0"
Implementation-Version: Oracle JDBC Driver version - "10.2.0.4.0"
Implementation-Vendor:  Oracle Corporation
Implementation-Time:    Sat Feb  2 11:40:29 2008

Name: oracle/sql/converter/
Sealed: false

Name: oracle/sql/
Sealed: false

Name: oracle/sql/converter_xcharset/
Sealed: false
Comment 5 David Vancouvering 2008-06-19 19:42:53 UTC
I made some changes to better handle Oracle drivers that throw exceptions, but I don't get why this would prevent the
"real" tables from being used to generate entities.  

It sounds like the workaround is to do 'purge recyclebin'.

We should look at this.
Comment 6 Andrei Badea 2008-08-05 16:48:27 UTC
93622e20a316
Comment 7 Quality Engineering 2008-08-06 04:31:52 UTC
Integrated into 'main-golden', available in build *200808060201* on http://bits.netbeans.org/dev/nightly/
Changeset: http://hg.netbeans.org/main/rev/93622e20a316
User: Andrei Badea <abadea@netbeans.org>
Log: #137620: Create entity bean from database wizard (Oracle)