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 Creating Database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Creating Database" Watch "Creating Database" New topic
Author

Creating Database

Chiranjeevi Kanthraj
Ranch Hand

Joined: Feb 18, 2008
Posts: 290

Hi i am using Mysql database.

I need to create the database from my java application.

is their any way?

Please give some inputs how i can do that?


-Chiru
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 40052
    
  28
A trip to the Java Tutorials is called for
Chiranjeevi Kanthraj
Ranch Hand

Joined: Feb 18, 2008
Posts: 290

Sorry if i am not asking question properly.

i want to create the database, like what we use the query in Mysql as "Create data base XXXXX" like that is their any way to run this query with out having any database in Mysql.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 40052
    
  28
As far as I know you can pass "create database if not exists chirus_database" as a statement with the java.sql.Statement#execute or java.sql.Statement#executeUpdate methods.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 40052
    
  28
You might need to specify your Statement as updatable type when you create it from the Connection.
Chiranjeevi Kanthraj
Ranch Hand

Joined: Feb 18, 2008
Posts: 290

Thank you this is what i am expecting..
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 40052
    
  28
Originally posted by Chiru Raj:
Thank you this is what i am expecting..
You're welcome
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Creating Database