Re: How to create/drop a database from Java (via JDBC)?

From: Steffen Siebert <news_at_SteffenSiebert.de>
Date: 19 Feb 2004 22:36:42 +0100
Message-ID: <ufzd621lh.fsf@SteffenSiebert.de>

>>>>> "HF" == Hans Forbrich <hforbric_at_yahoo.net> writes:

    HF> I highly suspect you are confused about the term 'Database'.
    HF> Oracle uses it to define the complete set of files related to
    HF> their RDBMS.

    HF> Many others, espcially those who have experience with SQL

HF> Server, Access, FoxPro and the like use the term database to HF> mean something similar to an Oracle SCHEMA.

HF> If you want to be able to create one of more tables, you HF> likely want to learn about schemas. And DDL.

No, I really need to create a database. Creating tables afterwards is no problem, but to create the initial database via application (java) seems to be tough with oracle. But since we were able to implement our program for MS SQL, Postgres and SAPDB, I'm still hoping that also Oracle can be tackled.

    HF> If you want to create complete Oracle databases, you are
    HF> likely going to be facing your own worst nightmare.  Those of
    HF> us who want to retain sanity tend toward using DBCA (or manual
    HF> scripts like those created by DBCA).

We can't use dbca since the database creation should be part of a unattended setup. I wasn't able to create a sql script with dbca, is the script pure sql which could be executed via jdbc?

By the way, since dbca seems to be written in java, is there a documented java api used by dbca which can be used by java developers for their own programs too?

    HF> You may also want to spend some time looking in Oracle's
    HF> extensive docco for Application Developers - it's available as
    HF> part of the database documentation for your database version,
    HF> at http://docs.oracle.com. While you are there, consider
    HF> browsing around the Concepts manual - it's worth reading
    HF> several times.

The problem of the oracle documentation is that I can't read all of it and it's hard to find out where the knowledge is hidden which I need to solve my problem. Thus my call for help here :)

Ciao,
Steffen Received on Thu Feb 19 2004 - 15:36:42 CST