SQL: SELECT t.contractid,t.barcode,t.createtime,t.type,r.name AS retailer_name FROM contract t LEFT JOIN retailer r ON t.retailerid = r.retailerid WHERE 1=1 LIMIT ?,?
Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ‘t.retailerid’ in ‘on clause’
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: j**a.sql.SQLException: You can't operate on a closed Connection!!!
### The error may exist in file [D:\IDEworkspace\IntelliJ IDEA\BSIMS\target\BSIMS\WEB-INF\classes\com\cjy\mapper\UserMapper.xml]
### The error may involve test.findUserByName
### The error occurred while executing a query
### SQL: SELECT * FROM user WHERE name LIKE ?
### Cause: j**a.sql.SQLException: You can't operate on a closed Connection!!!
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.j**a:1013)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.j**a:908)
j**ax.servlet.http.HttpServlet.service(HttpServlet.j**a:660)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.j**a:882)
j**ax.servlet.http.HttpServlet.service(HttpServlet.j**a:741)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.j**a:53)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.j**a:200)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.j**a:107)
org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: j**a.lang.ClassCastException: j**a.util.Date cannot be cast to j**a.sql.Date
### The error may involve testMybatis.testHandler-Inline
### The error occurred while setting parameters
### SQL: insert into USER(username,password,gender,email,province,city,birthday) values(?,?,?,?,?,?,?)
### Cause: j**a.lang.ClassCastException: j**a.util.Date cannot be cast to j**a.sql.Date
Caused by: j**a.lang.ClassCastException: j**a.util.Date cannot be cast to j**a.sql.Date
at cn.com.Mybatis.DateTypeHandler.setParameter(DateTypeHandler.j**a:1)
SQL: SELECT t.contractid,t.barcode,t.createtime,t.type,r.name AS retailer_name FROM contract t LEFT JOIN retailer r ON t.retailerid = r.retailerid WHERE 1=1 LIMIT ?,?
Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ‘t.retailerid’ in ‘on clause’
前面有一些小问题都解决了但是这个ContractMapper里的SQL语句反复改了还是一直报错,把 contract t加了括号还是一样的
用的MySQL5.6,求教该怎么改才能运行
作者您好!我在书中第16章搭建框架并测试的时候一直出现这样一个错误,不知道该如何解决,能否请您帮忙看一下:
虽然是springboot的时代了,不过这本书还是可以看看学习一下,了解一下最开始是什么样的
第51页自定义typeHandlers代码,自定义日期转换Handler,按照书上的代码编写之后,日期转换不成功,哪位大神帮忙解答一下为什么?是类里面少写了处理方法还是配置不全?有没有和我遇见同样问题的仁兄?
书中有很多小错误,不过还是可以接受,整体内容如果能再细致一点就更好了,如果加入一些切面的内容,运用到最后的项目中就好了。