Re: Jave Stored Proc fails when using Socket

Closing the streams seems to make no difference. The intermittant behaviour was down to my server using non-blocking sockets (hangs head in shame).

The handle leak however, is being investigated by Oracle.

Cheers,

Rob.

On Wed, 01 Sep 1999 15:37:03 -0700, "C. Ferguson" <c_ferguson_at_rationalconcepts.com> wrote:

>Hi Rob,
> try closing your input/output streams when you are done using them.
>This may
>help your intermittant errors.
>
>regards,
>Cindy
>
>Rob Groves wrote:
>
>> All,
>>
>> I am having problems using a client Sockt from a java stored procedure
>> on Oracle 8i for NT.
>>
>> The Socket is used to send a string to a server process, which returns
>> another string. The code works intermittently, and also, seems to leak
>> handles, as the process handle count always goes up by 4 for each
>> call.
>>
>> Is this a bug, or am I doing something wrong? Code follows:
>>
>> Rob.

[SNIP] Received on Fri Sep 03 1999 - 15:27:00 CDT