错误日志记载

 

1.这里提示的是'classpath:/application.yml',所以找到这个文件

 结合下方给的提示信息,我们在application.xml文件中写冒号":"时,后面一个要加一个空格.

2.Field userService in cn.qqcn.user.Controller.UserController required a bean of type 'cn.qqcn.user.Mapper.UserMapper' that could not be found.这是因为在控启动类上没有添加扫描注解导致的,也就是Mapper.xml文件没有找到.

 

 

 

 

 3.是在练习JDBCExample例子的时候，出现的错误，Beans.xml文件中dataSource节点<property name="driverClassName" value="com.mysql.jdbc.Driver"/>好像是有问题，然后查了一下，可能是项目中我导入的mysql-connector-java.jar包版本不对，和自己电脑上安装的mysql（MariaDB）版本是10.3，mysql-connector-java-8.0.21.jar包是8.0的，然后我重新下载了jar包，版本是mysql-connector-java-5.0.5.jar，然后项目就正常运行了。我有点懵。。。

项目中原来导入的jar包：mysql-connector-java-8.0.21.jar

 

 修改jar包以后：

报错信息：

2021-9-18 13:59:22 org.springframework.context.support.AbstractApplicationContext prepareRefresh
信息: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@19bd03e: startup date [Sat Sep 18 13:59:22 CST 2021]; root of context hierarchy
2021-9-18 13:59:22 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
信息: Loading XML bean definitions from class path resource [Beans.xml]
2021-9-18 13:59:22 org.springframework.context.support.AbstractApplicationContext refresh
警告: Exception encountered during context initialization - cancelling refresh attempt
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [Beans.xml]: Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:
PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.UnsupportedClassVersionError: com/mysql/jdbc/Driver : Unsupported major.minor version 52.0
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1514)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1222)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:755)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
    at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
    at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)
    at com.tutorialspoint.JDBCExample.MainApp.main(MainApp.java:13)
Caused by: org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:
PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.UnsupportedClassVersionError: com/mysql/jdbc/Driver : Unsupported major.minor version 52.0
    at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:121)
    at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:75)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1510)
    ... 13 more
Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [Beans.xml]: Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:
PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.UnsupportedClassVersionError: com/mysql/jdbc/Driver : Unsupported major.minor version 52.0
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1514)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1222)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:755)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
    at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
    at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)
    at com.tutorialspoint.JDBCExample.MainApp.main(MainApp.java:13)
Caused by: org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:
PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.UnsupportedClassVersionError: com/mysql/jdbc/Driver : Unsupported major.minor version 52.0
    at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:121)
    at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:75)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1510)
    ... 13 more

 4.java.lang.IllegalMonitorStateException

生产者开始生产,第 1个产品
Exception in thread "生产者" java.lang.IllegalMonitorStateException
    at java.lang.Object.notify(Native Method)
    at 面向对象.多线程.Clerk.pruductor(ProductTest15.java:31)
    at 面向对象.多线程.Producer.run(ProductTest15.java:89)
    at java.lang.Thread.run(Thread.java:748)
消费者开始消费,第1个产品
Exception in thread "消费者" java.lang.IllegalMonitorStateException
    at java.lang.Object.notify(Native Method)
    at 面向对象.多线程.Clerk.cunsumer(ProductTest15.java:54)
    at 面向对象.多线程.Consumer.run(ProductTest15.java:117)
    at java.lang.Thread.run(Thread.java:748)

解释报错原因:

也就是当前的线程不是此对象监视器的所有者。当前线程要锁定该对象之后，才能用锁定的对象执行这些方法，这里需要用到synchronized关键字，锁定哪个对象就用哪个对象来执行notify(), notifyAll(),wait(), wait(long), wait(long, int)操作，否则就会报IllegalMonitorStateException异常。
/wangshuang1631/article/details/53815519

