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.
| Summary: | Add note to the documentation about MySQL 5.0 limitation | ||
|---|---|---|---|
| Product: | usersguide | Reporter: | Roman Mostyka <romanmostyka> |
| Component: | Database | Assignee: | James Branam <jbranam> |
| Status: | VERIFIED FIXED | ||
| Severity: | blocker | CC: | hippopotame, mmirilovic, romanmostyka, sustaining, udaiibhaskar |
| Priority: | P2 | ||
| Version: | 6.x | ||
| Hardware: | All | ||
| OS: | Windows XP | ||
| URL: | http://statistics.netbeans.org/exceptions/detail.do?id=136510 | ||
| Issue Type: | DEFECT | Exception Reporter: | 136510 |
| Attachments: |
stacktrace
stacktrace |
||
Created attachment 73319 [details]
stacktrace
*** This issue has been marked as a duplicate of 152107 *** It's not duplicate. David, have you tried your fix on Windows XP? I tried on Mac OS X and everything is fine there, but on my Windows XP in Russian locale I'm constantly able to reproduce this issue. And I see changes from your changeset. Please pay more attention to this issue, it can affect Windows users. I can provide all necessary information if you need it. Build: NetBeans IDE 6.5 (Build 200811100001)
VM: Java HotSpot(TM) Client VM, 10.0-b19, Java(TM) SE Runtime Environment, 1.6.0_05-b13
OS: Windows XP, 5.1, x86
User Comments:
1. Install MySQL !!!5.0!!! server.
2. Start IDE with fresh userdir. MySQL server should be automatically registered under "Databases" node.
3. Start MySQL.
4. Rightclick MySQL server's node and choose "Create Database".
5. Set "test*1" for DB name and click "OK". Error message should appear.
6. Rightclick connection's node for those DB and choose "Delete".
Result: Exception arises.
Stacktrace:
java.lang.Exception: The database command dropDatabase failed with the following exception:
at org.netbeans.modules.db.mysql.impl.MySQLDatabaseServer$DatabaseCommand.run(MySQLDatabaseServer.java:980)
at org.netbeans.modules.db.mysql.impl.ConnectionProcessor.run(ConnectionProcessor.java:138)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)
Created attachment 74304 [details]
stacktrace
David, it's not duplicate, it's specific issue for MySQL 5.0. I tried with MySQL 5.1 and everything was fine. Therefore issue #152107 was fixed. But this specific didn't. So I marked it as Patch 2 candidate. Hi, Roman. Sorry, but this is a limitation of MySQL on Windows, and there's nothing I can do about it. On *Windows* with *MySQL 5.0* I can create databases with other character strings that need to be quoted, such as multibyte Japanese characters and 'test-1' and 'test 1' but 'test*1' fails not only within NetBeans but also from the MySQL command line: mysql> create database `test*1`; ERROR 1006 (HY000): Can't create database 'test*1' (errno: 22) I understand. Then I think we should have some note about this in documentation. I've changed summary and subcomponent. James, can we have note about MySQL 5.0 limitation in documentation? Or you think it isn't in our scope? If not, then please close this issue. Thanks. This information will be added. The issue hasn't passed the nomination process for 65patch2 by cut-off date. It has been moved to 65patch3. I added the following note to the topic. Note: When using MySQL 5.0 with Windows, some foreign characters may not be used when creating a database. v. http://hg.netbeans.org/main/rev/1279ff8f53d8 James, could you please proceed with porting this bugfix into release65_fixes clone ? http://wiki.netbeans.org/NetBeans6.5.1BugFixes Thanks in advance. Fixed in release65_fixes v. |
Build: NetBeans IDE Dev (Build 081105) VM: Java HotSpot(TM) Client VM, 11.0-b13, Java(TM) SE Runtime Environment, 1.6.0_10-rc-b26 OS: Windows XP, 5.1, x86 User Comments: romanmostyka: 1. Start MySQL server. 2. Rightclick it's node, choose "Creata Database..." and enter "test*1" for database name. Result: Exception arises. Stacktrace: java.lang.Exception: The database command createDatabase failed with the following exception: at org.netbeans.modules.db.mysql.impl.MySQLDatabaseServer$DatabaseCommand.run(MySQLDatabaseServer.java:981) at org.netbeans.modules.db.mysql.impl.ConnectionProcessor.run(ConnectionProcessor.java:144) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:573) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1005)