初学Mybatis遇到 Error building SqlSession

最新推荐文章于 2023-02-07 01:00:35 发布
最新推荐文章于 2023-02-07 01:00:35 发布
阅读量4.4k 收藏
点赞数 2
分类专栏： java frame 文章标签： mybatis java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/ljylyz/article/details/83412144
版权

进行Junit测试时遇到的错误

1、Error building SqlSession.

java.lang.ExceptionInInitializerError
	at ljy.gx.TestMyBatis.testBefore(TestMyBatis.java:21)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:27)
	at org.junit.runners.BlockJUnit4ClassRunner.runNotIgnored(BlockJUnit4ClassRunner.java:79)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:71)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:49)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
Caused by: org.apache.ibatis.exceptions.PersistenceException: 
### Error building SqlSession.
### Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance.  Cause: org.xml.sax.SAXParseException; lineNumber: 4; columnNumber: 16; 文档根元素 "configuration" 必须匹配 DOCTYPE 根 "generatorConfiguration"。
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
	at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:32)
	at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:16)
	at ljy.gx.util.MyBatisUtil.<clinit>(MyBatisUtil.java:23)
	... 24 more
Caused by: org.apache.ibatis.builder.BuilderException: Error creating document instance.  Cause: org.xml.sax.SAXParseException; lineNumber: 4; columnNumber: 16; 文档根元素 "configuration" 必须匹配 DOCTYPE 根 "generatorConfiguration"。
	at org.apache.ibatis.parsing.XPathParser.createDocument(XPathParser.java:238)
	at org.apache.ibatis.parsing.XPathParser.<init>(XPathParser.java:102)
	at org.apache.ibatis.builder.xml.XMLConfigBuilder.<init>(XMLConfigBuilder.java:40)
	at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:29)
	... 26 more
Caused by: org.xml.sax.SAXParseException; lineNumber: 4; columnNumber: 16; 文档根元素 "configuration" 必须匹配 DOCTYPE 根 "generatorConfiguration"。
	at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)
	at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.rootElementSpecified(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.handleStartElement(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.startElement(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$ContentDriver.scanRootElementHook(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown Source)
	at org.apache.ibatis.parsing.XPathParser.createDocument(XPathParser.java:236)
	... 29 more

    错误原因是mybatis-config.xml中缺少DTD验证检查

    <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd" >改为<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd" >

 

2、Type interface ljy.gx.dao.TbstudentMapper is not known to the MapperRegistry.

org.apache.ibatis.binding.BindingException: Type interface ljy.gx.dao.TbstudentMapper is not known to the MapperRegistry.
	at org.apache.ibatis.binding.MapperRegistry.getMapper(MapperRegistry.java:21)
	at org.apache.ibatis.session.Configuration.getMapper(Configuration.java:466)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.getMapper(DefaultSqlSession.java:181)
	at ljy.gx.TestMyBatis.testSelectSingleTableSingle(TestMyBatis.java:33)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
	at org.junit.runners.BlockJUnit4ClassRunner.runNotIgnored(BlockJUnit4ClassRunner.java:79)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:71)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:49)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)

    错误的原因是mapping包中的TbstudentMapper.xml下生成的namespace选择出错，已改回

    <mapper namespace="ljy.gx.dao.TbstudentMapper" >

