MyException--org.apache.ibatis.exceptions.PersistenceException: ### Error building SqlSession. ###

本文记录了一次在使用 MyBatis 进行关联查询时遇到的问题,即因将 resultMap 错误配置为 resultType 而引发的异常。通过详细分析错误日志,最终定位并解决了问题。
org.apache.ibatis.exceptions.PersistenceException: 
### Error building SqlSession.
### The error may exist in cn/itcast/mybatis/mapper/OrdersMapperCustom.xml
### The error occurred while processing mapper_resultMap[OrdersUserResultMap]_association[user]
### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'OrdersUserResultMap'.  Cause: java.lang.ClassNotFoundException: Cannot find class: OrdersUserResultMap
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:26)
at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:82)
at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:66)
at cn.itcast.mybatis.mapper.OrdersMapperCustomTest.setUp(OrdersMapperCustomTest.java:26)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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.ParentRunner.runLeaf(ParentRunner.java:263)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:69)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:48)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222)
at org.junit.runners.ParentRunner.run(ParentRunner.java:292)
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.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'OrdersUserResultMap'.  Cause: java.lang.ClassNotFoundException: Cannot find class: OrdersUserResultMap
at org.apache.ibatis.builder.xml.XMLConfigBuilder.parseConfiguration(XMLConfigBuilder.java:109)
at org.apache.ibatis.builder.xml.XMLConfigBuilder.parse(XMLConfigBuilder.java:92)
at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:80)
... 25 more
Caused by: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'OrdersUserResultMap'.  Cause: java.lang.ClassNotFoundException: Cannot find class: OrdersUserResultMap
at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:120)
at org.apache.ibatis.builder.xml.XMLMapperBuilder.parse(XMLMapperBuilder.java:92)
at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.loadXmlResource(MapperAnnotationBuilder.java:164)
at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.parse(MapperAnnotationBuilder.java:118)
at org.apache.ibatis.binding.MapperRegistry.addMapper(MapperRegistry.java:71)
at org.apache.ibatis.binding.MapperRegistry.addMappers(MapperRegistry.java:96)
at org.apache.ibatis.binding.MapperRegistry.addMappers(MapperRegistry.java:104)
at org.apache.ibatis.session.Configuration.addMappers(Configuration.java:647)
at org.apache.ibatis.builder.xml.XMLConfigBuilder.mapperElement(XMLConfigBuilder.java:313)
at org.apache.ibatis.builder.xml.XMLConfigBuilder.parseConfiguration(XMLConfigBuilder.java:107)
... 27 more
Caused by: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'OrdersUserResultMap'.  Cause: java.lang.ClassNotFoundException: Cannot find class: OrdersUserResultMap
at org.apache.ibatis.builder.BaseBuilder.resolveClass(BaseBuilder.java:103)
at org.apache.ibatis.builder.xml.XMLStatementBuilder.parseStatementNode(XMLStatementBuilder.java:72)
at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:135)
at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:128)
at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:118)
... 36 more
Caused by: org.apache.ibatis.type.TypeException: Could not resolve type alias 'OrdersUserResultMap'.  Cause: java.lang.ClassNotFoundException: Cannot find class: OrdersUserResultMap
at org.apache.ibatis.type.TypeAliasRegistry.resolveAlias(TypeAliasRegistry.java:117)
at org.apache.ibatis.builder.BaseBuilder.resolveAlias(BaseBuilder.java:130)
at org.apache.ibatis.builder.BaseBuilder.resolveClass(BaseBuilder.java:101)
... 40 more
Caused by: java.lang.ClassNotFoundException: Cannot find class: OrdersUserResultMap
at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:190)
at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:89)
at org.apache.ibatis.io.Resources.classForName(Resources.java:256)
at org.apache.ibatis.type.TypeAliasRegistry.resolveAlias(TypeAliasRegistry.java:113)

... 42 more

以上就是我在学习mybatis中,定义statement时,把resultMap定义成了resultType,所以出现了这样的错误信息。


