Author: tchemit Date: 2013-11-10 09:20:13 +0100 (Sun, 10 Nov 2013) New Revision: 888 Url: http://forge.codelutin.com/projects/echobase/repository/revisions/888 Log: improve count of request Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/service/exportquery/GenericSQLQuery.java Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/service/exportquery/GenericSQLQuery.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/service/exportquery/GenericSQLQuery.java 2013-11-09 18:18:09 UTC (rev 887) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/service/exportquery/GenericSQLQuery.java 2013-11-10 08:20:13 UTC (rev 888) @@ -115,7 +115,31 @@ } } + /** + * From a given result set, let's count his number of row. + * <p/> + * <strong>Note:</strong> the result set must be scrollable to go back to + * before first row. + * + * @param set the result set to inspect + * @return the number of row of the given result set + * @throws SQLException if any pb + * @since 2.6.4 + */ @Override + protected long getNbRows(ResultSet set) throws SQLException { + + //TODO Bring this back to Topia + long nbRows = 0; + if (set.last()) { + nbRows = set.getRow(); + } + // go back before first row (be ware the resultset must be scrollable) + set.beforeFirst(); + return nbRows; + } + + @Override protected Map<String, Object> prepareResult(ResultSet set) throws SQLException { if (pager != null) {