執行一條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).
SQL 查詢語句異常
把語句復制進去數據庫中執行看看