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.
When you connect to an AS400 database you are no longer able to see any schema under the top level node. You are not able to view any tables or other object, nor add any. You can still execute queries and the database connection itself seems to be working. When you try to expand the database connection node, the + disappears for a short while, then reappears. No items are expanded under the route node. This functioned perfectly prior to 6.8 and has only stopped working in this version. It has been tested on various AS400 databases and on the latest JDBC drivers. Other users have this issue too; http://netbeans.org/projects/www/lists/nbusers/archive/2010-02/message/129
Because AS400 is not one of supported platforms/db I have to decrease the priority to P3/4. If there is a public accessible AS400 server I can debug NetBeans DB support with that one.
I have checked message.txt and there is nothing indicating an issue of any kind. Is there a way of turning on some kind of detail debug output, in order to see what the db exploring is trying to do when the root node is being expanded?
I think this bug may be the same then id 174220 bug: https://netbeans.org/bugzilla/show_bug.cgi?id=174220
There is absolutely no way we are going to be able to make our AS/400 boxes publicly available for testing. Surely there's another way to find out how this regression happened?
Access to AS400 systems for testing seems "difficult" for sure. Is it not possible to turn on some kind of detail logging for this module so that users with access to an as400 can test and report details. Surely this should be enough to resolve this?
Created attachment 95367 [details] log file with requested -D argument
Thanks for the log. I'm going to patch the module to ignore such exception and send you back.
Created attachment 95448 [details] patched db-metadata module Attached DB JDBC Metadata module, contains more logging and a fix maybe. Please, copy the module into your IDE installation and try connect to AS400 again. Send back your log. Thanks
Works great, thank you! For those who didn't see the message on the NetCAT list, the request was to add -J-Dorg.netbeans.modules.db.level=FINEST before starting NetBeans in order to get logging information. You would add it to the netbeans_default_options line in <install-dir>/etc/netbeans.conf. The patched module goes in <install-dir>/ide/modules.
Created attachment 95456 [details] log file with patched module installed
Thanks for response. The fix seems to be working, I commit the fix in core-main/rev/3796bc229799 Btw, the problem was caused by fix of issue 169704 in NB6.8.
Integrated into 'main-golden', will be available in build *201003230200* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main/rev/3796bc229799 User: Jiri Rechtacek <jrechtacek@netbeans.org> Log: #180284: Services->Databases no longer works for AS400 databases