Код: Выделить всё
Unable to bind parameter #7 - 4014 [Invalid column index] [n/a]
< /code>
Резолюция кажется простым, несоответствие между Spring Entity и таблицей столбцов ... но ... < /p>
Здесь моя сущность < /p>
@Data
@DynamicUpdate
@Entity
@Table(name="RETRY_PROCESSES")
public class RetryEntity {
public enum RowType{RETRY,DLQ,COMPLETED}
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "retry_seq")
@SequenceGenerator(name = "retry_seq", sequenceName = "RETRY_PROCESSES_SEQ", allocationSize = 1)
private Long id;
@Column(name="reservation_id")
private String reservationId;
@Column(name="reservation_timestamp")
private LocalDateTime reservationTimestamp;
@Column(name="row_type")
@Enumerated(EnumType.STRING)
private RowType rowType;
@Column(name="max_retry")
private Integer maxRetry;
@Column(name="retry_count")
private Integer retryCount;
@Column(name="next_retry_timestamp", columnDefinition="TIMESTAMP")
private LocalDateTime nextRetryTimestamp;
@Column(name="creation_timestamp", columnDefinition="TIMESTAMP")
private LocalDateTime creationTimestamp;
@Column(name="update_timestamp", columnDefinition="TIMESTAMP")
private LocalDateTime updateTimestamp;
@Column(name="flow")
@Enumerated(EnumType.STRING)
private FlowType flow;
@Column(name="action")
@Enumerated(EnumType.STRING)
private ActionType action;
@Column(name="error_code")
private String errorCode;
@Column(name="error_message")
private String errorMessage;
@Lob
@JdbcTypeCode(SqlTypes.CLOB)
@Column(name="json")
private String json;
@Column(name="key_name")
private String keyName;
@Column(name="key_value")
private String keyValue;
}
< /code>
Здесь мой db ddl < /p>
Name Null? Type
--------------------- -------- -------------
RESERVATION_ID VARCHAR2(20)
RESERVATION_TIMESTAMP TIMESTAMP(6)
ROW_TYPE VARCHAR2(10)
MAX_RETRY NUMBER
RETRY_COUNT NUMBER
NEXT_RETRY_TIMESTAMP TIMESTAMP(6)
CREATION_TIMESTAMP TIMESTAMP(6)
UPDATE_TIMESTAMP TIMESTAMP(6)
FLOW VARCHAR2(10)
ACTION VARCHAR2(25)
ERROR_CODE VARCHAR2(25)
ERROR_MESSAGE VARCHAR2(400)
JSON CLOB
KEY_NAME VARCHAR2(50)
KEY_VALUE VARCHAR2(50)
ID NOT NULL NUMBER
< /code>
The Stacktrace log < /p>
Hibernate: update retry_processes set next_retry_timestamp=?,reservation_id=?,reservation_timestamp=?,retry_count=?,update_timestamp=?,json=? where id=?
2025-09-02T15:22:43.456+02:00 TRACE 26028 --- [ scheduling-1] org.hibernate.orm.jdbc.bind : binding parameter (1:TIMESTAMP)
Подробнее здесь: [url]https://stackoverflow.com/questions/79753658/spring-jpa-invalid-column-index-error-on-update[/url]