用于代码生成的ANTLR工具版本4.10.1不匹配当前运行时版本4.7ANTLR运行时版本4.10.1

Question

我无法解决Jaybird的lib包版本的问题:Jaybird -jdk17:3.0.10，其中antlr4-runtime:4.7与hibernate-core6.1.5Final lib冲突，其中有另一个antlr4:4.10 .1https://uploaddeimagens.com.br/imagens/vSObP0s

我试图改变其他Jaybird依赖，但没有成功，我试图改变hibernate库，但没有成功。

实体

package com.aula.restiapi.entidade;
import jakarta.persistence.Entity;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.GenerationType;
import jakarta.persistence.Id;
import jakarta.persistence.Table;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Entity
@NoArgsConstructor
@AllArgsConstructor
@Data
@Table(name = "tb_users")
public class Usuario {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
private String name;
private String email;
private Double salary;
}

库

package com.aula.restiapi.repository;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;
import com.aula.restiapi.entidade.Usuario;
@Repository
public interface UsuarioRepository extends JpaRepository<Usuario, Long>{
@Query("SELECT obj FROM User obj WHERE obj.salary >= :minSalary AND 
obj.salary <= :maxSalary")
Page<Usuario> searchBySalary(Double minSalary, Double maxSalary, Pageable pageable);
}

控制器

package com.aula.restiapi.controller;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import com.aula.restiapi.entidade.Usuario;
import com.aula.restiapi.repository.UsuarioRepository;
@RestController
@RequestMapping(value = "/users")
public class UserController {
@Autowired
private UsuarioRepository repository;

@GetMapping
public ResponseEntity<List<Usuario>> findAll() {
List<Usuario> result = repository.findAll();
return ResponseEntity.ok(result);
}
@GetMapping(value = "/page")
public ResponseEntity<Page<Usuario>> findAll(Pageable pageable) {
Page<Usuario> result = repository.findAll(pageable);
return ResponseEntity.ok(result);

}
@GetMapping(value = "/search-salary")
public ResponseEntity<Page<Usuario>> searchBySalary(@RequestParam(defaultValue = "0") Double minSalary, @RequestParam(defaultValue = "1000000000000") Double maxSalary, Pageable pageable) {
Page<Usuario> result = repository.searchBySalary(minSalary, maxSalary, pageable);
return ResponseEntity.ok(result);
}

}

application.properties

spring.datasource.url:jdbc:firebirdsql:localhost/3050:C:/DB/BD_ARTISTS.FDB? 
sql_dialect=3&charSet=utf-8
spring.datasource.username:SYSDBA
spring.datasource.password:masterkey
spring.datasource.driver-class-name=org.firebirdsql.jdbc.FBDriver
spring.jpa.database-platform=org.hibernate.community.dialect.FirebirdDialect
spring.jpa.show-sql: true
spring.jpa.properties.hibernate.format_sql=true
#logging.level.org.springframework=DEBUG
app.path.arquivos=/Users/Paulo/Pictures/SavedPictures
spring.servlet.multipart.max-file-size=30MB
spring.servlet.multipart.max-request-size=30MB

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>3.0.0</version>
<relativePath /> <!-- lookup parent from repository -->
</parent>
<groupId>com.aula</groupId>
<artifactId>restiapi</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>restiapi</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>17</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-rest</artifactId>
</dependency>
<dependency>
<groupId>org.firebirdsql.jdbc</groupId>
<artifactId>jaybird-jdk17</artifactId>
<version>3.0.10</version>
</dependency>
<dependency>
<groupId>org.hibernate.orm</groupId>
<artifactId>hibernate-community-dialects</artifactId>
</dependency>
<dependency>
<groupId>net.java.dev.jna</groupId>
<artifactId>jna</artifactId>
<version>5.5.0</version>
</dependency>
<dependency>
<groupId>com.mysql</groupId>
<artifactId>mysql-connector-j</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<configuration>
<excludes>
<exclude>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</exclude>
</excludes>
</configuration>
</plugin>
</plugins>
</build>
</project>

Answer 1

您需要切换到使用Jaybird 4.0.8。问题是Jaybird 4.0.7及更早版本使用了由ANTLR 4.7.2(或更早版本)生成的语法。Hibernate 6升级到ANTLR 4.10(或更高版本)，在ANTLR 4.10中有一个不兼容的变化，这意味着当ANTLR 4.10或更高版本在类路径上时，无法加载Jaybird的语法，反之亦然，如果ANTLR 4.7，则无法加载使用ANTLR 4.10或更高版本的库(如Hibernate)的语法。X在类路径上。

Jaybird 4.0.8通过用一个无依赖解析器取代对ANTLR 4.7.2的依赖来修复这个问题。

作为题外，通常你应该让Spring Boot处理Jaybird的依赖版本，但是Spring Boot 3.0.0目前定义了4.0.7.java11版本。

在任何情况下，删除当前的Jaybird依赖项(因为您依赖于已弃用的artifactIdjaybird-jdk17，它适用于Java 1.7，而不是Java 17!)并添加:

<dependency>
<groupId>org.firebirdsql.jdbc</groupId>
<artifactId>jaybird</artifactId>
<version>4.0.8.java11</version>
</dependency>

我建议你检查Jaybird 4的发行说明，如果有任何相关的或突破性的变化。

如果你升级到Spring Boot 3.0.1或更高版本，你可以使用:

<dependency>
<groupId>org.firebirdsql.jdbc</groupId>
<artifactId>jaybird</artifactId>
</dependency>

并让Spring Boot管理依赖版本。

顺便说一句，我注意到您列出了对net.java.dev.jna:jna的依赖项。如果你是因为杰伯德才加的，那你就应该把它删掉。只有当您使用本机或嵌入式连接时，Jaybird才需要JNA，但是您的代码为Firebird使用纯java JDBC URL，因此不需要添加JNA。