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

From: Hans Forbrich <hforbric_at_yahoo.net>
Date: Fri, 20 Feb 2004 00:13:38 GMT
Message-ID: <SicZb.26167$n17.992@clgrps13>

Steffen Siebert wrote:

>>>>>>"D" == DJ  <nospamplease_at_goaway.com> writes:

>
>
> D> hmm yeah - didnt think hard enough really, can java fork out to
> D> a shell and run OS commands?
>
> Yes of course. But I would prefer a native java solution, which is
> likely to exist since oracle's dbca is written in java :)
>
> D> But it needs to be asked 'why'
>
> Because our java soft needs to be installed on several platforms with
> several database systems. So we wrote a java program which creates
> the database for our application on MS-SQL, Postgres and SAPDB. And
> now we also need oracle support.
>
> (Is 'why' really a question a programmer is allowed to ask? ;)
>
> Ciao,
> Steffen
>

Look closely at DBCA and I think you'll find it just creates the script   and passes it to the OS. I believe the actual work is done in SQLPlus, using the SQLPlus Admin mode.

This still does not answer the larger question - where is the actual Oracle software needed to run the resulting database (and SQLPlus). Or do you have to worry about the complete install?

And yes, a GOOD programmer wil always ask WHY in order to propose cost effective alternatives, if there are any. Otherwise any VB programmer would do <g>.

/Hans Received on Thu Feb 19 2004 - 18:13:38 CST