• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Create a database programmatically?

 
Barry Burd
Author
Ranch Hand
Posts: 118
5
Android Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Stefan Wagner
Ranch Hand
Posts: 1923
Linux Postgres Database Scala
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Barry,

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,
Avi.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic