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 90159 - Oracle9i - Netbeans 5.5 Issue : Unable to read database structure;connection is broken;Unsupported Feature
Summary: Oracle9i - Netbeans 5.5 Issue : Unable to read database structure;connection ...
Status: RESOLVED INVALID
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 5.x
Hardware: All All
: P2 blocker (vote)
Assignee: _ jimdavidson
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-11-28 09:39 UTC by chenji
Modified: 2007-08-21 00:25 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Oracle 9i - Netbeans 5.5 Issue Screen Shot as .ppt file (848.67 KB, application/x-compressed)
2006-11-28 09:46 UTC, chenji 		Details
NetBeans 5.5.1 - Oracle 9i error. Unable to read the database structure (211.46 KB, application/octet-stream)
2007-08-11 08:46 UTC, chenji 		Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description chenji 2006-11-28 09:39:32 UTC 
In Netbeans 5.5,after connecting to Oracle 9.2.0.1 version using thin
driver(classes12.jar).

When I click the Runtime tab -> Databases -> jdbc:oracle:thin..... -> Tables,
there is an error message that is displayed 

"Unable to read the database structure, connection is broken;Unsupported Feature"

But when you open a SQL Editor & run a simple sql statement to retreive values
from a table existing in the database it works fine.The results are displayed in
the output.
Comment 1 chenji 2006-11-28 09:46:08 UTC 
Created attachment 36311 [details]
Oracle 9i - Netbeans 5.5 Issue Screen Shot as .ppt file
Comment 2 chenji 2006-11-28 09:55:05 UTC 
The Oracle 9i - Table view issue when tested on Netbeans 5.5 beta2 version works
fine & without any problem.

I was able to view the all the available tables from the Oracle 9.2.0.1 database
using Thin driver(classes12.jar).

The same issue does not work with the latest Netbeans 5.5 release.
Comment 3 Jan Chalupa 2006-11-28 10:06:45 UTC 
Andrei, can you take a look, pls?
Comment 4 Andrei Badea 2006-11-28 13:17:37 UTC 
Likely a duplicate of issue 84654. Does using a 10.x Oracle JDBC driver instead
of a 9.x one help?
Comment 5 Andrei Badea 2007-01-03 16:06:22 UTC 

*** This issue has been marked as a duplicate of 84654 ***
Comment 6 chenji 2007-08-11 08:30:39 UTC 
Please re-open the issue. Same problems encounter for NetBeans 5.5.1.

In Netbeans 5.5.1,after connecting to Oracle 9.2.0.1 version using thin driver(classes12.jar).

When I click the Runtime tab -> Databases -> jdbc:oracle:thin..... -> Tables,
there is an error message that is displayed 

"Unable to read the database structure, connection is broken;Unsupported Feature"

But when you open a SQL Editor & run a simple sql statement to retreive values
from a table existing in the database it works fine.The results are displayed in
the output.
Comment 7 chenji 2007-08-11 08:39:57 UTC 
Similar problem also occurs even using thin driver(ojdbc14.jar) connecting to Oracle 9.2.0.1 version
Comment 8 chenji 2007-08-11 08:46:33 UTC 
Created attachment 46477 [details]
NetBeans 5.5.1 - Oracle 9i error. Unable to read the database structure
Comment 9 chenji 2007-08-11 08:48:25 UTC 
But Works fine while using Oracle 10g drivers..... what may be the reason for the problem while using oracle 9i drivers???
Comment 10 _ jimdavidson 2007-08-21 00:24:42 UTC 
The Oracle 9 drivers are not supported, because they do not implement the required JDBC APIs.  The Oracle 10 drivers are
better, although still not complete.

That being said, the v9 drivers work better in NetBeans 6, for which milestone builds are available.  They're still not
supported.
Comment 11 _ jimdavidson 2007-08-21 00:25:25 UTC 
Not supported.