IDEA 启动 Error creating bean with name 'sqlSessionFactory' defined in class path resource [spring-m

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [spring-mybatis.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\smartCity\flatformUser\server\platform\platformUser\target\platformUser\WEB-INF\classes\sqlmap\UserMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving JdbcType. Cause: java.lang.IllegalArgumentException: No enum constant org.apache.ibatis.type.JdbcType.VARCH AR
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:753)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4853)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5314)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:753)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:729)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
at org.apache.catalina.startup.HostConfig.manageApp(HostConfig.java:1733)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:300)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801)
at org.apache.catalina.mbeans.MBeanFactory.createStandardContext(MBeanFactory.java:484)
at org.apache.catalina.mbeans.MBeanFactory.createStandardContext(MBeanFactory.java:433)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:300)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801)
at javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1468)
at javax.management.remote.rmi.RMIConnectionImpl.access$300(RMIConnectionImpl.java:76)
at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1309)
at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1401)
at javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:829)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:357)
at sun.rmi.transport.Transport$1.run(Transport.java:200)
at sun.rmi.transport.Transport$1.run(Transport.java:197)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:196)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:568)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:826)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:683)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:682)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\smartCity\flatformUser\server\platform\platformUser\target\platformUser\WEB-INF\classes\sqlmap\UserMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving JdbcType. Cause: java.lang.IllegalArgumentException: No enum constant org.apache.ibatis.type.JdbcType.VARCH AR
at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:466)
at org.mybatis.spring.SqlSessionFactoryBean.afterPropertiesSet(SqlSessionFactoryBean.java:340)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)
... 57 more
Caused by: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving JdbcType. Cause: java.lang.IllegalArgumentException: No enum constant org.apache.ibatis.type.JdbcType.VARCH AR
at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:117)
at org.apache.ibatis.builder.xml.XMLMapperBuilder.parse(XMLMapperBuilder.java:89)
at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:464)
... 60 more
Caused by: org.apache.ibatis.builder.BuilderException: Error resolving JdbcType. Cause: java.lang.IllegalArgumentException: No enum constant org.apache.ibatis.type.JdbcType.VARCH AR
at org.apache.ibatis.builder.BaseBuilder.resolveJdbcType(BaseBuilder.java:63)
at org.apache.ibatis.builder.SqlSourceBuilder$ParameterMappingTokenHandler.buildParameterMapping(SqlSourceBuilder.java:97)
at org.apache.ibatis.builder.SqlSourceBuilder$ParameterMappingTokenHandler.handleToken(SqlSourceBuilder.java:63)
at org.apache.ibatis.parsing.GenericTokenParser.parse(GenericTokenParser.java:50)
at org.apache.ibatis.builder.SqlSourceBuilder.parse(SqlSourceBuilder.java:42)
at org.apache.ibatis.scripting.defaults.RawSqlSource.<init>(RawSqlSource.java:39)
at org.apache.ibatis.scripting.defaults.RawSqlSource.<init>(RawSqlSource.java:33)
at org.apache.ibatis.scripting.xmltags.XMLScriptBuilder.parseScriptNode(XMLScriptBuilder.java:68)
at org.apache.ibatis.scripting.xmltags.XMLLanguageDriver.createSqlSource(XMLLanguageDriver.java:36)
at org.apache.ibatis.builder.xml.XMLStatementBuilder.parseStatementNode(XMLStatementBuilder.java:94)
at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:132)
at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:125)
at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:115)
... 62 more
Caused by: java.lang.IllegalArgumentException: No enum constant org.apache.ibatis.type.JdbcType.VARCH AR
at java.lang.Enum.valueOf(Enum.java:238)
at org.apache.ibatis.type.JdbcType.valueOf(JdbcType.java:22)
at org.apache.ibatis.builder.BaseBuilder.resolveJdbcType(BaseBuilder.java:61)
... 74 more
13-Feb-2018 14:17:28.654 严重 [RMI TCP Connection(3)-127.0.0.1] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
13-Feb-2018 14:17:28.655 严重 [RMI TCP Connection(3)-127.0.0.1] org.apache.catalina.core.StandardContext.startInternal Context [/platformUser] startup failed due to previous errors

