Re: java stored procedure

From: the spammers have won :-( <"the>
Date: Wed, 05 Nov 2003 06:28:51 +0200
Message-ID: <3fa87cf0$1@news.012.net.il>

Sybrand Bakker wrote:
> "thomas" <t.beetz_at_web.de> wrote
>

>> i don't use connection.close() in my java stored procedures is this
>>okay or will this become a problem.

>
> It will become a problem soon.
> Even if you take measures on the server side it while take a big while
> having them cleaned up.
> One of the main tasks of the DBA is to take counter-measures against sloppy
> programming. This is clearly a symptom of sloppy programming.

But if the "Connection" that Thomas uses, in his java stored procedure, is the default connection, then, according to the Oracle documentation, he must not close it. And if Thomas is not using the default connection in his java stored procedure, then I recommend that he use it (instead of the connection he is using now).

Good Luck,
Avi. Received on Tue Nov 04 2003 - 22:28:51 CST