/** Build and execute the row count query. */ public <T> int findRowCount(OrmQueryRequest<T> request) { CQueryRowCount rcQuery = queryBuilder.buildRowCountQuery(request); try { int rowCount = rcQuery.findRowCount(); if (request.isLogSql()) { String logSql = rcQuery.getGeneratedSql(); if (TransactionManager.SQL_LOGGER.isTraceEnabled()) { logSql += "; --bind(" + rcQuery.getBindLog() + ")"; } request.logSql(logSql); } if (request.isLogSummary()) { request.getTransaction().logSummary(rcQuery.getSummary()); } if (request.getQuery().isFutureFetch()) { logger.debug("Future findRowCount completed!"); request.getTransaction().end(); } return rowCount; } catch (SQLException e) { throw CQuery.createPersistenceException( e, request.getTransaction(), rcQuery.getBindLog(), rcQuery.getGeneratedSql()); } }
/** Build and execute the find Id's query. */ public <T> BeanIdList findIds(OrmQueryRequest<T> request) { CQueryFetchIds rcQuery = queryBuilder.buildFetchIdsQuery(request); try { BeanIdList list = rcQuery.findIds(); if (request.isLogSql()) { String logSql = rcQuery.getGeneratedSql(); if (TransactionManager.SQL_LOGGER.isTraceEnabled()) { logSql += "; --bind(" + rcQuery.getBindLog() + ")"; } request.logSql(logSql); } if (request.isLogSummary()) { request.getTransaction().logSummary(rcQuery.getSummary()); } if (!list.isFetchingInBackground() && request.getQuery().isFutureFetch()) { // end the transaction for futureFindIds (it had it's own one) logger.debug("Future findIds completed!"); request.getTransaction().end(); } return list; } catch (SQLException e) { throw CQuery.createPersistenceException( e, request.getTransaction(), rcQuery.getBindLog(), rcQuery.getGeneratedSql()); } }