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 135501 - SQLException at IDE startup
Summary: SQLException at IDE startup
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P2 blocker (vote)
Assignee: David Vancouvering
URL:
Keywords:
: 135662 (view as bug list)
Depends on:
Blocks:
 
Reported: 2008-05-21 14:30 UTC by Kirill Sorokin
Modified: 2008-07-17 16:13 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Kirill Sorokin 2008-05-21 14:30:03 UTC 
If I have a running MySQL installation with a root account with a non-empty password, I get a SQLException at IDE startup:

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:894)
        at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3808)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1256)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2032)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283)
        at org.netbeans.modules.db.mysql.util.DatabaseUtils.connect(DatabaseUtils.java:185)
Caused: org.netbeans.api.db.explorer.DatabaseException
        at org.netbeans.modules.db.mysql.util.DatabaseUtils.connect(DatabaseUtils.java:202)
        at org.netbeans.modules.db.mysql.impl.MySQLDatabaseServer$4.execute(MySQLDatabaseServer.java:410)
[catch] at org.netbeans.modules.db.mysql.impl.MySQLDatabaseServer$DatabaseCommand.run(MySQLDatabaseServer.java:705)
        at org.netbeans.modules.db.mysql.impl.ConnectionProcessor.run(ConnectionProcessor.java:79)
        at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561)
        at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986)

The IDE should degrade more gracefully, if it cannot connect to MySQL.
Comment 1 Kirill Sorokin 2008-05-21 14:31:34 UTC 
See also issue 135502.
Comment 2 Peter Pis 2008-05-21 14:47:25 UTC 
Reassigning to "db".
Comment 3 David Vancouvering 2008-05-21 15:09:00 UTC 
Good point, thanks.
Comment 4 David Vancouvering 2008-05-27 19:49:15 UTC 
*** Issue 135662 has been marked as a duplicate of this issue. ***
Comment 5 David Vancouvering 2008-05-27 22:32:04 UTC 
http://hg.netbeans.org/main?cmd=changeset;node=2221e6ea6b55
Comment 6 Exceptions Reporter 2008-05-28 08:47:48 UTC 
This issue has already 10 duplicates
Comment 7 Kirill Sorokin 2008-06-03 15:47:09 UTC 
Verified on a trunk build.
Comment 8 rbalada 2008-07-17 15:17:04 UTC 
Roman,

can you please reconsider nomination of this issue for NB 6.1 patch? The source base mentioned in the stacktrace (and
bugfix changeset) comes from significantly refactored source base introduced in changeset
http://hg.netbeans.org/main/rev/993af7de7cd1 committed on Apr 28, 2008. NetBeans 6.1 English FCS build was done on Apr
22, 2008. This source base was not part of NetBeans 6.1 release and a module built from this source base does not seem
to be offered from NetBeans 6.1 Update Centers. At this moment I see no way how to fix this for 6.1, when it apparently
is not 6.1 issue.

If you can justify bugfix for this issue should go to release61_fixes repository, then please provide a patch against
release61_fixes source base. Otherwise please change Version to 6.5, clear the keyword from Status whiteboard and remove
sustaining from Cc:.

Thanks,
-R
Comment 9 Roman Mostyka 2008-07-17 16:13:28 UTC 
If the code base wasn't in release, then I don't mind that it shouldn't be in patch 3.