Re: oracle.jdbc.driver.OracleConnection

There is *every* reason it should not be possible. First of all shutdown is a sql*plus command, it is not a sql command. You won't find it in Java nor in OCI. And that is GOOD. Because it actually means any darn idiot can shutdown the database. In my country the death penalty has been abolished a long time ago, but I'd rather not lay my hands on the guy who *did* shutdown the database using your procedures.

Regards

On Mon, 21 Jan 2002 15:20:01 -0500, chris.colclough_at_jhuapl.edu wrote:

>There is no reason that it *should not* be possible. If a database can be
>shutdown via sqlplus, it's reasonable that it could be shutdown from another
>tool. It's possible to automate a shutdown today using Java or another 3gl
>to make an o/s call to sqlplus to start and stop the database. It happens
>every day using shell scripts. The goal is to make that process more
>reliable and seamless through the use of objects. Using Java would also
>make it less o/s specific.
>
>Your thoughts...
>
>Sybrand Bakker wrote:
>
>> On Mon, 21 Jan 2002 08:53:19 -0500, chris.colclough_at_jhuapl.edu wrote:
>>
>> >Has anyone used the startup and shutdown methods of the
>> >oracle.jdbc.driver.OracleConnection class? At first blush, it appears
>> >that these methods could be used to start/stop the database. A clean
>> >method of performing a database shutdown and startup using Java is
>> >sought.
>> >
>> > Any information on performing an Oracle startup or shutdown from Java
>> >will be appreciated.
>> >
>> >Thanks,
>> >
>> >Chris
>>
>> That shouldn't be possible. PERIOD.
>>
>> Sybrand Bakker, Senior Oracle DBA
>>
>> To reply remove -verwijderdit from my e-mail address

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Jan 21 2002 - 17:19:19 CST