[ERROR][TaskAgile] .jdbc4.MySQLSyntaxErrorException: Table 'db.table' doesn't exist

 

2020-11-26 23:23:00.422  WARN 19116 --- [nio-8080-exec-3] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 1146, SQLState: 42S02
2020-11-26 23:23:00.423 ERROR 19116 --- [nio-8080-exec-3] o.h.engine.jdbc.spi.SqlExceptionHelper   : Table 'task_agile.user' doesn't exist
2020-11-26 23:23:00.426 ERROR 19116 --- [nio-8080-exec-3] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request 
processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet] with root cause

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'task_agile.user' doesn't exist    
        at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 
~[na:na
...

ERROR 내용

MySQL에 user table이 없다고 한다.

 

MySQL에 user 추가(대소문자를 구분하는 것 같다...?)

 

 

 

---

해결 방법

MySQL에서 해당 쿼리 작성

 create table user (
    -> id INT(11),
    -> username VARCHAR(64) not null,
    -> email_address VARCHAR(128) not null,
    -> password VARCHAR(32) not null,
    -> first_name VARCHAR(64) not null,
    -> last_name VARCHAR(64) not null,
    -> created_date DATETIME not null,
    -> PRIMARY KEY(id)
    -> );
    
  ALTER TABLE user AUTO_INCREMENT=1;
  
  ALTER TABLE user MODIFY id INT NOT NULL AUTO_INCREMENT;
  
  
  // 쿼리 성공 표시
  Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

 

삽입 성공!

 

참고 사이트  : zena1010.tistory.com/8