This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DSRA9110E: Statement is closed

 
sachin burange
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
While running the job this error occurs randomely.
I am not able to understand why it behves randomely.
connection object is taken from connction pool.

try {
conn_rsweb = rsUtilDBConnections.getRsWebConnection();
stmt_rsweb = conn_rsweb.createStatement();
String sql1 = "query";
try
{
//Here it gives error
rs_rsweb = stmt_rsweb.executeQuery(sql1);
}
catch (SQLException sqe)
{
rs_rsweb = stmt_rsweb.executeQuery(sql1);
}
}catch(Exception e) {}
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is frequencey of your job ?

Since you have not posted complete code I just want to know if statement is a class level variable ? where are you closing resultset/statement once your task is complete

Shailesh
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic