我有一個帶有由 UserRepository 尋址的 h2 資料庫的 Spring Boot 應用程式。我正在嘗試使用 Spring 安全性來使用 jdbc 進行身份驗證（此處為休眠）
@Entity
@Table(name="USER")
public class User {
@Id
@Column(name="USER_ID")
private long id;
@Column(name="USERNAME, nullable = false, unique = true")
private String username;
@Column(name="PASSWORD")
private String password;
/*setter/getter follows */
}
存盤庫：-
public interface UserRepository extends JpaRepository<User, Long>{
User findByUsername(String username);
}
SQL：
CREATE TABLE USER(
USER_ID BIGINT AUTO_INCREMENT PRIMARY KEY,
USERNAME VARCHAR(128) NOT NULL UNIQUE,
PASSWORD VARCHAR(256) NOT NULL
);
插入用戶（用戶名，密碼）值（'jdoe'，'foobar'）；
But when enter correct username and password, it is not accepting it.
Exception:
SQL Error: 42001, SQLState: 42001
2022-03-04 13:43:18.571 ERROR 17924 --- [nio-8080-exec-7] o.h.engine.jdbc.spi.SqlExceptionHelper : Syntax error in SQL statement "SELECT USER0_.USER_ID AS USER_ID1_0_, USER0_.PASSWORD AS PASSWORD2_0_, USER0_.USERNAME, NULLABLE = FALSE, UNIQUE[*] = TRUE AS USERNAME3_0_ FROM USER USER0_ WHERE USER0_.USERNAME, NULLABLE = FALSE, UNIQUE = TRUE=? "; expected "*, NOT, EXISTS, INTERSECTS, SELECT, FROM, WITH"; SQL statement:
select user0_.user_id as user_id1_0_, user0_.password as password2_0_, user0_.username, nullable = false, unique = true as username3_0_ from user user0_ where user0_.username, nullable = false, unique = true=? [42001-196]
uj5u.com熱心網友回復：
不錯的錯誤：
@Column(name="USERNAME, nullable = false, unique = true")
->
@Column(name="USERNAME", nullable = false, unique = true)
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/437439.html
上一篇：HashMap在for回圈中插入和檢索的時間復雜度是多少？
下一篇：CSS檔案未在不同的網址上加載