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 143251 - poor connection registration
Summary: poor connection registration
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: MySQL (show other bugs)
Version: 6.x
Hardware: PC Windows Vista
: P3 blocker (vote)
Assignee: David Vancouvering
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-08-07 23:40 UTC by Vince Kraemer
Modified: 2008-08-19 01:27 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Vince Kraemer 2008-08-07 23:40:34 UTC
I downloaded and installed the NB/GF/My bundle and installed it, without changing any defaults.

The installation went fine.

I started the IDE with a clean userdir and see that 4 connections are registered.

There are three for derby:
  jdbc:derby://localhost:1527/sample
  jdbc:derby://localhost:1527/travel
  jdbc:derby://localhost:1527/vir

There is one for MySQL:
   jdbc:mysql://localhost:3306

(Note that there isn't a database name associated with this connection URL)

It looks like I am able to connect to MySQL using that connection.

But, when I click OK on the Create Table dialog I see the following error:

Unable to execute command:
create table Untitled
(
   fubar BIT
)
No database selected.

as best I can tell, the MySQL connection that is registered is useless.

I think it might be useful to register a connection to
  jdbc:mysql://localhost:3306/test.

It appears to be an empty database that users can create table inside.
Comment 1 David Vancouvering 2008-08-08 04:44:17 UTC
I agree, we should probably get rid of that connection.  It's useful only for admin, not for working with tables and
databases.
Comment 2 David Vancouvering 2008-08-19 01:27:54 UTC
Hi, Vince.  I think this is no longer happening since my change to fix Issue 143408.  I just did a code inspection (no
reference to "DatabaseConnection.create" and my own tests show I don't see this connection any more.  I am closing, but
please reopen if you can still reproduce.  Otherwise please mark as verified.