首页 新闻 会员 周边 捐助

急!!求大神解答mysql错误Prepared statement needs to be re-prepared

0
悬赏园豆:50 [已解决问题] 解决于 2014-04-01 13:08

该错误时有时无,sql语句放到mysql中执行没有问题,求大神们帮忙解答?谢谢了!!

org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select b.name productName,c.jiangejianxiu,a.oceanGeo location,a.burOrLease burOrLease,a.id fiexdId,e.batchStartupCost needMoney,e.workstationNumnitPrice needPeopleNum,e.minStaffAbilitySum needAbilityNum,e.id productLineId,d.thingsName thingsName,ifnull(c.status,'安装') status1,ifnull(c.num,0) num1,ifnull(c.num,0) numBasic1 from BES_FixedAssets a left join bes_thingsTemplate d ON d.id = a.thingsId join BES_ProductLineTemplate e ON e.id = a.beanId join ORG_ProductLineStatus c ON a.id = c.productLineId join bes_productTemplate b ON b.id = c.productId where a.status = '已激活' and thingsType = '生产线' and useOrgId = ? order by a.oceanGeo;]; SQL state [HY000]; error code [1615]; Prepared statement needs to be re-prepared; nested exception is java.sql.SQLException: Prepared statement needs to be re-prepared

小骸的主页 小骸 | 初学一级 | 园豆:141
提问于:2014-02-25 11:30
< >
分享
最佳答案
0

你是不是mysql的服务没打开,在安装文件夹里找mysqlnt.exe 打开关闭
进入命令行切换当前安装目录命令:mysql -u root -p
输入密码:默认空,直接回车或者去到服务里将mysql的服务设为自动

 

安装文件夹里

mysqlnt.exe 打开

关闭


进入命令行

切换

当前安装目录

命令:mysql -u root -p
输入密码:默认

空,直接回车
收获园豆:50
看不见故乡 | 菜鸟二级 |园豆:252 | 2014-03-12 11:17
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册