Spring, springmvc, mybatis integrated ssm framework appears ORA-02289: sequence does not exist problem, springmvcora-02289
An SSM project was integrated today and deployed to the Tomcat server after completion. However, when I send a request, the following error is returned:
The error indicates that the sequence does not exist, but I have created a sequence. Then I tested it. Test statement: select tb_user_seq.nextval from dual
This is strange if the test is complete. As a result, Baidu and Baidu fail to solve the problem by using the usual checking methods.
If you don't want to talk about it, let's talk about the solution:
First, ensure that your mapper configuration file and the object class are mapped one by one. Second, confirm that you have this sequence
After the two items are okay, after, I finally found the problem,
The problem is that the configuration file of my oracle database is incorrect. The url is written to another database. After solving this problem, I started the server again and sent the request. The problem is solved.