Re: Error message - Mailing list pgsql-jdbc

From Nick Fankhauser
Subject Re: Error message
Date
Msg-id NEBBLAAHGLEEPCGOBHDGMENEEBAA.nickf@ontko.com
Whole thread Raw
In response to Error message  ("Nikola Milutinovic" <Nikola.Milutinovic@ev.co.yu>)
List pgsql-jdbc
This sounds a lot like your servlets (JSPs) trying to access a connection or
other JDBC object that no longer exists. Using Tomcat, I get a similar error
message if I do something to invalidate my connection pool (like reloading a
Tomcat context) & then try to close a connection. Is it possible that
something is happening that causes one of your "close" actions to execute
twice?

BTW, an off-topic but related bit of info is that on v3.2 of Tomcat, class
dependency issues still aren't resolved satisfactorily. Tomcat at least
makes an effort to reload dependent classes when you compile a replacement,
but often reloads classes that shouldn't have been affected. This means that
simply compiling a servlet could make your current connection instance for
JDBC go away. We've taken to reloading the context or restarting Tomcat
every time we do a make, and giving each developer her/his own context to
work in so a compile won't affect others.

I'm not sure if this issue has been resolved in Tomcat 4.

-Nick

--------------------------------------------------------------------------
Nick Fankhauser  nickf@ontko.com  Phone 1.765.935.4283  Fax 1.765.962.9788
Ray Ontko & Co.     Software Consulting Services     http://www.ontko.com/



> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Nikola Milutinovic
> Sent: Wednesday, December 26, 2001 7:50 AM
> To: PostgreSQL JDBC
> Subject: [JDBC] Error message
>
>
> Hi all.
>
> I'm connecting from my JSP/Servlets to PostgreSQL. I keep getting
> this error message from postmaster:
>
> pq_recvbuf: unexpected EOF on client connection
>
> The JSP page does the following:
>
> - get connection
> - create statement
> - execute query
> ...
> - close ResultSet
> - close Statement
> - close Connection
>
> I'm using pgsql-jdbc-7.1-1.2
>
> Could this be from my explicit closing the JDBC objects?
>
> Nix.
>


pgsql-jdbc by date:

Previous
From: "Nikola Milutinovic"
Date:
Subject: Error message
Next
From: Justin Clift
Date:
Subject: Re: Remember to register PostgreSQL for JDJ 2002 awards (fwd)