亲，您未登录哦！ 登录 | 注册
首页  |  社区  |  工具箱  |  代码库  |  博客  |  招聘  |  文章  |  新闻  |  下载  |  读书
回 帖 发 新 帖 刷新版面

主题：hibernate配置c3po连接池后：无法使用jdbc查询？

zhuo002 [专家分：0] 发布于 2012-02-16 16:22:00

代码段：

PreparedStatement st = null;
            Session session = getSession();
            ResultSet rs = null;
            String sql = "select id,user_id,content,isaviable,createtime,business_info_id,overallimpression,discuss_sub_count,collection_count,read_status,forward_count from business_discusses a,( select max(id) as ids from business_discusses where isaviable = true group by business_info_id) b where a.id = b.ids  order by createtime desc LIMIT 0,10";
            List<BusinessDiscusses> list = new ArrayList<BusinessDiscusses>();
            try {
//                Transaction t = session.beginTransaction();
                st = session.connection().prepareStatement(sql);
                rs = st.executeQuery();
//                t.commit();
                UsersDAO userDao = new UsersDAO();
                
                BusinessInfoesDAO infoDao = new BusinessInfoesDAO();
                while (rs.next()) {
                    BusinessDiscusses dis = new BusinessDiscusses();
                    dis.setId(rs.getInt("id"));
                    dis.setUsers(userDao.findById(rs.getInt("user_id")));
                    dis.setBusinessInfoes(infoDao.findById(rs.getInt("business_info_id")));
                    dis.setContent(rs.getString("content"));
                    dis.setIsaviable(rs.getBoolean("isaviable"));
                    dis.setCreatetime(rs.getTimestamp("createtime"));
                    dis.setOverallimpression(rs.getInt("overallimpression"));
                    dis.setDiscussSubCount(rs.getInt("discuss_sub_count"));
                    dis.setCollectionCount(rs.getInt("collection_count"));
                    dis.setReadStatus(rs.getBoolean("read_status"));
                    dis.setForwardCount(rs.getInt("forward_count"));
                    list.add(dis);
                }
                return list;

            } catch (Exception e) {
                e.printStackTrace();
                return null;
            } finally {
                try {
                    if (rs != null) {

                        rs.close();
                    }
                    if (st != null) {
                        st.close();
                    }
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }



报错：

java.sql.SQLException: Operation not allowed after ResultSet closed
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
    at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:795)
    at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1106)
    at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2814)
    at com.mchange.v2.c3p0.impl.NewProxyResultSet.getInt(NewProxyResultSet.java:2728)
    at com.housecommunity.db.hibernate.BusinessDiscussesDAO.getBusinessDiscussesNewsTopTen(BusinessDiscussesDAO.java:422)
    at com.housecommunity.action.MyCommunityNewAction.toIndividualCentersBusiness(MyCommunityNewAction.java:648)
    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:597)
    at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
    at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
    at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)
    at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
    at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
    at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
    at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.housecommunity.util.OpenSessionInViewFilter.doFilter(OpenSessionInViewFilter.java:39)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.housecommunity.filter.AutoLoginedFilter.doFilter(AutoLoginedFilter.java:56)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:619)


大概的问题是：

在hibernate中使用jdbc查询出结果集，然后再遍历结果集中使用hibernate的findbyid方法是查询其他对象，结果就报这个错误。

高手指教
本帖地址：  http://bbs.pfan.cn/post/381576.html

回复列表 （共1个回复）

沙发

zhuo002 [专家分：0] 发布于 2012-02-16 16:23:00

错误在这句爆出来的：
dis.setBusinessInfoes(infoDao.findById(rs.getInt("business_info_id")));


c3po配置：
<!-- C3P0 data pool--> 
            <property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>    
            <property name="hibernate.c3p0.max_size">30</property>    
            <property name="hibernate.c3p0.min_size">5</property>    
            <property name="hibernate.c3p0.timeout">120</property>    
            <property name="hibernate.c3p0.max_statements">100</property>    
            <property name="hibernate.c3p0.idle_test_period">120</property>    
            <property name="hibernate.c3p0.acquire_increment">2</property>


取出c3po连接池配置则无任何错误。真奇怪。

我来回复

您尚未登录，请登录后再回复。点此登录或注册

程序员工具箱 new

  • 更多工具

    • 代码片段

  • 模拟键盘（不可按）
  • 碰撞的唐三
  • 精彩奥运热点赛事的实时采集
  • 获取天气动态信息
  • 文件查找
  • python大数据抓取京东电脑销量数据
  • 爬虫技术不仅仅支持数据采集
  • 抓取脉脉APP上的职业信息
  • 爬虫中多线程的运用
  • 四则运算以及一元二次方程
  • 欢迎来共享你的NB代码

    • 本版新帖

  • JAVA2几个问题--欢迎讨论
  • [转帖]世界编程大赛一等奖作品
  • [转帖]java新手入门
  • [转帖]成为java高手的八大条件
  • [原创]不希望以后还有关于环境变量的问题——环境变量的设置图解（新手请进）
  • [原创]JCreator 使用技巧-1
  • [原创]JCreator 使用技巧-2
  • Java程序员32问，看看你知道多少?
  • [转帖]Java入门需掌握的30个基本概念
  • [转帖]JAVA代码编写的30条建议
  • [原创]JCreator 使用技巧-3
  • [原创]刚刚共享的我的毕业设计---8个小游戏（喜欢的近来看看）
  • 初学者如何开发出一个高质量的J2EE系统
  • [转帖]全世界所有程序员都会犯的错误
  • [原创]进度条制作，让大家一起分享！