String myQuery = null;  if ("oracle".equals(ConfigurationManager.getProperty("db.name"))) { myQuery = "SELECT * FROM item WHERE in_archive=1"; } else {  myQuery = "SELECT * FROM item WHERE in_archive=true"; }
String myQuery = "SELECT * FROM item WHERE in_archive='1'";
    public static ItemIterator findAll(Context context) throws SQLException    {        String myQuery = null;        if ("oracle".equals(ConfigurationManager.getProperty("db.name")))        {            myQuery = "SELECT * FROM item WHERE in_archive=1";        }        else        {            // default postgres            myQuery = "SELECT * FROM item WHERE in_archive=true";        }        TableRowIterator rows = DatabaseManager.query(context, "item", myQuery);        return new ItemIterator(context, rows);    }