weixin_37472852的博客

解决办法：为SpringbootTest注解指定参数classes和webEnvironment，其中classes为启动类名称。@SpringBootTest(classes = OeeDemoApplication.class, webEnvironment = SpringBootTest.WebEnvironment.DEFINED_PORT)

错误详情：### The error occurred while setting parameters### SQL: select distinct device_code from item_loss_log where shift = ? and shiftDate = ?### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'shiftDate' in 'where clause'这是个低级错误，查询字段拼写错误，将shi

错误：The database URL cannot be null.通过javaconfig配置datasource时，要显式的设置url。如下： @Value("${spring.datasource.jdbc-url}") String url; @Value("${spring.datasource.username}") String username; @Value("${spring.datasource.password}") Str

mybatis批量插入时报错：syntax error, expect ‘)’是因为传入的参数list为null，在代码中加上list.size()>0的判断。

Mybatis报错：nested exception is org.apache.ibatis.builder.BuilderException: Error evaluating expression 'params.dataScope'. Cause: org.apache.ibatis.ognl.OgnlException: source is null for getProperty(null, "dataScope")。这个是mybatis对空指针异常的封装，要么检查参数是否为null，要么

mybatis报错：org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'id' in 'class java.lang.Long'xml中，sql如下：select dd.*from sys_mouldtype_device md,

报这个错是由于粘贴复制后，没有改返回值属性，如下 <select id="selectLineListByMattypeCode" parameterType="Long" resultType="SysLineResult"> select l.* from sys_materialtype_line ml, sys_dict_data dd, sys_line