jpa, spring batch meta table들을 활용할때
h2 db를 임의로 초기화하고싶을때가 있다.
근데 truncate할때 fk 등등의 제약조건 걸려서 못할때 (개빡침) 하는 방법
SET REFERENTIAL_INTEGRITY FALSE --제약조건 무효화
SHOW TABLES
TRUNCATE TABLE {TABLE_NAME}
SET REFERENTIAL_INTEGRITY TRUE --제약조건 재설정
stackoverflow.com/questions/27045568/h2-how-to-truncate-all-tables
H2 - How to truncate all tables?
I assume there is a way of doing this from code, at least some good workaround. Please consider that I do not want to delete all tables (I've seen this command), just to delete rows from them but to
stackoverflow.com
'etc' 카테고리의 다른 글
| [Intellij] intellij breakpoint 지정 후 디버깅시 IDE가 느려질때 해결방법 (1) | 2021.06.03 |
|---|---|
| [Elasticsearch] max file descriptors [4096] for elasticsearch process is too low 오류 해결 (0) | 2021.02.18 |
| [QueryDsl] querydsl jpa 사용시 UnsupportedOperationException 해결 (4) | 2020.10.26 |
| [h2] h2 database multi connection 옵션주기 (0) | 2020.09.02 |
| [Redis] Jedis를 활용한 Redis Dummy Data 넣기 (0) | 2020.07.16 |