Re: ExecSQL NullPtrEx...conn timeout? - Mailing list pgsql-general

From Peter T Mount
Subject Re: ExecSQL NullPtrEx...conn timeout?
Date
Msg-id 986217748.3ac87d14c76b3@webmail.retep.org.uk
Whole thread Raw
In response to ExecSQL NullPtrEx...conn timeout?  ("chris markiewicz" <cmarkiew@commnav.com>)
List pgsql-general
Quoting chris markiewicz <cmarkiew@commnav.com>:

> i am seeing NullPtrExs with the following stack trace:
>
> java.lang.NullPointerException
> at org.postgresql.Connection.ExecSQL(Connection.java:312)
> at org.postgresql.jdbc2.Connection.commit(Connection.java:173)
> at
> com.commnav.sbh.framework.persist.JDBCConnection.disconnect(JDBCConnection.j
> ava:416)
> at
> com.commnav.sbh.framework.persist.ConnectionPoolImpl.expire(ConnectionPoolIm
> pl.java:245)
> at com.commnav.sbh.framework.ObjectPool.clean(ObjectPool.java:178)
> at com.commnav.sbh.framework.ObjectPool.run(ObjectPool.java:330)
> at java.lang.Thread.run(Thread.java:484)
>
> Our object pool disconnects unused open connections every few minutes.
> Do the connections themselves timeout?  is this a parameter somewhere?  I
> am wondering if I am trying to close a connection that is already closed?

It's possible but it shouldn't occur. I'll check.

As for the connections timing out, AFAIK no.

> please respond directly to me - i'm not in the jdbc group.

Due to the amount of emails I get I'll be dropping general soon (600+ in the
last 24hrs is a tad too many now), so it's best to join it.

Peter

--
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/

pgsql-general by date:

Previous
From: Peter T Mount
Date:
Subject: Re: [JDBC] Logging Queries
Next
From: Tom Lane
Date:
Subject: Re: pg_dump -s puts out SETVAL lines