我遇到的第一個錯誤無效操作:不支持 SQL 命令“如果存在 hibernate_sequence,則刪除序列”在例外情況的更下方,我看到以下內容。我假設我必須更改 hibernate_sequence 中索引遞增的方式。Caused by: com.amazon.support.exceptions.ErrorException: [Amazon](500310) Invalid operation: SQL command "create sequence hibernate_sequence start 1 increment 1" not supported.; ... 49 common frames omitted2019-10-07 14:02:30,237 WARN [main] org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl: GenerationTarget encountered exception accepting command : Error executing DDL "create sequence hibernate_sequence start 1 increment 1" via JDBC Statementorg.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create sequence hibernate_sequence start 1 increment 1" via JDBC Statement在構建 java Spring Boot 應用程序時,尋求連接并創建新的 redshift DB Cluster V1.0.10393。POM 和屬性文件應該是什么樣子?我正在從工作 PostgreSQL 數據庫過渡到 redshift。當前屬性spring.datasource.driver-class-name=com.amazon.redshift.jdbc42.Driverspring.datasource.url=jdbc:redshift://redshift-cluster-1.cwirererbv4xb.us-east-2.redshift.amazonaws.com:5439/dbspring.datasource.username=awsuserspring.datasource.password=werwerwerewspring.jpa.hibernate.ddl-auto=createspring.jpa.show-sql=truespring.jpa.properties.hibernate.temp.use_jdbc_metadata_defaults=falsespring.jpa.properties.hibernate.dialect = org.hibernate.dialect.PostgreSQL9Dialectspring.datasource.hikari.connectionTimeout=20000spring.datasource.hikari.maximumPoolSize=5spring.jpa.properties.hibernate.jdbc.lob.non_contextual_creation=truespring.jpa.open-in-view=falsespring.jpa.hibernate.ddl-auto=create
添加回答
舉報
0/150
提交
取消