也就是当前的线程不是此对象监视器的所有者。当前线程要锁定该对象之后，才能用锁定的对象执行这些方法，这里需要用到synchronized关键字，锁定哪个对象就用哪个对象来执行notify(), notifyAll(),wait(), wait(long), wait(long, int)操作，否则就会报IllegalMonitorStateException异常。

5.eclipse提示:"The superclass "javax.servlet.http.HttpServlet" was not found on the Java"解决办法

就是项目没有配置tomcat的问题.

项目配置tomcat:

https://www.cnblogs.com/javaxubo/p/15418452.html

 6.org.springframework.jdbc.UncategorizedSQLException: 

### Error querying database. Cause: java.sql.SQLException: sql injection violation, syntax error: ERROR. pos 197, line 6, column 33, token LBRACE :

Caused by: com.alibaba.druid.sql.parser.ParserException: ERROR. pos 203, line 6, column 39, token LBRACE

 

7.org.springframework.jdbc.BadSqlGrammarException: 

### Error querying database. Cause: java.sql.SQLSyntaxErrorException: ORA-00904: "SD"."BUSSNO": 标识符无效

Mapper.xml文件中sql语句写错了，没有这个标识符。

 

8.报错Required String parameter 'productId' is not present的缘由及处理办法

 

9.排查了这么多次是因为自己疏忽了，没有把控制台中输出的sql语句拿到plsql中执行一下，犯了最基本的错误。

错误一：再尝试：发现自己的错误，之所以加trim，是怕表字段数据存储后面有空格。

 错误二再排除了上面错误之后，我把sql语句重新拿出来执行了（plsql）一下，发现根本就查询不出来数据。。。

原来是后面的条件没有加trim导致的。

可以查询出来了。总结了一下大概是自己写的代码，之前存储bussno的时候没有加trim，然后存储到数据库中的数据就会多出来空格，再次进行查询的时候如果sql条件如果没有使用trim的话，就查询不出数据，还有就是Mapper.xml中写的sql条件一定要加trim去除空格。

10，标识符无效的问题，就是自己代码字段名字不对，需要找一下核对。

 

11.

There is no getter for property named 'param' in 'class com.sinosoft.fis.modular.cus.model.params.BPOLLIssuePolParam'
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)

Caused by: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'param' in 'class com.sinosoft.fis.modular.cus.model.params.BPOLLIssuePolParam'

问题出现在：接口中的DataCollectMapper中出现错误

 

 顺带发现自己的实体类中表字段跟数据库中不一样，补充了一下。

 12.

  报错信息：

Application run failed

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'SendClaimsOutsourcingBL': Unsatisfied dependency expressed through field 'bpollFeeMainService'; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 'com.sinosoft.fis.modular.cus.service.BPOLLFeeMainService' available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations: {@org.springframework.beans.factory.annotation.Autowired(required=true)}
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:596)
    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:90)
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:374)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1378)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:575)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:498)
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:846)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:863)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:546)
    at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:142)
    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:775)
    at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397)
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:316)
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1260)
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1248)
    at com.sinosoft.fis.FisApplication.main(FisApplication.java:26)
Caused by: org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 'com.sinosoft.fis.modular.cus.service.BPOLLFeeMainService' available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations: {@org.springframework.beans.factory.annotation.Autowired(required=true)}
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.raiseNoMatchingBeanFound(DefaultListableBeanFactory.java:1644)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1203)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1164)
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:593)
    ... 19 common frames omitted

根据日志可以看出时BPOLLFeeMainService接口的相关的问题。我的问题是没有关于这个接口的实现类。

解决方案如下：

1) service接口实现类上有没有加@Service注解，注解是不是引用的spring的类？不要导错包

2) 接口有没有写实现类，实现类是实现的对应接口么?比如CategoryServiceImpl implementsCategoryDAO 一不小心根据自动提示，本来应该实现CategoryService,结果实现了CategoryDAO

3) 有没有扫描Service所在的包