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.
These are the steps to recreate the problem: 1. Open RC2 (wait for any project scans etc. to finish) 2. Click on Services view tab 3. expand Databases and enter Master Password 4. choose existing jdbc mysql connection to open/connect - takes 43 seconds 5. Open specific schema to list tables - takes 43 seconds 6. All database queries also take > 30 seconds to execute database server is on the same network connecting via port 3306 - machines are both quad core x64 ubuntu boxes. In NetBeans 6.9.1 exactly the same connections and actions take only a fraction of a second.
I found a partial explanation - I was using a locally defined host name 'dbserver' which was defined in my /etc/hosts file in the connection settings. When I change this to a static IP address (from the host name) to jdbc:mysql://192.168.1.50:3306/defaultschema, the connection is still very slow but opening up different schemas is almost instantaneous. So its seems almost as though the initial set up of the jdbc driver is what is aking the time. Not sure if that makes any sense? Also I customise the MySQL (Connector/JDriver) and switch the driver file from 5.1.13 back to the 5.1.6 used in NetBeans 6.9.1. the performance is perfect again. Hope this helps
Just downloaded version 7.0 stable for MacOs and the same problem is seen here. I fixed it by downloading version 5.1.16 of the DB connector from http://dev.mysql.com/downloads/connector/j/
geraint, thanks for your investigation. I'll push for upgrading MySQL Connector for up-to-date version.
Seems to work fine in NetBeans 7.2, which uses driver version 5.1.18. Please reopen if problems remain. Thank you.