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 150769 - [65cat] Exception: The database command dropDatabase failed with the following exception:
Summary: [65cat] Exception: The database command dropDatabase failed with the followin...
Status: RESOLVED WORKSFORME
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P4 blocker (vote)
Assignee: Libor Fischmeistr
URL: http://statistics.netbeans.org/except...
Keywords:
Depends on:
Blocks:
 
Reported: 2008-10-20 20:31 UTC by sunbiz
Modified: 2015-02-04 03:24 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Exception Reporter: 131164

Attachments
stacktrace (2.47 KB, text/plain)
2008-10-20 20:31 UTC, sunbiz 		Details
stacktrace (2.47 KB, text/plain)
2008-10-27 17:59 UTC, sunbiz 		Details
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 sunbiz 2008-10-20 20:31:09 UTC 
Build: NetBeans IDE Dev (Build 200810171401)
VM: Java HotSpot(TM) Client VM, 11.0-b15, Java(TM) SE Runtime Environment, 1.6.0_10-rc2-b32
OS: Windows Vista, 6.0, x86

User Comments:
sunbiz: Creating database with semicolon (;) threw this exception



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:976)
        at org.netbeans.modules.db.mysql.impl.ConnectionProcessor.run(ConnectionProcessor.java:111)
        at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
        at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)
Comment 1 sunbiz 2008-10-20 20:31:15 UTC 
Created attachment 72306 [details]
stacktrace
Comment 2 David Vancouvering 2008-10-23 20:33:44 UTC 
Can you explain what you mean by "creating database with semicolon"?  Do you mean the db name had a semicolon?
Comment 3 sunbiz 2008-10-23 20:35:40 UTC 
davidvc:>> yes, db name had semicolon
Comment 4 sunbiz 2008-10-27 17:59:11 UTC 
Build: NetBeans IDE Dev (Build 200810240201)
VM: Java HotSpot(TM) Client VM, 11.0-b15, Java(TM) SE Runtime Environment, 1.6.0_10-rc2-b32
OS: Windows Vista, 6.0, x86

User Comments: 
Right-click on registered MySQL Server and press Create Database. Pressed OK without adding any name and we get the exception

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:976)
        at org.netbeans.modules.db.mysql.impl.ConnectionProcessor.run(ConnectionProcessor.java:111)
        at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
        at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)
Comment 5 sunbiz 2008-10-27 17:59:15 UTC 
Created attachment 72706 [details]
stacktrace
Comment 6 David Vancouvering 2008-10-27 18:10:50 UTC 
OK.  A semicolon is not a supported character for object names. The standard characters are A-Z, a-z and _.  If you want
a semicolon in your database name, you need to quote it when you create it.  I'm still not sure if that will work, but
it's worth a try.

Any particular reason why you want a semicolon in your db name?  It seems a bit odd... :)
Comment 7 sunbiz 2008-10-27 18:39:39 UTC 
If the database name is kept blank, it kind of throws a similar exception. As for the semicolon in the database name, 
it was a entry error, but I'm sure we could validate the create database testfield a little better.
Comment 8 David Vancouvering 2008-10-28 05:21:22 UTC 
Fair enough, but this is not a P3...
Comment 9 Jiri Rechtacek 2009-07-01 07:57:20 UTC 
Reassigned to new owner.
Comment 10 Quality Engineering 2015-02-04 03:24:48 UTC 
Reported for 7.3.x or earlier, no new info since then -> closing as worksforme, please reopen in case you see it.