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 93094 - DatabaseException with Oracle 9i MetaData
Summary: DatabaseException with Oracle 9i MetaData
Status: RESOLVED DUPLICATE of bug 84654
Alias: None
Product: db
Classification: Unclassified
Component: DB schema (show other bugs)
Version: 5.x
Hardware: PC Windows XP
: P2 blocker with 1 vote (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-01-24 12:32 UTC by cschneider4711
Modified: 2007-01-31 13:45 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 cschneider4711 2007-01-24 12:32:43 UTC 
Hello,

some Oracle JDBC drivers (for Oracle 9i) throw an java.sql.SQLException when 
accessing dbMetaData.getDatabaseMajorVersion(). When trying to open the tables 
node in the DB view with such a JDBC driver for Oracle 9i the following 
exception is thrown in NB (which therefore refuses to show any tables):


org.netbeans.api.db.explorer.DatabaseException: Nicht unterstützte Funktion
	at org.netbeans.modules.db.explorer.infos.TableListNodeInfo.initChildren
(TableListNodeInfo.java:75)
	at org.netbeans.modules.db.explorer.infos.DatabaseNodeInfo.getChildren
(DatabaseNodeInfo.java:675)
[catch] at org.netbeans.modules.db.explorer.DatabaseNodeChildren$2.run
(DatabaseNodeChildren.java:94)
	at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:499)
	at org.openide.util.RequestProcessor$Processor.run
(RequestProcessor.java:932)
Caused by: java.sql.SQLException: Nicht unterstützte Funktion
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
	at oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlException
(DBError.java:689)
	at oracle.jdbc.OracleDatabaseMetaData.getDatabaseMajorVersion
(OracleDatabaseMetaData.java:4442)
	at org.netbeans.lib.ddl.adaptors.DefaultAdaptor.getDatabaseMajorVersion
(DefaultAdaptor.java:3967)
	at org.netbeans.modules.db.explorer.infos.TableListNodeInfo.initChildren
(TableListNodeInfo.java:49)
	... 4 more


Best Regards & keep up the good work,
Chris
Comment 1 Petr Blaha 2007-01-24 15:38:48 UTC 
Which version of JDBC driver do you use?
Comment 2 cschneider4711 2007-01-29 12:39:41 UTC 
This is the content of the Oracle driver's META-INF/Manifest.mf file (of 
ojdbc14_g.jar)


Manifest-Version: 1.0
Specification-Title: "Oracle JDBC driver classes for use with JDK1.4"
Specification-Version: "Oracle JDBC Driver version - 9.0.2.0.0"
Specification-Vendor: "Oracle Corporation" .
Implementation-Title: "ojdbc14_g.jar"
Implementation-Version: "Oracle JDBC Driver version - 9.0.2.0.0"
Implementation-Vendor: "Oracle Corporation"
Implementation-Time: "Thu Apr 25 23:48:25 2002"
Comment 3 Andrei Badea 2007-01-31 13:45:38 UTC 
Please use a 10.x driver.


*** This issue has been marked as a duplicate of 84654 ***