[2018-02-13 02:17:28,713] Artifact platformUser:war exploded: Error during artifact deployment. See server log for details.


报错原因是.xml 中格式的错误匹配不到 :  在 对应的.xml 中找到错误,进行修改即可




  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
### 回答1: 这个错误是由于在spring-dao.xml文件中定义的sqlsessionfactory bean出现问题导致的。可能是配置文件中的某些属性或依赖项不正确,或者可能是由于缺少必要的库或驱动程序。需要检查配置文件和依赖项,确保它们正确,并且所有必要的库和驱动程序都已正确安装和配置。 ### 回答2: 在使用Spring框架中,有时会遇到“error creating bean with name 'sqlsessionfactory' defined in class path resource [spring-dao.xml]” 的问题,这通常是由于以下几个原因所致。 首先,可能是由于数据库连接信息的设置有误。在Spring框架中,数据库连接信息往往是在spring-dao.xml中进行定义和设置的,其中需要填写数据库的URL、用户名和密码等信息。如果这些信息填写错误,就会导致无法创建SQLSessionFactory,从而出现上述错误。 其次,可能是由于MyBatis的配置文件存在问题。在Spring和MyBatis的整合中,我们需要在spring-dao.xml文件中引入MyBatis的配置文件,并使用SqlSessionFactoryBean来创建SQLSessionFactory。因此,如果MyBatis的配置文件存在问题,如XML格式不正确、命名空间和SQL语句名称不匹配等,就会导致SQLSessionFactory创建失败,从而报错。 再次,可能是由于Spring版本与MyBatis版本不兼容所致。在使用Spring和MyBatis整合时,需要注意两者的版本兼容性。如果版本不兼容,就会导致一些类或方法无法找到,从而无法创建SQLSessionFactory。 最后,可能是由于缺少必要的依赖库所致。在使用Spring和MyBatis整合时,需要将相关的依赖库添加到项目中,否则会导致找不到相应的类,从而无法创建SQLSessionFactory。 针对上述问题,我们可以按照以下步骤进行排查和解决: 1.检查数据库连接信息,确保URL、用户名和密码等信息正确无误; 2.检查MyBatis的配置文件,确保XML格式正确、命名空间和SQL语句名称与Mapper接口相匹配; 3.确认Spring版本与MyBatis版本兼容,并进行相应的调整; 4.检查项目中依赖库是否完整,是否缺少必要的依赖库。 ### 回答3: “error creating bean with name 'sqlsessionfactory' defined in class path resource [spring-dao.xml]”出现的原因可能有很多种,但大多都涉及Spring框架的使用。 首先,这个错误提示表明在spring-dao.xml文件中定义的名为sqlsessionfactorybean创建失败。可能的原因之一是配置文件格式错误,导致Spring框架无法加载配置。这时可以检查配置文件是否遵循了规范,如XML格式是否正确、标签是否匹配等等。 另一个可能的原因是Java类或包的路径设置错误,在spring-dao.xml中无法正确找到对应的类,导致bean创建失败。这一种情况下,可以通过检查类或包路径是否正确,或者是否导入了相应的Jar包来解决。 除此之外,还有一种常见的错误是数据库配置不正确。当数据库连接信息错误或者数据库服务异常时,SQLSessionFactory无法创建成功,出现上述错误。解决方法是检查数据库连接信息是否正确,或者检查数据库是否处于可用状态。 综上所述,解决“error creating bean with name 'sqlsessionfactory' defined in class path resource [spring-dao.xml]”的关键在于定位问题的根源,如果错误提示信息不清楚,可以通过日志或者调试来找到出错点。同时也需要对Spring框架和数据库有一定的了解,才能在遇到问题时快速解决。
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值