/** * read in all the PerformanceArticles from the RDBMS that have been inserted by <code> * insertNewArticles()</code>. The lookup is done one by one, that is: a primary key based lookup * is used. */ protected void readArticles() throws Exception { TransactionExt tx = (TransactionExt) odmg.newTransaction(); // we don't want implicite locks when compare performance tx.setImplicitLocking(false); String sql = "select allArticles from " + PerformanceArticle.class.getName() + " where articleId=$1"; long start = System.currentTimeMillis(); tx.begin(); for (int i = 0; i < articleCount; i++) { OQLQuery query = odmg.newOQLQuery(); query.create(sql); query.bind(arr[i].getArticleId()); query.execute(); } tx.commit(); long stop = System.currentTimeMillis(); logger.info("querying " + articleCount + " Objects: " + (stop - start) + " msec"); }