java code in dspace to get collections an item belongs to
From Item.java we find:
TableRowIterator tri = DatabaseManager.queryTabl(ourContext,"collection",
"SELECT collection.* FROM collection, collection2item WHERE " +
"collection2item.collection_id=collection.collection_id AND " +
"collection2item.item_id= ? ",
itemRow.getIntColumn("item_id"));