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 155304

Summary: Cannot explore databases in Database Explorer
Product: db Reporter: stefanhinz <stefanhinz>
Component: MySQLAssignee: David Vancouvering <davidvc>
Status: RESOLVED DUPLICATE    
Severity: blocker    
Priority: P3    
Version: 6.x   
Hardware: Other   
OS: Linux   
Issue Type: DEFECT Exception Reporter:
Attachments: Messages log file for "cannot explore database objects" bug

Description stefanhinz 2008-12-12 09:06:42 UTC 
I can connect without issues to MySQL instances (servers) locally and remotely. Depending on which MySQL accounts I use
I see the databases that I have privileges for. With an administrative MySQL account, I can create and drop databases.
So far, all works as expected.

But I can't expand the database icons to see the contained objects (e.g. tables). Double-clicking does nothing, and
right-clicking gives the options of "Connect" and "Delete", nothing else. I'd expect to see tables for the databases
that contain tables, for example for my "test" database:

mysql> show tables from test;
+---------------------+
| Tables_in_test      |
+---------------------+
| #123||@@            |
| huh                 |
| ingo                |
| my_first_base_table |
| parts               |
| parts_copy          |
| test                |
| uptest              |
+---------------------+
8 rows in set (0.08 sec)

But the NetBeans Database Explorer shows nothing. Bugger.

Maybe this is related to bug #155301 (http://www.netbeans.org/issues/show_bug.cgi?id=155301) which I just reported, I
don't know.
Comment 1 John Baker 2008-12-12 09:12:31 UTC 
No, not related to issue 155301.

Could you attach your messages.log file from the userdir
Comment 2 stefanhinz 2008-12-12 09:34:29 UTC 
Created attachment 74894 [details]
Messages log file for "cannot explore database objects" bug
Comment 3 David Vancouvering 2008-12-12 17:16:47 UTC 
Yes, Stefan, this is annoying and confusing.  This is a duplicate of issue 150660 which we *hope* to get to in this release.

Meanwhile, right-click, choose Connect, a new connection will be made for you (it's a new node in the tree, see below
the MySQL node), and you can open *that* and browse your tables.

We really do want to fix that, thanks for taking the time to log the issue

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