String myQuery = null;  if ("oracle".equals(ConfigurationManager.getProperty("db.name"))) { myQuery = "SELECT * FROM bitstreamformatregistry WHERE internal=0 " + "AND short_description NOT LIKE 'Unknown' " + "ORDER BY support_level DESC, short_description"; } else {  myQuery = "SELECT * FROM bitstreamformatregistry WHERE internal=false " + "AND short_description NOT LIKE 'Unknown' " + "ORDER BY support_level DESC, short_description"; }
String myQuery = "SELECT * FROM bitstreamformatregistry WHERE internal='0' " + "AND short_description NOT LIKE 'Unknown' " + "ORDER BY support_level DESC, short_description";
    public static BitstreamFormat[] findNonInternal(Context context)            throws SQLException    {        List formats = new ArrayList();        String myQuery = null;        if ("oracle".equals(ConfigurationManager.getProperty("db.name")))        {            myQuery = "SELECT * FROM bitstreamformatregistry WHERE internal=0 "                    + "AND short_description NOT LIKE 'Unknown' "                    + "ORDER BY support_level DESC, short_description";        }        else        {            // default postgres, use boolean            myQuery = "SELECT * FROM bitstreamformatregistry WHERE internal=false "                    + "AND short_description NOT LIKE 'Unknown' "                    + "ORDER BY support_level DESC, short_description";        }        TableRowIterator tri = DatabaseManager.query(context,                "bitstreamformatregistry", myQuery);        while (tri.hasNext())        {            TableRow row = tri.next();            // From cache?            BitstreamFormat fromCache = (BitstreamFormat) context.fromCache(                    BitstreamFormat.class, row                            .getIntColumn("bitstream_format_id"));            if (fromCache != null)            {                formats.add(fromCache);            }            else            {                formats.add(new BitstreamFormat(context, row));            }        }        // close the TableRowIterator to free up resources        tri.close();        // Return the formats as an array        BitstreamFormat[] formatArray = new BitstreamFormat[formats.size()];        formatArray = (BitstreamFormat[]) formats.toArray(formatArray);        return formatArray;    }