有的也
关注
  • 2
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
用mybatis查数据库数据，报错提示### Error building SqlSession.
s2018_0423的博客
06-28 3712
### Error building SqlSession.### The error may exist in SQL Mapper Configuration### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis...
mybatis配置--Error building SqlSession.
娓娓道来
10-14 904
Error building SqlSession 一般有多种情况，暂时只描述我出现的情况 1. <mappers> <mapper resource="com/itheima/dao/IUserDao.xml"/> </mappers> 配置mappers时resouce文件位置错误，并未带.xml
mybatis错误： Error building SqlSession.
weixin_50551204的博客
03-22 881
发生Error building SqlSession，可能是因为数据库连接不成功导致的，其中mysql8.0以上的配置信息如下 需要在url中数据库名后添加内容： ?serverTimezone=Asia/Shanghai&amp；useUnicode=true&amp;characterEncoding=utf8&amp;useSSL=false ...
MyBatis报错 ### Error building SqlSession.
xxxibgdrgn博客
03-08 803
报错内容 com.fmm.test.Test Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException: ### Error building SqlSession. ### The error may exist in com/fmm/mapper/AccountMapper.xml ### Cause: org.apache.ibatis.builder.BuilderException: Error pa
MyBatis报错：Error building SqlSession.解决
weixin_45974777的博客
04-18 458
报错误可能在studentmapper.xml中 解决方法：把com.test.Entity包中的内容加全，加几个之前少了的类
MyBatis 源码分析 之SqlSession接口和Executor类
08-31
在MyBatis中，SqlSession接口扮演着核心角色，它是开发者与数据库交互的主要接口。SqlSession提供了诸如插入（insert）、更新（update）、删除（delete）和查询（select）等操作。在实际应用中，最常见的SqlSession...
SpringBoot+MyBatis+SqlSession
04-24
在IT行业中，SpringBoot、MyBatis和SqlSession是三个非常关键的技术组件，它们共同构建了一个高效、便捷的Web应用程序开发环境。让我们深入探讨一下这三个技术及其在项目中的结合使用。 首先，SpringBoot是由...
获取Java的MyBatis框架项目中的SqlSession的方法
09-02
在Java的MyBatis框架中，SqlSession是一个关键组件，它提供了执行SQL语句和处理结果的接口。SqlSession包含了已经映射好的SQL语句，这意味着开发者可以通过它直接调用预定义的数据库操作，而无需手动编译和执行SQL。...
mybatis获取SqlSession源代码流程
12-10
mybatis获取SqlSession源代码流程
第12章Mybatis之SqlSession
最新发布
05-12
mybatis-config.xml
Mybatis之Error building SqlSession.
逐梦苍穹的博客
02-07 929
介绍Error building SqlSession的解决方式
初学mybatis 出现Error building SqlSession错误
w708890240的博客
04-06 518
Error:java: 错误: 不支持发行版本 5 参照https://blog.csdn.net/qq_44887733/article/details/105751433 还有用数据库8.0以上版本的要改url以及驱动 用了以上方法之后还是报错 再仔细检查了代码之后 发现compile 以后 target里面没有studentDao.xml文件，然后修改了mybatis.xml的配置信息 还是报错 随后仔细检查mybatis里面 出现了以上错误 不易察觉 随后修改之后程...
报错：Error building SqlSession.解决
weixin_49512993的博客
08-30 1089
错误详情： Error building SqlSession. The error may exist in com/lengzher/Dao/UserMapper.xml Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error creating document in
遇到Error building SqlSession.，解决办法
热门推荐
qq_44692189的博客
03-26 2万+
ps:当遇到这个问题时，我跟很多小伙伴一样，有事找度娘。查看了那么多，发现大多是配置文件mybatis-config.xml和映射文件的语法错误，这些都会在控制台(console)中有显示在xml对应的语法错误位置。除此之外最多的就是别名问题->>初学Mybatis时遇到 Error building SqlSession.的原因，看了半天，终于成功解决了 我的错误没有相关位置的报错，...
MyBatis的SqlSessionFactory的创建问题
Dean Chen的专栏
05-07 1万+
MyBatis SqlSessionFactory Singleton
### Error building SqlSession.
weixin_30530523的博客
10-11 1269
org.apache.ibatis.exceptions.PersistenceException: ### Error building SqlSession.### The error may exist in sqlmap/User.xml### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapp...
Error building SqlSession问题
qq_45898383的博客
03-26 9192
1、mybatis核心文件没有配置好 甚至是mapper的位置是否放置好也会导致 所以注意自己配置时候的核心文件是否正确 2、返回的结果类型没配置好 3、拼写错误 不小心修改到了核心文件中的原本name属性，导致不能解析该标量 这种问题，大多数属于自己的粗心大意造成的，多注意点就好 ...............
使用MyBatis时遇到 Error building SqlSession. 的原因，找了半天终于解决了
严泽熠的博客
04-05 8131
Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException: ### Error building SqlSession. ### The error may exist in SQL Mapper Configuration ### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration.
报错：Error building SqlSession.
weixin_45619952的博客
12-04 6659
报错：Error building SqlSession. 的几种解决方法。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值