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 86586

Summary: "jdbc:mysql://localhost:/test" on New Database Connection dialog, but ":" is not necessary
Product: serverplugins Reporter: Masaki Katakai <masaki>
Component: Sun Appserver 9Assignee: Nitya Doraisamy <nityad>
Status: RESOLVED DUPLICATE    
Severity: blocker CC: abadea
Priority: P3    
Version: 5.x   
Hardware: All   
OS: All   
Issue Type: DEFECT Exception Reporter:

Description Masaki Katakai 2006-10-05 14:45:58 UTC 
NB: 5.5 RC1
OS: All

When I tried to use mysql with persistence, it seems that unnecessary ":"
is listed on New Database Connection dialog.

Database URL: "jdbc:mysql://localhost:/test"

It's not correct, port number should be after ":" or ":" is not needed.

1. Setup mysql driver
2. create new connection for the driver

I set the database URL to "jdbc:mysql://localhost/test"
I didn't specify the port number in this step.

3. create web application project
4. create persistence unit, specify the new JNDI name e.g jdbc/test
   and the connection of mysql
5. create "Entity class from Database", specify the datasource "jdbc/test"

At this point, new database connection dialog is invoked. But on the dialog,
"jdbc:mysql://localhost:/test" is the default value for "Database URL",
but it's not correct so I need to correct the URL by removing ":".

I'm not sure if this bug belongs to j2ee or db. Please chnage the
component if it's not proper.
Comment 1 Andrei Badea 2006-10-09 17:08:09 UTC 
Nitya, I think this is yours.
Comment 2 Vince Kraemer 2007-02-06 22:31:16 UTC 

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