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 100025 - Problems in browsing the oracle databases
Summary: Problems in browsing the oracle databases
Status: RESOLVED WORKSFORME
Alias: None
Product: db
Classification: Unclassified
Component: DB schema (show other bugs)
Version: 5.x
Hardware: HP Windows XP
: P4 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-04-04 17:58 UTC by shibnath82
Modified: 2008-10-09 18:54 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments
the error snapshot (2.25 MB, image/jpeg)
2007-04-04 18:10 UTC, shibnath82
Details
error snapshot (2.25 MB, image/jpeg)
2007-04-07 08:39 UTC, shibnath82
Details
specifying driver (2.25 MB, image/jpeg)
2007-04-07 08:43 UTC, shibnath82
Details

Note You need to log in before you can comment on or make changes to this bug.
Description shibnath82 2007-04-04 17:58:24 UTC
I am having another problem while browsing the oracle databases from netbeans db
explorer.....

whenever i try to browse the tables...an error message box comes up showing...

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

but the all sql are running fine.....only that i cannot browse the tables.....

please help me out again....
Comment 1 shibnath82 2007-04-04 18:10:41 UTC
Created attachment 40454 [details]
the error snapshot
Comment 2 _ jimdavidson 2007-04-04 19:28:35 UTC
It looks like you're using the Oracle JDBC drivers.  Which version?

Exactly what are you doing in the DB explorer when this problem occurs?  I.e.,
are you expanding an individual table node, or something else?

Comment 3 shibnath82 2007-04-05 03:21:54 UTC
its shown in the attached snapshot of the error....

...after connecting to the  oracle databases successfully, i tried to browse the
database from the db explorer(netbeans 5.5/jdk 5.0 update 3)....i.e i tried to
expand the "Tables" node....then i get that error message box showing "Unable to
read the database structure, connection is broken;Unsupported feature"

i clicked "ok" button of the error message box.. but the "+" sign on the left
side of the "Tables" node was no more there.......as such the "Tables" node
can't be expanded....but the SQL queries are running fine.....

...and i am using oracle jdbc drivers ojdbc14.jar(10.2.0.3)..i've also tried
with classes12.jar .... but no result......

...please help...
Comment 4 mdfejam 2007-04-05 20:47:43 UTC
-Worth checking out...your screenshot suggests the old Oracle class driver is 
configured...the NB IDE driver dropdown will specify the old driver even though 
your using ojdbc14.jar
Comment 5 shibnath82 2007-04-06 00:47:42 UTC

i couldn't get you,mdfejam......i've configured the NB IDE driver drop down to
the oracle driver ojdbc14.jar......so why this error message comes up?...

and if there is any other way by which i can browse the database through the DB
explorer...then please suggest me so....

without the DB explorer working properly...i cannot use its drag & drop features
while connecting the databases........
Comment 6 mdfejam 2007-04-06 19:52:52 UTC
Your screenshot of "Oracle Properties" for "DRIVER" is displaying the following 
literal "oracle.jdbc.dri..." SUGGESTING the old class has been specified.

Highlight your Oracle database driver and verify within the Property Window 
under DRIVER that it specifies "oracle.jdbc.OracleDriver" and 
NOT "oracle.jdbc.driver.OracleDriver". The Netbeans wizard still populates the 
old class name even though you have selected ojdbc14.jar.  This is still true 
in NB6.0.  

If I am misreading the screenshot; I apologize.
Comment 8 shibnath82 2007-04-07 08:37:33 UTC

ok...I did as you told me to do so,mdfejam...

...but the problem still persists.....

.....I changed the driver class from oracle.jdbc.driver.OracleDriver to 
oracle.jdbc.OracleDriver ..... but still..whenever i try to expand 
the "Tables" node of the DB Explorer....the error message comes up again....


I've attached the pictures of the connection and the error message....please 
go through them......

Comment 9 shibnath82 2007-04-07 08:39:30 UTC
Created attachment 40593 [details]
error snapshot
Comment 10 shibnath82 2007-04-07 08:43:28 UTC
Created attachment 40594 [details]
specifying driver
Comment 11 _ jimdavidson 2007-04-09 21:44:47 UTC
I've tried to reproduce the problem, but have not been able to.  The
"unsupported feature" messages appears to be coming from the JDBC driver.

A few questions/suggestions:

* Is there anything useful in the IDE log file?

* There may be something unusual about the particular Oracle database that
you're connecting to (e.g., something in the table names).  Try connecting to a
different Oracle database, if you have one available.

* There may be something corrupted in your user directory; try exiting netbeans,
deleting that, and restarting.

Comment 12 Andrei Badea 2007-04-12 17:23:11 UTC
Please make a connection to the database, right-click the connection and choose
Properties. Scroll down the list to "Driver version" and attach the value of
this property to the issue. 

Please also attach your message log (<userdir>/var/log/messages.log). Thanks.
Comment 13 David Vancouvering 2008-01-09 19:36:04 UTC
Closing, Andrei was unable to reproduce and user never got back to us.
Comment 14 David Vancouvering 2008-10-09 18:54:15 UTC
Closing