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 94581 - Cannot View Tables in DB Explorer
Summary: Cannot View Tables in DB Explorer
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 5.x
Hardware: PC Windows XP
: P3 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-02-06 04:02 UTC by rappleby
Modified: 2007-02-28 14:29 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
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 rappleby 2007-02-06 04:02:25 UTC 
Hi,

I have a connection to my DB and when I click on the Tables node to view all 
of my tables all I get is a small Please wait.. appearing.

The following is ouput in the /var/log/messages.log 
*********** Exception occurred ************ at 2:37 PM on Feb 6, 2007
java.lang.AbstractMethodError: 
oracle.jdbc.driver.OracleDatabaseMetaData.getDatabaseMajorVersion()I
	at org.netbeans.lib.ddl.adaptors.DefaultAdaptor.getDatabaseMajorVersion
(DefaultAdaptor.java:3967)
	at 
org.netbeans.modules.db.explorer.infos.TableListNodeInfo.initChildren
(TableListNodeInfo.java:49)
	at org.netbeans.modules.db.explorer.infos.DatabaseNodeInfo.getChildren
(DatabaseNodeInfo.java:675)
	at org.netbeans.modules.db.explorer.DatabaseNodeChildren$2.run
(DatabaseNodeChildren.java:94)
	at org.openide.util.RequestProcessor$Task.run
(RequestProcessor.java:499)
[catch] at org.openide.util.RequestProcessor$Processor.run
(RequestProcessor.java:932)

I am using the Oracle Driver 10.2.0.2 with an Oracle 8.1.7 DB.
I can see all of my Views and procedures in the DB Tree, just not the tables.
I have also tried using Oracle Drivers 10.2.0.1, 10.1.0.5 & 8.1.7.1 to no 
avail.

Any ideas?
Comment 1 Andrei Badea 2007-02-06 10:14:07 UTC 
Weird. The exception is thrown by a driver which is not JDBC 3.0 compliant (see
issue 84654). But you say you are using a 10.x driver, which AFAIK does support
JDBC 3.0. Please double-check that you are really using a 10.x driver to connect
to the database. The safest way to check is to connect to the database, invoke
the Properties action on the connection node and look at the value of the
"Driver version" property.
Comment 2 rappleby 2007-02-07 01:34:15 UTC 
We had a legacy application that required a few extra jars to be copied into 
the jre/lib/ext folder for the various JREs and SDKs installations that we 
had. One of them just happened to be classes12.jar.

Removed this from the all the JRE/JDK install directories and everything is 
now fine.

Thankyou for your assistance.
Comment 3 Lukasz Grela 2007-02-28 14:29:39 UTC 
v.