Bug 104117

That message indicates a limitation in the Oracle JDBC drivers.

Which version of the drivers are you using?  You should generally use the latest
available, which is currently 10.2.0.3:

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

The newer drivers fix some problems that earlier ones had.  Please try them (if
you haven't already) and report the result.

If the newest driver doesn't help please reproduce the issue with a clean
userdir and attach your message log here. Thanks.

bug confirmed with latest Oracle JDBC driver 10.2.0.3

To reproduce:

-download NB6 w Sun App server 9.1
-create Oracle connection pool and JDBC resource using app server admin console
-ping to ensure connection with db works
-open NB6
-click on Runtime tab
-right click Oracle JDBC connection
-connection will be established
-clicking on Views and Stored Procedures works and metadata are shown correctly
-but clicking on Tables fails, no metadata shown and NB6 complains about
database structure saying "...unsupported feature"

This bug is present only in NB6. In NB5.5, using the same Sun app server 9.1
setup, I could not reproduce it and everything worked as expected

NB6 is using DB Explorer version 1.20.0.4
NB5.5 is using DB Explorer version 1.19.21.4

Please reproduce the issue, right-click on the connection node in the DB
Explorer and attach here the value of the "Driver version" property. Also please
provide the information required in desc3.

issue was reproduced on NB6 with two different versions of Oracle ojdbc14.jar
driver (last one was latest version 10.2.0.3)

issue cannot be reproduced with NB5.5 (DB Explorer 1.19.21.4) nor NB5.5.1
release candidate 1 (DB Explorer 1.19.30.4), only with NB6 (DB Explorer 1.20.0.4)

I uninstalled NB6 and I now work with NB5.5.1, but the pop-up message I got was:
"Error while reading database structure: unsupported feature"

This error pops up only when you try to read Tables metadata. Views and
Procedures reading work fine.

The setup of JDBC connections was: 

-two different Oracle JDBC connections targeting two different Oracle schemas.
One of these connections was based on
oracle.jdbc.pool.OracleConnectionPoolDataSource and its resource type was
javax.sql.ConnectionPoolDataSource
while other was based on oracle.jdbc.pool.OracleDataSource
and resource type javax.sql.DataSource

Other two connections were Derby database related

Same setup was also used while testing NB5.5 and NB5.5.1

Which directory you want me to delete?

Start NetBeans with a command like:

netbeans -userdir "c:\temp_userdir"

then reproduce the issue and attach the file in
c:\temp_userdir\var\log\messages.log to this issue.

Also please do what I requested in desc7. I need the driver version as seen by
the DB Explorer, not what you think is the driver version. You might have an
older version of the Oracle driver in the edorsded direrctory.

excerpt from messages.log:

INFO: Unsupported feature
java.sql.SQLException: Unsupported feature
	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)
Caused: org.netbeans.api.db.explorer.DatabaseException: Unsupported feature
	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:539)
	at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:964)

Created attachment 42543 [details]
messages.log

Thanks. Based on the stack trace I strongly think an older driver than 10.x gets
loaded. See issue 84654 for details. You might e.g. have an older driver in the
endorsed dir.

I'm asking for the third time: "Please reproduce the issue, right-click on the
connection node in the DB Explorer and attach here the value of the "Driver
version" property."

Requested info not provided for a long time. Closing as a duplicate of issue 84654.


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