Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Unable to materialize as string ERROR

 
Jigar Naik
Ranch Hand
Posts: 762
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 762
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
this is how i'm using conn in my code,,,



and whats connection pulling ???
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic