博客开通第68天

出现java.sql.SQLException: ORA-00904: "DELETE_FLAG": 标识符无效

查找实现类里的select语句。

String GET_ALL_ITEMS_ALLCOUNT = "SELECT COUNT(1) FROM B_M_Inform";
String GET_ALL_ITEMS = "SELECT ID,TITLE, DELETE_FLAG FROM B_M_Inform";

应该改成

String GET_ALL_ITEMS_ALLCOUNT = "SELECT COUNT(1) FROM B_M_Inform";
String GET_ALL_ITEMS = "SELECT ID,TITLE, STATUS FROM B_M_Inform";