스프링부트 mybatis 연동 시 UnsatisfiedDependencyException: Error creating bean with name 에러 뜨는 현상 질문합니다 ㅠㅠ

Question

안녕하세요. springboot로 myBatis 세팅하는 과정에서 아래 오류가 생겨 질문드립니다...아래와 같이 자꾸 boardServiceImpl과 boardMapper, sqlSessionFactory빈 생성이 안된다고 합니다.두 파일 모두 @Service, @Mapper 어노테이션 선언 해주었고 MybatisConfig.java파일에 sqlSessionFactory 빈을 생성시켜주었습니다. 계속 구글링 해봐도 해당 오류가 없어서 여쭤봅니다. 도대체 이유를 모르겠씁니다ㅠㅠ의심되는 부분이라도 알려주시면 감사하겠습니다ㅜㅜ!!! 부탁드립니다ㅠㅠorg.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'boardServiceImpl': Unsatisfied dependency expressed through field 'boardMapper': Error creating bean with name 'boardMapper' defined in file [C:\project_my\worksapce\Spring_my arget\classes\com\example\spring_my\board\serviceImpl\BoardMapper.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory': Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/example/spring_my/MyBatisConfig.class]: Failed to instantiate [org.mybatis.spring.SqlSessionFactoryBean]: Factory method 'sqlSessionFactory' threw exception with message: org/springframework/core/NestedIOException at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:712) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:692) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:133) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:481) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1397) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:598) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:521) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:961) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:915) ~[spring-context-6.0.4.jar:6.0.4] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:584) ~[spring-context-6.0.4.jar:6.0.4] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) ~[spring-boot-3.0.2.jar:3.0.2] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:730) ~[spring-boot-3.0.2.jar:3.0.2] at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:432) ~[spring-boot-3.0.2.jar:3.0.2] at org.springframework.boot.SpringApplication.run(SpringApplication.java:308) ~[spring-boot-3.0.2.jar:3.0.2] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1302) ~[spring-boot-3.0.2.jar:3.0.2] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1291) ~[spring-boot-3.0.2.jar:3.0.2] at com.example.spring_my.SpringMyApplication.main(SpringMyApplication.java:12) ~[classes/:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[na:na] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na] at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na] at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) ~[spring-boot-devtools-3.0.2.jar:3.0.2]Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'boardMapper' defined in file [C:\project_my\worksapce\Spring_my arget\classes\com\example\spring_my\board\serviceImpl\BoardMapper.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory': Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/example/spring_my/MyBatisConfig.class]: Failed to instantiate [org.mybatis.spring.SqlSessionFactoryBean]: Factory method 'sqlSessionFactory' threw exception with message: org/springframework/core/NestedIOException at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1494) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1388) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:598) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:521) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1405) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1325) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:709) ~[spring-beans-6.0.4.jar:6.0.4] ... 25 common frames omittedCaused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/example/spring_my/MyBatisConfig.class]: Failed to instantiate [org.mybatis.spring.SqlSessionFactoryBean]: Factory method 'sqlSessionFactory' threw exception with message: org/springframework/core/NestedIOException at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:657) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:645) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1324) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1161) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:561) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:521) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1405) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1325) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1479) ~[spring-beans-6.0.4.jar:6.0.4] ... 36 common frames omittedCaused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.mybatis.spring.SqlSessionFactoryBean]: Factory method 'sqlSessionFactory' threw exception with message: org/springframework/core/NestedIOException at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:171) ~[spring-beans-6.0.4.jar:6.0.4] at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:653) ~[spring-beans-6.0.4.jar:6.0.4] ... 49 common frames omittedCaused by: java.lang.NoClassDefFoundError: org/springframework/core/NestedIOException at com.example.spring_my.MyBatisConfig.sqlSessionFactory(MyBatisConfig.java:55) ~[classes/:na] at com.example.spring_my.MyBatisConfig$$SpringCGLIB$$0.CGLIB$sqlSessionFactory$0() ~[classes/:na] at com.example.spring_my.MyBatisConfig$$SpringCGLIB$$2.invoke() ~[classes/:na] at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:258) ~[spring-core-6.0.4.jar:6.0.4] at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331) ~[spring-context-6.0.4.jar:6.0.4] at com.example.spring_my.MyBatisConfig$$SpringCGLIB$$0.sqlSessionFactory() ~[classes/:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[na:na] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na] at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na] at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:139) ~[spring-beans-6.0.4.jar:6.0.4] ... 50 common frames omittedCaused by: java.lang.ClassNotFoundException: org.springframework.core.NestedIOException at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641) ~[na:na] at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188) ~[na:na] at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:520) ~[na:na] ... 61 common frames omittedProcess finished with exit code 0<파일 경로>

