| 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: | Whole Thread | Raw Message | 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
| 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 |