Unable to materialize as string ERROR

[Jigar Naik]

STDOUT] *** SERVLET : listAgent.do ***
16:08:04,421 INFO [STDOUT] GET_FILED_FOR_AHT : com.mysql.jdbc.ServerPreparedStatement[1] - Select a_id,TIMESTAMPDIFF(SECOND,start_time,resp_ts) from chat where DATE_FORMAT(start_time,'%e/%c/%Y')=DATE_FORMAT(now(),'%e/%c/%Y')
16:08:04,437 INFO [STDOUT] GET_FILED_FOR_AHT : com.mysql.jdbc.ServerPreparedStatement[1] - unable to materialize as string due to underlying SQLException: java.sql.SQLException: Connection is closed.
16:08:10,234 INFO [STDOUT]

hi,

my code/query is working fine... but i'm getting following error on conseole...

[Jeanne Boyarsky]

Jigar.
The error message says the connection is closed. So that's probably the place to look. Are you using connection pooling? How long is the connection open? Can you post some code?

[Jigar Naik]

this is how i'm using conn in my code,,,

  
Class.forName(connectionClass);
Connection conn = DriverManager.getConnection(connectionName);
PreparedStatement ps = conn.prepareStatement(QueryConstants.INSERT_CHAT);
lgr.info("DATE ERROR HERE : " + chatbean.getStartTime());
//start_time,chat_dept,queue,title,customer
ps.setInt(1,chatbean.getDept_id());
ps.setString(2,chatbean.getTitle());
ps.setString(3,chatbean.getCustomer());
ps.setString(4,db_date);
lgr.info("INSERT_CHAT : " + ps);
ps.executeUpdate();
lgr.info("INSERT_CHAT : " + ps);
ps.close();
conn.close();

and whats connection pulling ???