NullPointerException while closing connection with connectionpool
От | Jani Virta |
---|---|
Тема | NullPointerException while closing connection with connectionpool |
Дата | |
Msg-id | 3EBA0FC9.6050308@kortis.to обсуждение исходный текст |
Ответы |
Re: NullPointerException while closing connection with
Re: NullPointerException while closing connection with |
Список | 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
В списке pgsql-jdbc по дате отправления: