'I am receiving a syntax error on "reimbursement_resolver" in the string line for index 5. My DAO package is set up correctly, yet this still occurs

 @Override
public Reimbursement updateReimbursement(Reimbursement r) {
    Connection c = cs.getConnection();
    String sql = "UPDATE reimbursement " +
            "SET amount = ?, " + //index 1
            "submitted_date = ?, " + //index 2
            "resolved_date = ?, " + //index 3
            "description = ? " + //index 4
            "reimbursement_resolver = ? " + //index 5
            "reimbursement_status = ? " + //index 6
            "reimbursement_type = ? "; //index 7


    try{
        PreparedStatement p = c.prepareStatement(sql);


        p.setDouble(1, r.getAmount());
        p.setDate(2, r.getSubmittedDate());
        p.setDate(3, r.getResolvedDate());
        p.setString(4, r.getDescription());
        p.setInt(5, r.getReimbursementResolver().getEmpolyeeId());
        p.setInt(6, r.getReimbursementStatus());
        p.setInt(7, r.getReimbursementType());

        p.execute();
        return r;

    } catch(SQLException e){
        e.printStackTrace();
        return null;
    }
}

In IntelliJ it says "syntax error" on "reimbursement_resolver" but IntelliJ doesn't list the correct position, just "at or near". I don't know how to fix a syntax error when I don't see one explicitly stated with the red squigly line.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source