blgrm · Answer

안녕하세요제 눈에 보이는 것들 몇가지 적어볼께요 우선 굵은 글자만 보고 적용해보신 후, 동작이 된다면 천천히 읽어보시면 될 거같아요 해결이 되길 바랍니다mybatis-config.xml > properties > resource 속성값classpath:/ 를 지우시고 application.properties 라고만 적어보세요classpath: 라는 접두어로 리소스를 불러오는 것은 spring 컨테이너가 제공하는 기능중 하나 입니다. mybatis 는 spring 종속적인 기술은 아니기 때문에 해당 접두어로 리소스를 불러오지 못할 수 있습니다. 좀더 알아보고 싶으시면 나중에 spring resource 추상화 라고 검색해서 알아보세요mybatis-config.xml > typeAliases > typeAliastype 속성에는 매퍼 xml 파일의 결과가 매핑될 dto 클래스 경로 전체를 적어주시고, alias 에는 원하시는 약어를 적어주세요 ex) type&#61;&#34;com.example.spring_my.board.service.BoardDto&#34; alias&#61;&#34;boardDto&#34;이후에 mapper xml 파일의 resultType 에 정의하신 전체경로가 아닌 alias 명을 적어주시면 됩니다mybatis-config.xml > environments > ... > datasource우선 environments 를 전체 주석처리 해보세요${key} 형태로 값을 넣으시려고 하셨는데 글에 안 적으신 건지 해당 키에 대한 설정이 보이질 않네요${key} 형태로 값을 넣는 것은 해당 값들을 별도 파일들에서 불러오기 위함이에요. 별도 파일인 application.properties 파일을 불러오셨는데 해당 파일에 해당 key&#61;value 가 있는지 확인해보세요environments 설정은 개발,운영 등 여러 환경별로 datasource 가 다르거나 여러가지 datasource 를 사용하는 경우를 대처하기 위해 제공되는 기능입니다아마 지금은 단일 환경, 단일 database 일테니 MybatisConfig 에서 이미 설정한 것으로도 동작할거에요 (factoryBean.setDatasource)mybatis-config.xml > mappers > mapper우선 mappers 태그 전체를 주석처리 하세요경로를 적는 방식이 잘못됬어요. 아래 글을 읽어보세요 https://mybatis.org/mybatis-3/ko/configuration.html#mappers이미 MybatisConfig 클래스에서 이미 정의하셨습니다. 별도로 추가할 필요가 없어보입니다 (factoryBean.setMapperLocations) 여러가지 글을 참고하셔서 그런지 설정 값들이 중복이 되는 경우가 보이는데, 우선순위대로 설정이 덮어씌워 질 거기 때문에 동일한 설정이라면 지금은 문제가 되지 않을 꺼에요하지만 나중에라도 의도하신 부분을 제외하고는 중복된 설정을 제거 하시기를 추천드려요. (나중에 설정을 바꿨는데 왜 적용이 안되는지 파악이 어려워질 수 있어요)

antop · Answer

에러 메세지 자체는 &#34;spring-core 모듈에 NestedIOException 클래스가 없습니다.&#34; 입니다.메이븐(or 그래들) 소스는 없어서 모르겠으나..스프링 버전과 마이바티스 버전이 안맞는거 같습니다.스프링 부트 3 (스프링 6) &#43; mybatis-spring 3 조합이나스프링 부트 2 (스프링 5) &#43; mtbatis-spring 2 조합으로 해야 할 것 같습니다.

스프링부트 mybatis 연동 시 UnsatisfiedDependencyException: Error creating bean with name 에러 뜨는 현상 질문합니다 ㅠㅠ

2개의 답변

#sqlsessionfactory 목록