File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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
Bookmark "How 2 create a new DB with MySQL and JDBC" Watch "How 2 create a new DB with MySQL and JDBC" New topic
Author

How 2 create a new DB with MySQL and JDBC

henry iguaro
Greenhorn

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: 15286
    
    6

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 - A Test Data Generation Platform
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How 2 create a new DB with MySQL and JDBC
 
Similar Threads
Database Daemon Connection
Converting an application to Java (new to Java)
Connecting to MySQL locally via JNDI
Integrate Eclipse and mysql
NX: (HTL) FileChannel & Threads