集成测试通过gradle测试失败，但通过IDE

Question

我在所有集成测试中不断收到异常，而单元测试运行良好。所有异常如下所示：

UsersControllerTest > getOneUser() FAILED
    java.lang.IllegalStateException at DefaultCacheAwareContextLoaderDelegate.java:132
        Caused by: org.springframework.jdbc.datasource.init.ScriptStatementFailedException at ScriptUtils.java:626
            Caused by: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException at DbException.java:459

我正在使用Jupiter进行测试。我的观点的上述例外指向data.sql脚本，我必须填充一些数据。对我来说，语法似乎没问题，也运行良好，这意味着如果使用邮递员进行测试，会生成记录：

INSERT INTO AUTHORITY (ID_AUTHORITY,AUTHORITY) VALUES (1,'USER');
INSERT INTO AUTHORITY (ID_AUTHORITY,AUTHORITY) VALUES (2,'MODERATOR');
INSERT INTO AUTHORITY (ID_AUTHORITY,AUTHORITY) VALUES (3,'ADMIN');
INSERT INTO USER (USER_ID,FIRST_NAME,LAST_NAME,ID,PASSWORD,EMAIL,EMAIL_VERIFIED,ACCOUNT_NON_EXPIRED,ACCOUNT_NON_LOCKED,ENABLED,CREDENTIALS_NON_EXPIRED)
VALUES (1,'Alisher','Urunov','b006c568-a79b-4c28-a06c-df7d89579e00','$2y$12$vLPHTGSDyNWBdH.zxuJgfeiExUwh3zT3Cgj8ZZzW.38rDNK/yBJtm','[e-mail]',TRUE,TRUE,TRUE,TRUE,TRUE);
INSERT INTO USER (USER_ID,FIRST_NAME,LAST_NAME,ID,PASSWORD,EMAIL,EMAIL_VERIFIED,ACCOUNT_NON_EXPIRED,ACCOUNT_NON_LOCKED,ENABLED,CREDENTIALS_NON_EXPIRED)
VALUES (2,'Ralf','Tester','b006c568-a79b-123s-a06c-df7d89579e00','$2a$10$3D8eyR7FouUb3RjKoVd9r.pBa7wZbOCe4BeIgxJmJmT9kbYGU43qC','[e-mail]',FALSE,TRUE,TRUE,TRUE,TRUE);
INSERT INTO USER (USER_ID,FIRST_NAME,LAST_NAME,ID,PASSWORD,EMAIL,EMAIL_VERIFIED,ACCOUNT_NON_EXPIRED,ACCOUNT_NON_LOCKED,ENABLED,CREDENTIALS_NON_EXPIRED)
VALUES (3,'Ronald','The Great','b006c568-a79b-123s-1248-df7d89579e00','$2a$10$l9jefOjW/P0/dYH.MkHO8OJkNc7SN/G4ZOK1Lk9ND0x08Yta9hJrq','[e-mail]',TRUE,TRUE,TRUE,TRUE,TRUE);
INSERT INTO USER_AUTHORITY (ID_USER,ID_AUTHORITY) VALUES (1,1);
INSERT INTO USER_AUTHORITY (ID_USER,ID_AUTHORITY) VALUES (1,2);
INSERT INTO USER_AUTHORITY (ID_USER,ID_AUTHORITY) VALUES (1,3);
INSERT INTO USER_AUTHORITY (ID_USER,ID_AUTHORITY) VALUES (3,1);

还考虑了Spring Boot可能存在的配置问题，所以我在gradle中添加了jdbc-starter依赖项。但它似乎仍然失败。

以下是测试的一部分:

@ExtendWith(SpringExtension.class)
@SpringBootTest(classes = UserServiceApplication.class,webEnvironment = SpringBootTest.WebEnvironment.RANDOM_PORT)
@ContextConfiguration(classes = UserServiceApplication.class)
@DirtiesContext(classMode = DirtiesContext.ClassMode.BEFORE_EACH_TEST_METHOD)
class UsersControllerTest {

  private String adminToken;
  private String userToken;

  @Autowired TestRestTemplate restTemplate;
  @Autowired TokenUtils tokenUtils;

  @BeforeEach
  void setUp() {
   userToken = tokenUtils.generateTokenForUser(user());
   adminToken = tokenUtils.generateTokenForUser(admin());
  }

  @Test
  void getOneUser() {
    HttpHeaders headers = new HttpHeaders();
    headers.add("Authorization", "Bearer "+adminToken);
    headers.add("Access-Control-Expose-Headers", "Authorization");
    ResponseEntity<UserModel> result =
        restTemplate.exchange(
            "/users/userInfo", HttpMethod.GET, new HttpEntity<>(headers), UserModel.class);
    assertEquals("[e-mail]", result.getBody().getEmail());
  }

Answer 1

我在项目中似乎有两个依赖关系

1） Sring引导启动测试2）我在mockito 3中添加了一堆jupiter依赖项*

他们一直在冲突。我已经删除了第二个，现在一切似乎都在工作。