String myQuery = null;  if ("oracle".equals(ConfigurationManager.getProperty("db.name"))) { myQuery = "SELECT item.* FROM item, collection2item WHERE " + "item.item_id=collection2item.item_id AND " + "collection2item.collection_id=" + getID() + " AND item.in_archive=1"; } else {  myQuery = "SELECT item.* FROM item, collection2item WHERE " + "item.item_id=collection2item.item_id AND " + "collection2item.collection_id=" + getID() + " AND item.in_archive=true"; }
String myQuery = "SELECT item.* FROM item, collection2item WHERE " + "item.item_id=collection2item.item_id AND " + "collection2item.collection_id=" + getID() + " AND item.in_archive='1'";
    public ItemIterator getItems() throws SQLException    {        String myQuery = null;        if ("oracle".equals(ConfigurationManager.getProperty("db.name")))        {            myQuery = "SELECT item.* FROM item, collection2item WHERE "                    + "item.item_id=collection2item.item_id AND "                    + "collection2item.collection_id=" + getID()                    + " AND item.in_archive=1";        }        else        {            // default postgres, use boolean            myQuery = "SELECT item.* FROM item, collection2item WHERE "                    + "item.item_id=collection2item.item_id AND "                    + "collection2item.collection_id=" + getID()                    + " AND item.in_archive=true";        }        TableRowIterator rows = DatabaseManager.query(ourContext, "item",                myQuery);        return new ItemIterator(ourContext, rows);    }