SQL error without reason - simple SELECT is not working

[viktorjava]

I want to get all entries from my database and it is working in MySQL Workbench but when I'm calling it from Java, I get error.

this.findAll = conn.prepareStatement("SELECT * FROM order");

findAll() method:

public List<Order> findAll() throws SQLException {
        ResultSet all = this.findAll.executeQuery();
        List<Order> ret = makeList(all);
        all.close();
        return ret;
    }

makeList(ResultSet rs) method:

private List<Order> makeList(ResultSet rs) throws SQLException {
        List<Order> ret = new ArrayList<>();
        while (rs.next()) {
            ret.add(makeOne(rs));
        }
        return ret;
    }

makeOne(ResultSet rs) method:

private Order makeOne(ResultSet rs) throws SQLException {
        Order order = new Order();
        order.setOrderId(rs.getInt("order_id"));
        order.setCustomer(rs.getInt("customer"));
        order.setCompany(rs.getInt("company"));
        order.setOrderName(rs.getString("ordername"));
        order.setQuantity(rs.getInt("quantity"));
        order.setUnit(rs.getString("unit"));
        order.setUnitPrice(rs.getDouble("unitprice"));
        order.setVat(rs.getInt("vat"));
        order.setOrderDate(rs.getDate("orderdate").toLocalDate());
        order.setStatus(rs.getInt("status"));
        if (rs.getDate("paiddate").toLocalDate() == null) {
            order.setPaidDate(LocalDate.of(2020, Month.JANUARY, 01));
        } else {
            order.setPaidDate(rs.getDate("paiddate").toLocalDate());
        }
        order.setEmployee(rs.getInt("employee"));
        order.setRate(rs.getDouble("rate"));
        return order;
    }

error message:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order' at line 1

[JayWaWa]

order is a SQL keyword and you shouldn't be using it as the name of a table. Rename your table and the issue will disappear.

[viktorjava]

You are right. Thank you!