叶子yeah 2015-07-15 09:59 采纳率: 100%
浏览 26942
已采纳

UncategorizedSQLException异常原因

执行一条HQL语句:select t.myApp from myPageApp t where t.sysUser.id = ? and t.recordStatus = 1 and t.myApp.recordStatus = 1 ;然后就报了org.springframework.jdbc.UncategorizedSQLException异常,什么原因导致的?查了半天了,求助。
具体报错信息:
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select deskapp1_.id as id2_, deskapp1_.apptype as apptype2_, deskapp1_.count_url as count3_2_, deskapp1_.CREATE_TIME as CREATE4_2_, deskapp1_.default_page as default5_2_, deskapp1_.depicts as depicts2_, deskapp1_.PARENT_ID as PARENT20_2_, deskapp1_.desk_icon_id as desk21_2_, deskapp1_.module_id as module22_2_, deskapp1_.ISAPP as ISAPP2_, deskapp1_.isdefault as isdefault2_, deskapp1_.isload as isload2_, deskapp1_.isresize as isresize2_, deskapp1_.NAME as NAME2_, deskapp1_.news_address as news12_2_, deskapp1_.news_height as news13_2_, deskapp1_.news_width as news14_2_, deskapp1_.page_percent as page15_2_, deskapp1_.RECORD_ORDER as RECORD16_2_, deskapp1_.RECORD_STATUS as RECORD17_2_, deskapp1_.sys_config_id as sys23_2_, deskapp1_.UPDATE_TIME as UPDATE18_2_, deskapp1_.url_address as url19_2_ from desk_page_app deskpageap0_ inner join desk_app deskapp1_ on deskpageap0_.desk_menu_id=deskapp1_.id where deskpageap0_.user_id=? and deskpageap0_.record_status=1 and deskapp1_.RECORD_STATUS=1]; SQL state [null]; error code [0]; Couldn't perform the operation prepareStatement: You can't perform any operations on this connection. It has been automatically closed by Proxool for some reason (see logs).; nested exception is java.sql.SQLException: Couldn't perform the operation prepareStatement: You can't perform any operations on this connection. It has been automatically closed by Proxool for some reason (see logs).


  • 写回答

7条回答 默认 最新

  • Evankaka 博客专家认证 2015-07-15 10:00
    关注

    SQL 查询语句异常
    把语句复制进去数据库中执行看看

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(6条)

报告相同问题?

悬赏问题

  • ¥15 DS18B20内部ADC模数转换器
  • ¥15 做个有关计算的小程序
  • ¥15 MPI读取tif文件无法正常给各进程分配路径
  • ¥15 如何用MATLAB实现以下三个公式(有相互嵌套)
  • ¥30 关于#算法#的问题:运用EViews第九版本进行一系列计量经济学的时间数列数据回归分析预测问题 求各位帮我解答一下
  • ¥15 setInterval 页面闪烁,怎么解决
  • ¥15 如何让企业微信机器人实现消息汇总整合
  • ¥50 关于#ui#的问题:做yolov8的ui界面出现的问题
  • ¥15 如何用Python爬取各高校教师公开的教育和工作经历
  • ¥15 TLE9879QXA40 电机驱动