File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes How 2 create a new DB with MySQL and JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "How 2 create a new DB with MySQL and JDBC" Watch "How 2 create a new DB with MySQL and JDBC" New topic

How 2 create a new DB with MySQL and JDBC

henry iguaro

Joined: Oct 10, 2003
Posts: 1
In my project, a requirement is to search if the database exists, if not, the program must create it... I've wrote a generic abstract class that creates a db, i've called DBCreator, then subclasses have the work of create the particular dbase using "CREATE table" SQL sentences... Ok, all of this works, but only if the database exists and has an Url...
Class.forName(driver); //<-- OK
connection = DriverManager.getConnection(url); // No OK
The cuestion is:
How i can create a new database from my application, using MySQL and get the connection to it?
Adios and Thanks
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15302

One of the problems you are going to have is there is no way to connect to the Database without providing a DB name in the URL as you pointed out. The only way I can suggest you make this work is you can always count on 1 Database being in a MySQL database. It's called mysql. This database actually stores users and permissions, metadata, etc for MySQL. So you can just connect to this database in the initial URL if need be. Keep in mind, allowing your application to connect to this database could be a security risk.

GenRocket - Experts at Building Test Data
I agree. Here's the link:
subject: How 2 create a new DB with MySQL and JDBC
It's not a secret anymore!