This week's book giveaway is in the Cloud/Virtualizaton forum.
We're giving away four copies of Mesos in Action and have Roger Ignazio on-line!
See this thread for details.
Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How 2 create a new DB with MySQL and JDBC

 
henry iguaro
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 15302
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic