/** Walk through all mapped entity's descriptors verifying that no data exists on the database */ private static void verifyDatabaseEmpty(EntityManager em) { Server server = JpaHelper.getEntityManager(em).getServerSession(); for (Iterator i = server.getDescriptors().values().iterator(); i.hasNext(); ) { RelationalDescriptor descriptor = (RelationalDescriptor) i.next(); if (!descriptor.isAggregateDescriptor()) { ReportQuery rq = new ReportQuery(descriptor.getJavaClass(), new ExpressionBuilder()); rq.addCount(); rq.setShouldReturnSingleValue(true); int count = -1; try { count = ((Number) server.executeQuery(rq)).intValue(); } catch (DatabaseException dbe) { } System.out.println("COUNT(" + descriptor.getAlias() + "): " + count); } } }