<!-- 查询订单关联查询用户信息,使用resultMap -->
<select id="findOrdersUserResultMap" resultType="OrdersUserResultMap">
SELECT 
orders.*,
 
USER.username,
 
USER.sex,
 
USER.address 
FROM
 
orders,
 
USER 
WHERE orders.user_id = user.id
</select>

    细节真的很重要,害我检查了好长时间,第二次了,好懵逼的感觉。。。。



这个错误: ``` ExcTest.java:20: error: cannot find symbol ``` 通常后面还会跟更多信息,比如: ``` symbol: class MyException location: class ExcTest ``` 这说明:**在 `ExcTest` 类中找不到 `MyException` 这个类**。 --- ### ❌ 错误原因分析 你可能把代码写成了这样(常见错误结构): ```java public class ExcTest { // 其他代码... } class MyException extends Exception { // 放在了主类外面,但在同一个文件 ... } ``` 但问题在于:**某些 Java 编译环境(尤其是在线评测系统 OJ)要求所有类必须按特定顺序或方式定义**。更关键的是 —— **有些平台只允许一个公共类(public class),且必须是文件名对应的类**。 如果你把 `MyException` 定义在 `public class ExcTest` **之后**,而编译器先加载 `ExcTest` 时就用到了 `MyException`,就会报 `cannot find symbol`,因为此时 `MyException` 还未被定义! --- ### ✅ 正确解决方案:将自定义异常类写在 **前面** > 🔥 必须保证:**使用一个类之前,它已经被定义了!** --- ### ✅ 正确代码顺序(放在 `Begin-End` 之间) ```java /********** Begin **********/ import java.util.Scanner; // 第一步:自定义异常类(必须写在前面) class MyException extends Exception { public MyException(String message) { super(message); } } // 第二步:主类 ExcTest public class ExcTest { public static void main(String[] args) { Scanner scanner = new Scanner(System.in); // 第三步:接收整数 int n = scanner.nextInt(); // 第四步:判断是否为质数 try { if (isPrime(n)) { // 第五步:输出该数 System.out.println(n); } else { throw new MyException("非质数异常"); } } catch (MyException e) { System.out.println(e.getMessage()); } scanner.close(); } // 判断质数的方法 public static boolean isPrime(int num) { if (num < 2) return false; if (num == 2) return true; if (num % 2 == 0) return false; for (int i = 3; i * i <= num; i += 2) { if (num % i == 0) return false; } return true; } } /********** End **********/ ``` --- ### ✅ 关键点解释: | 问题 | 解决方案 | |------|----------| | `cannot find symbol: class MyException` | 把 `MyException` 类的定义 **放在 `ExcTest` 类之前** | | 为什么不能后置? | Java 编译是按顺序扫描的,不能引用尚未定义的类(即使在同一文件) | | 是否可以嵌套定义? | 不行!不能在 `main` 或类内部直接写 `class MyException`(除非是静态内部类) | | 如何避免这个问题? | 记住:**辅助类写前面,主类写后面** | --- ### ✅ 补充建议:使用静态内部类(可选优化) 如果你想确保 `MyException` 和 `ExcTest` 的依赖关系清晰,也可以将其作为 **静态内部类** 放在主类中: ```java public class ExcTest { // 自定义异常作为静态内部类 public static class MyException extends Exception { public MyException(String message) { super(message); } } public static void main(String[] args) { // 其他逻辑不变... } public static boolean isPrime(int num) { // 质数判断 } } ``` ✅ 优点: - 类集中管理 - 避免“找不到符号”问题 - 符合某些平台对多类文件的限制 ⚠️ 注意:这种方式下,`MyException` 是 `ExcTest` 的内部成员,仍需在使用前定义(即写在 `main` 上方) --- ### 🧪 测试样例验证 | 输入 | 输出 | |------|------| | `7` | `7` | | `9` | `非质数异常` | ---
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值