psqlException：错误：关系“table_name”不存在

Question

我使用PostgreSQL 10、Spring Boot 2.2.7.Release和pgAdmin 4来实现Postgres GUI

我有以下实体类：

@Entity
@Table(name = "\"TB03_TABLE_A\"")
public class VersionData {

    private int id;
    private String version;
    private String dataType;
    private int min;
    private int max;
    private String possibleValues;

    @Id
    @SequenceGenerator(allocationSize = 1, sequenceName = "\"TB03_TABLE_A_seq\"", name = "table_a_id_seq")
    @GeneratedValue(generator = "table_a_id_seq", strategy = GenerationType.SEQUENCE)
    @Column(name = "\"ID\"", unique = true, nullable = false)
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }


    @Column(name = "\"VERSION\"")
    public String getVersion() {
        return version;
    }
    public void setVersion(String version) {
        this.version = version;
    }

    @Column(name = "\"DATATYPE\"")
    public String getDataType() {
        return dataType;
    }
    public void setDataType(String dataType) {
        this.dataType = dataType;
    }

    @Column(name = "\"MIN\"")
    public int getMin() {
        return min;
    }
    public void setMin(int min) {
        this.min = min;
    }

    @Column(name = "\"MAX\"")
    public int getMax() {
        return max;
    }
    public void setMax(int max) {
        this.max = max;
    }

    @Column(name = "\"POSSIBLE_VALUES\"")
    public String getPossibleValues() {
        return possibleValues;
    }
    public void setPossibleValues(String possibleValues) {
        this.possibleValues = possibleValues;
    }


}

我已经使用GUI PGADMIN4为ID列“TB03_TABLE_A_SEQ”创建了表“TB03_TABLE_A”和序列

@Service
public class VersionDataImpl{
    @Autowired
    private VersionDataRepo dataRepo;
    @PersistenceContext
    private EntityManager em;

    @Transactional
    public void copyVersion(String newBranch, String sourceBranch) {

        copyVersionData(newBranch, sourceBranch);


    }

    @Transactional
    private void copyVersionData(String newBranch, String sourceBranch) {
        List<VersionData> versionDataLs = mddRepo.getDataByVersion(sourceBranch);

        for (VersionData  versionData : versionDataLs) {
            VersionData mdd = new VersionData();
            versionData.setDataType(mddData.getDataType());
            versionData.setMax(mddData.getMax());
            versionData.setMin(mddData.getMin());
            versionData.setPossibleValues(mddData.getPossibleValues());
            versionData.setVersion(newBranch);
            //dataRepo.insertBranchData();
            em.persist(versionData);
        }

    }

}

@Repository
public interface VersionDataRepo extends JpaRepository<VersionData, Integer>{

    String insertBranch = "INSERT INTO public.\"TB03_TABLE_A\"(\"VERSION\", \"DATATYPE\", \"MIN\", \"MAX\", \"POSSIBLE_VALUES\")\r\n" + 
            "VALUES ( :version, :datatype, :min, :max, :possibleValues)";

    @Query(nativeQuery = true,value = insertBranch)
    void insertBranchData();
}

2020-05-17 20:20:27.854  WARN 25832 --- [nio-8080-exec-2] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42P01
2020-05-17 20:20:27.854 ERROR 25832 --- [nio-8080-exec-2] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: relation "myschema.tb03_mdd_data" does not exist
  Position: 13
2020-05-17 20:20:27.865 ERROR 25832 --- [nio-8080-exec-2] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement] with root cause

org.postgresql.util.PSQLException: ERROR: relation "tb03_mdd_data" does not exist
  Position: 13
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2533) ~[postgresql-42.2.12.jar:42.2.12]
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2268) ~[postgresql-42.2.12.jar:42.2.12]
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:313) ~[postgresql-42.2.12.jar:42.2.12]
    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448) ~[postgresql-42.2.12.jar:42.2.12]
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369) ~[postgresql-42.2.12.jar:42.2.12]
    at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:159) ~[postgresql-42.2.12.jar:42.2.12]
    at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:125) ~[postgresql-42.2.12.jar:42.2.12]
    at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[HikariCP-3.4.3.jar:na]

我哪里出问题了？请救命！

提前感谢！

Answer 1

我以前也有同样的问题。最好的方法是使用要创建的表名创建一个类。这是因为，您的表名和类名不同。只需删除@table注释并使用类名作为表名即可。spring-boot本身没有检测到这个注释。因此，没有使用它的意义。我认为，必须在数据库上创建名为version_data的表。