- create TRAVEL schema in an Oracle 9i database schema
- install Oracle ojdbc14.jar driver in Sun Application Server 9.1
- Ping in admin console to ensure ping OK
- in NB6 Runtime right click Oracle jdbc driver and select Connect
- after connecting there will be entries for Tables, Views and Stored Procedures
- Selecting Views and Stored Procedures works OK
- But selecting Tables fails. The message pops up saying "...not supported"
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:
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
-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
-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 188.8.131.52
NB5.5 is using DB Explorer version 184.108.40.206
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 220.127.116.11) nor NB5.5.1
release candidate 1 (DB Explorer 18.104.22.168), only with NB6 (DB Explorer 22.214.171.124)
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
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
Caused: org.netbeans.api.db.explorer.DatabaseException: Unsupported feature
Created attachment 42543 [details]
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
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
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 ***