我有 JPA 問題我在執行查詢 SQL 錯誤時遇到問題：0，SQLState：42601，錯誤：“$1”處或附近的語法錯誤
@Entity
@Table(name="vechile_master")
public class VehicleMaster extends Auditable<Long>{
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private int id;
@OneToOne
@JoinColumn(name="device_id",referencedColumnName = "id")
private DeviceMaster deviceId;
}
@Repository
public interface VehicleMasterRepo extends JpaRepository<VehicleMaster,Integer>{
@Query(value="select * from VehicleMaster vm where vm.device_id :deviceId",nativeQuery = true)
public Object[][] getByDeviceId(@Param("deviceId")int deviceId);
}
uj5u.com熱心網友回復：
此陳述句缺少等號
select * from VehicleMaster vm where vm.device_id = :deviceId
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/393618.html