Re: Notifications - Mailing list pgsql-admin

Just a final follow up to this message thread - Sun Microsystems confirm
that there is a bug with their implementation of the ssl input stream socket
in the 1.4 series JVM.

Regards
Donald Fraser

----- Original Message -----
From: "Sun Microsystems"
Sent: Friday, December 31, 2004 9:49 PM
Subject: Re: (Incident Review ID: 358430) available() method of SSLSocket
InputStream not implemented


> --- Note: you can send us updates about your Incident ---
> --- by replying to this mail.  Place new information  ---
> --- above these lines.  Do not include attachments.   ---
> --- Our system ignores attachments and anything below ---
> --- these lines.                                      ---
>
> Hi Donald Fraser,
>
> This issue is related to Bug ID: 4072863.  Thank you for providing
additional information for our investigation.
>
> You can review this bug and look for related issues on the Java Developer
Connection Bug Database at:
> http://developer.java.sun.com/developer/bugParade/
> and
> http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=4072863
>
> Bug 4072863 seems to be related to this problem, but it does not
specifically talk about SSL Sockets. However there is a very good post from
wetmore on the forums available at
> http://forum.java.sun.com/thread.jspa?forumID=2&threadID=423967 that
brings perspective to your problem.
>
> The problem related to the available method returning 0 has been discussed
in various forums. Do check the various discussion threads available in the
forums. However if you feel that this does not answer your query, please
feel free to submit a new report with any additional information you may
have.  If you send me the ID of the new incident, I will try to expedite the
reporting process.
>
> Thanks for taking the time to report this problem.
>
> Regards,
> Nelson

----- Original Message -----
From: "Donald Fraser"
To: "[ADMIN]" <pgsql-admin@postgresql.org>
Sent: Friday, December 17, 2004 1:01 PM
Subject: Re: [ADMIN] Notifications


> Hello again,
> I had to rush off to a Christmas meal last night, hence the late reply....
>
> Well today I looked extensively into the problem and discovered that the
NOTIFY
> messages are arriving outside the firewall.
> I used psql which itself connected to the database with ssl and received
its
> own NOTIFY messages ok
> .
> Looking at our software, which is java, the problem lies in the
implementation
> of receiving NOTIFY messages. It uses a separate thread to check the input
> stream of the socket for incoming data. The problem is related to ssl, the
ssl
> input stream (implemented by sun) does not appear to implement the
> "available()" method, or at least that is what I'm seeing. According to
the
> documentation the default implementation always returns 0, where as the
non-ssl
> input stream definitely does implement the "available()" method which
returns
> the number of bytes that can be read from the input stream without
blocking.
> According to sun subclasses of InputStream should implemet the
"available()"
> method. Why didn't they just make it an abstract method forcing an
> implementation - now our code is broken because of it!
>
> This will not be an easy work around....
>
> Thanks again for the input,
> regards
> Donald Fraser