NullPointerException while closing connection with connectionpool

From: Jani Virta <jani(dot)virta(dot)news(at)kortis(dot)to>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: NullPointerException while closing connection with connectionpool
Date: 2003-05-08 08:05:29
Message-ID: 3EBA0FC9.6050308@kortis.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I have multiple threads writing log to db and once a while I get this
error message, with a result of one connection freezing to "idle in
transaction" state.

java.lang.NullPointerException
at
org.postgresql.jdbc2.optional.PooledConnectionImpl$ConnectionHandler.invoke(PooledConnectionImpl.java:230)
at $Proxy0.close(Unknown Source)
at config.logadd(config.java:154)

driver is latest (7.3 jdbc3 build 109)
jvm is sun j2re 1.4.1_02 with redhat 9
code I'm using for writing logs. Line 154 is conn.close();

static public void logadd(String s) {
try {
Connection conn = datasource.getConnection();
String insert="INSERT INTO log (time, entry) VALUES ((SELECT
CURRENT_TIMESTAMP), '"+s+"')";
Statement logstmt = conn.createStatement();
logstmt.executeUpdate(insert);
logstmt.close();
conn.close();
} catch (SQLException e) {
System.out.println("Tried to write : "+s+"\nlog write
failed. exception "+e);
}
}

Any thoughts? Looks like a threading problem since this happens until I
have max number of connections open and all but one connection in "idle
in transaction" state.

-jani

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2003-05-08 12:37:15 Re: NullPointerException while closing connection with
Previous Message Dave Cramer 2003-05-08 02:11:35 Re: getLastUID() In pgsql JDBC