赞
踩
下面是我的运行界面:
错误代码及提示如下:
Connected to the target VM, address: '127.0.0.1:64765', transport: 'socket'
- org.apache.ibatis.exceptions.PersistenceException:
- ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'mybatis.users' doesn't exist
- ### The error may exist in mapper/UserMapper.xml
- ### The error may involve com.jnxy.pojo.User.findById-Inline
- ### The error occurred while setting parameters
- ### SQL: select * from users where uid = ?
- ### Cause: java.sql.SQLSyntaxErrorException: Table 'mybatis.users' doesn't exist
-
- at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
- at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)
- at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
- at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)
- at Test.UserTest.userFindByIdTest(UserTest.java:32)
- at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.base/java.lang.reflect.Method.invoke(Method.java:566)
- at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
- at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
- at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
- at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
- at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
- at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
- at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
- at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
- at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
- at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
- at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
- at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
- at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
- at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
- at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)
- at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33)
- at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:221)
- at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54)
- Caused by: java.sql.SQLSyntaxErrorException: Table 'mybatis.users' doesn't exist
- at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118)
- at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)
- at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
- at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960)
- at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:388)
- at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
- at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
- at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
- at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
- at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
- at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
- at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
- at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
- ... 25 more
- Disconnected from the target VM, address: '127.0.0.1:64765', transport: 'socket'
- Process finished with exit code -1

当然,CSDN中诸多代码作者给出的不同解决方案,还是没有解决问题。检查了关于文件大小写、Maven版本和端口等,均没有解决问题。至于有些作者所说的断点和控制台,没有找到具体位置,依然无法解决。
欢迎各位交流讨论。最后祝大家中秋国庆假期愉快!
赞
踩
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。