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