关于Spring中hibernate 回调方法执行普通sql语句的问题

代码如下

public Object execProterozoicSql(final String sql) {
  return getHibernateTemplate().execute(new HibernateCallback() {
   public Object doInHibernate(Session session)
     throws HibernateException, SQLException {         
    return session.connection().createStatement().executeQuery(sql);     
   }

  }, true);
 }

我的目的是执行普通的sql语句但是当我调用这个函数的返回对象ResultSet的时候它提示我

java.sql.SQLException: Operation not allowed after ResultSet closed
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
 at com.mysql.jdbc.ResultSet.checkClosed(ResultSet.java:644)
 at com.mysql.jdbc.ResultSet.next(ResultSet.java:6674)
 at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:168)
 at tmh.tvs.bussines.Login.log(Login.java:30)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:129)
 at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63)
 at javax.faces.component.UICommand.broadcast(UICommand.java:106)
 at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:94)
 at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:168)
 at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:343)
 at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86)
 at javax.faces.webapp.FacesServlet.service(FacesServlet.java:137)
 at org.apache.myfaces.webapp.MyFacesServlet.service(MyFacesServlet.java:74)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
 at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
 at java.lang.Thread.run(Thread.java:595)

调用代码如下

ResultSet result=(ResultSet)dm.execProterozoicSql("Select * from systemgn");
   try {
    while(result.next()){
     result.getString("gname");
    }
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }

 

评论

2 楼 tmh 2007-02-25  

解决了！自己做了个类把结果集保存到一个list中一切都好了！感谢hibernate 源程序！开始学习的时候感觉学的没用可是现在才知道基础很重要！

1 楼 tmh 2007-02-24  

大家好，请教一个问题，不知道为啥我的在hibernate的回调方法中返回一个java.sql.ResultSet并调用他的时候老是出现
java.sql.SQLException: Operation not allowed after ResultSet closed，后来看了看ResultSet的实现类的时候发现每个数据操作方法中首先要执行一个checkclose()方法。这里我也明白这个数据库连接的生命周期仅仅是在回调方法中！可是我想要返回一个类似java.sql.ResultSet结果集不知该咋做。