Java.sql.SQLSyntaxErrorException: Unknown Column 'firstBuildCardDate' in 'where clause' - SQL Error Resolution

This error indicates that the database table 'eqpt_equipment' lacks a column named 'firstBuildCardDate'. To resolve this, you need to add the 'firstBuildCardDate' column to the table. You can use the following SQL statement to add the column:

ALTER TABLE eqpt_equipment ADD COLUMN firstBuildCardDate DATE;

After adding the column, retry the query. This should resolve the error.