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 Create a database programmatically? 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 "Create a database programmatically?" Watch "Create a database programmatically?" New topic

Create a database programmatically?

Barry Burd
Ranch Hand

Joined: Jun 18, 2003
Posts: 118

Once you've created a database in your native operating system, you can add tables and make other changes with JDBC. But is there a way to create the database itself (other than an in-memory database)? Thanks.

Java For Dummies, 6th Edition, Java Programming for Android Developers For Dummies
Stefan Wagner
Ranch Hand

Joined: Jun 02, 2003
Posts: 1923

With postgres, you have a command-line interface (on linux), and can call 'Runtime...' to create a new DB.
But perhaps using ...

will work too.
Did you try something like that?
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1141


with JDBC ... is there a way to create the database itself

That depends on the definition of database that your [O|R]DBMS is using. In my experience, working with Informix and Oracle, one does allow it (Informix) while the other does not. This is because Oracle equates a "database" with Informix's notion of an "instance", whereas Oracle's definition of a "schema" is parallel to Informix's idea of a database.
So, in conclusion, it depends on the DBMS you are using. Unfortunately I couldn't find that detail in your post, so I can't really answer your question, can I?
Good Luck,
I agree. Here's the link:
subject: Create a database programmatically?
jQuery in Action, 3rd edition