Hi All,

Iam getting following exception while trying to fetch data.
Please help me to fix the issue ASAP...

com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after statement closed.

Here's the code FYR
------------------------
Connection connection=getSession().connection();
for(String content:contents){
String query="select max(execute_time) as tim,count(execute_flag),(SELECT COUNT(1) FROM "+content+"_content ) as sCount" +
" from "+content+"_content where execute_flag=1; ";
System.out.println("Query:"+query);
statement=connection.prepareStatement(query);
resultSet=statement.executeQuery();
logBean=new ServiceLogBean();
while(resultSet.next()){
if(resultSet.getString(1)!=null)
logBean.setLastExecuteTime(resultSet.getString(1).substring(0,resultSet.getString(1).length()-2));
logBean.setRecordsSent(resultSet.getInt(2));
logBean.setTotalRecords(resultSet.getInt(2));
logBean.setRecordsInQueue(resultSet.getInt(2)-resultSet.getInt(2));
logBean.setServiceName(content);
}
list.add(logBean);
}

Wrong forum. This type of question should be asked on the "Hibernate Users" forums.
Also have a look on how to report an issue - https://www.hibernate.org/160.html. It's pretty hard to decrypt your problem from your post.